The six most important read_csv arguments in Pandas

  Рет қаралды 3,259

Python and Pandas with Reuven Lerner

Python and Pandas with Reuven Lerner

Күн бұрын

Do you work with CSV files? Of course you do! It's by far the most common format. And the read_csv function supports dozens of arguments -- so many that it's often hard to know where to start reading the documentation.
In this video, I show you the six arguments for read_csv that you're most likely to need. I then demonstrate them with real data files, in Jupyter. (You can download my notebook, plus the data files, from github.com/reu... .)

Пікірлер: 12
@gdvissch
@gdvissch Жыл бұрын
I used to read your articles in Linux Journal before reading the rest of the magazine. Glad to have found you back here, and with interesting content… subscribed!
@ReuvenLerner
@ReuvenLerner Жыл бұрын
So delighted that you found me here! Thanks for the very kinds words; I really miss the LJ days.
@gdvissch
@gdvissch Жыл бұрын
I guess sometimes “The Algorithm” does good things too. I immediately recognised your name. The picture is different though (but not a lot 😜)
@munivoltarc
@munivoltarc Жыл бұрын
I am seeing your python educational videos every video is amazingly simple and easy to learn to novice, thanks for your service to many across the world
@ReuvenLerner
@ReuvenLerner Жыл бұрын
I'm delighted that you're enjoying the videos! Thanks for your kind words.
@Scooterboy_and_others109
@Scooterboy_and_others109 Жыл бұрын
Fantastic Demo, To the point with good simple examples
@ReuvenLerner
@ReuvenLerner Жыл бұрын
Glad to hear; thanks!
@The.WorldVentures
@The.WorldVentures 6 ай бұрын
Thank you so much, you have saved my a***
@ReuvenLerner
@ReuvenLerner 6 ай бұрын
Fantastic; I'm delighted to hear it!
@John-pb7gb
@John-pb7gb 4 ай бұрын
How can we a csv file if we have an uneven number of columns? Let's say the header row has Name, Phone number, and Address separated by comma, but only some of the data in the Address column has more commas(ex: St.Vincent road, Dallas, TX) something like this. How should I read the file
@ReuvenLerner
@ReuvenLerner 3 ай бұрын
CSV files need to have the same number of columns in each row. You can sometimes get away with null values, if there are commas next to each other, but I don't believe that you can ever have variable-length lows.
Flipping Data with Pandas: Stack & Unstack
8:17
Python and Pandas with Reuven Lerner
Рет қаралды 2,9 М.
Method chaining in Pandas
18:17
Python and Pandas with Reuven Lerner
Рет қаралды 2,1 М.
РОДИТЕЛИ НА ШКОЛЬНОМ ПРАЗДНИКЕ
01:00
SIDELNIKOVVV
Рет қаралды 3,3 МЛН
规则,在门里生存,出来~死亡
00:33
落魄的王子
Рет қаралды 27 МЛН
This INCREDIBLE trick will speed up your data processes.
12:54
Rob Mulla
Рет қаралды 266 М.
DuckDB in Python - The Next Pandas Killer?
19:32
NeuralNine
Рет қаралды 31 М.
Understanding "with" and Python's context managers
14:00
Python and Pandas with Reuven Lerner
Рет қаралды 1 М.
5 Jupyter Notebook Tips & Tricks to Improve your Data Science Workflow!
23:17
Boolean indexing in Pandas made simple
8:23
Python and Pandas with Reuven Lerner
Рет қаралды 2 М.
Selecting rows in Pandas using .loc and lambda
9:04
Python and Pandas with Reuven Lerner
Рет қаралды 1,1 М.
Pivot tables with Pandas
9:00
Python and Pandas with Reuven Lerner
Рет қаралды 41 М.
The new case_when method in Pandas 2.2.0
10:07
Python and Pandas with Reuven Lerner
Рет қаралды 1,4 М.
This Is Why Python Data Classes Are Awesome
22:19
ArjanCodes
Рет қаралды 808 М.
РОДИТЕЛИ НА ШКОЛЬНОМ ПРАЗДНИКЕ
01:00
SIDELNIKOVVV
Рет қаралды 3,3 МЛН