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 numbersSelect 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.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,2007Almost 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.
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
- Exploratory Data Analysis: Your First 30 Minutes with a New Dataset
- Claude Code for Beginners: Your First Session with Data
- Dates That Don't Break: Days, Months, and Times in Your Data
- Claude Code for Data Analysis: An Agentic AI Course
- Clean Your Data Without Breaking It
- Python for Altair: The Basics for Data People
Learn more
Related terms
- 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.