Skip to content

CSV

A CSV (comma-separated values) is a plain-text file that holds a table: one row per line, with commas between the columns.

How to do it: open a CSV file without breaking accents or numbers

Select any words here to ask your Maestro about them.

How to do it

Open a CSV file without breaking accents or numbers

How to tell it worked. You see one column per field, accents spelled right and numbers aligned right. If everything landed in column A, the separator was a semicolon.

Ask an AI assistant

For your own sheet, in ChatGPT, Claude or Copilot: copy the prompt and fill in the brackets.

I have a CSV file where it comes from that looks wrong when I open it in Excel what's wrong: accents, columns, numbers. Walk me through importing it properly in Excel and reading it with pandas.
Prompt

Write yours in the highlighted parts. Anything left in brackets reaches your agent as is.

The first line usually holds the column names:

country,continent,yearChile,Americas,2007

Almost every tool reads one: Excel, R's read.csv(), Stata's import delimited and pandas' pd.read_csv(). A CSV is just text, so it carries no types. pandas works out each column's type as it loads the file, and df.dtypes shows what it decided.

Ask your Maestro about CSV

It answers from a free course page that uses this word, the way it answers while you study.

Example

You: What does "CSV" mean, in plain words?

Your Maestro: I'll explain it with a case of yours: it sticks better than a definition. Want to see which type pandas gave each column?

Asking about: Answers from the page "How do I do a complete first look at a table and write it down?"

Only this browser keeps what you ask here. How it works

In Maestro's courses

Learn more

  • pandas

    pandas is a Python package for working with tables of data, called DataFrames: loading them, filtering rows, picking columns and summarizing them.

  • Path

    A path is a file's address on your computer: the folders you go through to reach it, ending in the file's name, like projects/python-for-altair/life_expectancy.csv.

The whole glossary