Python CSV Module - Reading Files and Skipping Rows

Показать описание

In this video, we'll learn how to read CSV data from a file into Python applications, using the csv module.

Finally, we'll quickly demonstrate how easy it is to load CSV data into Pandas DataFrames.

▶️ Full Playlist:

📌 𝗖𝗵𝗮𝗽𝘁𝗲𝗿𝘀:
00:00 Intro
01:22 Reading file with csv reader
03:15 Reading file with csv DictReader
04:58 Skipping row with next() built-in
07:49 Skipping multiple rows with next() built-in
08:16 Skipping rows with itertools islice function
09:45 Reading CSV file with Pandas

☕️ 𝗕𝘂𝘆 𝗺𝗲 𝗮 𝗰𝗼𝗳𝗳𝗲𝗲:
To support the channel and encourage new videos, please consider buying me a coffee here:

𝗦𝗼𝗰𝗶𝗮𝗹 𝗠𝗲𝗱𝗶𝗮:

📚 𝗙𝘂𝗿𝘁𝗵𝗲𝗿 𝗿𝗲𝗮𝗱𝗶𝗻𝗴 𝗮𝗻𝗱 𝗶𝗻𝗳𝗼𝗿𝗺𝗮𝘁𝗶𝗼𝗻:

#python #csv #pandas

BugBytes

Рекомендации по теме

Комментарии

and here's one that skips ALL commented lines! (i.e. line starts with '#')
import csv

def read_csv():
''' Creates a generator with uncmmented rows in csv '''
with open('test.csv', 'r') as csvfile:
reader = csv.DictReader(csvfile, delimiter=';')
headers = reader.fieldnames
for k in reader:
if not
yield k

# --- usage
items = read_csv()
for item in items:
print(item)

ulfgj

very useful video on an important topic in Python. The repos and gists are very helpful.

iwswordpress

Always got some to learn with you mate. Keep going !

seydinaoumarsamabaly

Great video, helped me solve a DF issue I was having.

trevorbanning

This really cool!! Your video is very easy to understand!! Hope you will do more video!!

lruslip

Just saved my uni assignment, thanks lol🤣

Illack

You are a lowkey guy teacher! hope you get big soon, your htmx series was helpful to me!

imbesrs

Another great video! Would love to see a tutorial on how to run automated/scheduled tasks from a Django project.

studioteque

Is csvreader the best module for analyzing a csv file? For example, reading from any csv-line, jumping around randomly?

For example, I'd like to display a csv-line in a gui (one line at a time), but would like for the user/gui thread to tell the csv thread to skip to line X, or to rewind to 10 lines?

bennguyen

How to skip particularly few rows in between from the csv file

susantasarkar

Lovely video. I want to ask a question, if you want to read only one like from your DictReader, analyse the line and remove it from the file

oyeleyeolalekan

Python CSV Module - Reading Files and Skipping Rows

Python Tutorial: CSV Module - How to Read, Parse, and Write CSV Files

Python CSV Module - Reading Files and Skipping Rows

Reading CSV Files With Python's csv Module

CSV Files in Python || Python Tutorial || Learn Python Programming

CSV Files with Python — Reading and Writing

How to read CSV file in Python | Python CSV Module | Python Tutorial | Edureka

How to Work with CSV Files in Python: Built-in CSV Module Tutorial

Python Tutorial: CSV Module - How to Read, Parse, and Write CSV Files | Python CSV files

Live stream Python 10 hours part 29

How to pull data from a CSV file in Python

Read CSV Files in Python with csv.DictReader - Iterate through Rows as Dicts with Columns as Keys

Python CSV Module How to read from, write to CSV files, open in Excel

Reading a CSV file into a Python Dictionary

Python - CSV module

CSV File Handling in Python - Read, Write, Append in CSV File, CSV Module - Reader / Writer Object

CSV Module Python Programming Basics For Beginners #29

Read CSV File In Python

Read CSV Files in Python | CSV Module

Python for Beginners: CSV Parsing (Part 1) - Parsing a Simple CSV File

Python Tutorial: CSV Module - How to Read, Parse, and Write CSV Files? - ALL CRUD Operations

Python 101: Episode #13 - The csv module

Python CSV files - with PANDAS

PYTHON : Read specific columns from a csv file with csv module?

33 | Python Tutorial for Beginners | CSV Module - How to Read,Write CSV Files-Part 1