Python on Speed ⚡: 29. Read/Write CSV in Python
Master reading and writing CSV files in Python in 60 seconds! 🐍 In this beginner-friendly tutorial, you’ll learn how to read CSV in Python, how to write CSV in Python, and when to use the built-in csv module vs pandas.read_csv and DataFrame.to_csv. Perfect for Python beginners, data analysis, and quick automation.
💡 What you’ll learn
• Read CSV with csv.reader and csv.DictReader
• Write CSV with csv.writer and csv.DictWriter
• One-liners with pandas.read_csv / to_csv(index=False)
• Common gotchas: UTF-8 encoding, newline='' on Windows, delimiters (;), quoting
🧩 Code used
Built-in csv
import csv
with open("data.csv", newline="", encoding="utf-8") as f:
reader = csv.reader(f)
header = next(reader)
for row in reader:
name, score = row[0], int(row[1])
print(name, score)
with open("out.csv", "w", newline="", encoding="utf-8") as f:
writer = csv.writer(f); writer.writerows([["name","score"],["Alice",92]])
DictReader / DictWriter
with open("data.csv", newline="", encoding="utf-8") as f:
for row in csv.DictReader(f):
print(row["name"], int(row["score"]))
with open("out.csv", "w", newline="", encoding="utf-8") as f:
w = csv.DictWriter(f, fieldnames=["name","score"])
w.writeheader(); w.writerow({"name":"Cara","score":99})
pandas
import pandas as pd
df = pd.read_csv("data.csv")
df.to_csv("out.csv", index=False)
⛏️ Pro tips
• Numbers arrive as strings → cast with int() / float()
• Custom separator → delimiter=';'
• Quoting → quotechar='"', quoting=csv.QUOTE_MINIMAL
• Big files → prefer csv (streaming); analysis & cleaning → pandas
👇 If this helped, like, subscribe, and comment “CSV” so I can send a cheat sheet!
#Python #CSV #Pandas #LearnToCode #Shorts
On this page of the site you can watch the video online Python on Speed ⚡: 29. Read/Write CSV in Python with a duration of hours minute second in good quality, which was uploaded by the user Bodan Labs 13 September 2025, share the link with friends and acquaintances, this video has already been watched 163 times on youtube and it was liked by 2 viewers. Enjoy your viewing!
