Your country

Tools that support it use your country for local currency, number formats, units and paper size. Your choice is saved only in this browser.

Type a name or a two-letter code. Use the up and down arrow keys to move through the countries, Enter to choose one and Escape to close.

MySmartCoPilot Learn

Data and databases

Working with data: asking a clear question, getting the data that answers it into shape, and reading the result honestly.

8 tracks with lessons

Start with the question

Analysis goes wrong most often before any code runs: the question is vague, or the data cannot answer it. Write the decision the analysis should support in one sentence, then list the columns you would need to make it. If a column is missing, or measured differently from what you assumed, you have found the real work.

Check the data before you trust it

Look at the rows, not only the totals. Count the missing values, the duplicates and the impossible ones, such as negative ages or dates in the future, and decide what each one means before you drop it.

Keep every cleaning step in code, so you can run it again when the data changes and show someone else exactly what you did.

Say how sure you are

A chart or a summary should answer the question you started with. Say how many rows it rests on, what you left out and why, and resist reading a cause into a pattern that may be chance.

Prefer a few clear charts to many: label each axis with its unit, start bars at zero, and put the comparison that matters side by side.

Quick answers and tool search

Type to search tools or to get a quick answer, for example 18% of 2500. Use the up and down arrow keys to move through the results, Enter to choose, and Escape to close.