Think of a CSV file as a super basic spreadsheet, but it\u2019s just a text file. Each line is a row, and columns are split by commas (or sometimes other characters like tabs). Imagine you\u2019re planning a movie night and have a list like this in a file called This format is great because it\u2019s simple and works with tons of programs, like Excel or Google Sheets. You might use CSVs to store lists, track budgets, or handle data for a project. Python makes it easy to read, write, and tweak these files.<\/p>\n\n\n\n Python\u2019s like your best friend who\u2019s good at everything but doesn\u2019t make it complicated. It has two main ways to handle CSVs:<\/p>\n\n\n\n Let\u2019s break down how to use both with examples that feel like real life.<\/p>\n\n\n\n The Say you\u2019ve got your What\u2019s going on?<\/strong><\/p>\n\n\n\n Output<\/strong>:<\/p>\n\n\n\n If you want something even easier, use This is like calling people by their names instead of \u201cPerson in Row 1.\u201d It\u2019s easier to read and less likely to mess up.<\/p>\n\n\n\n Now, let\u2019s say you want to make a new CSV file to track who\u2019s bringing snacks for movie night. Here\u2019s how:<\/p>\n\n\n\n What\u2019s happening?<\/strong><\/p>\n\n\n\n Your You can also use This does the same thing but uses dictionaries, which is handy if your data is already in that format.<\/p>\n\n\n\n If the You\u2019ll need to install Let\u2019s read our Output<\/strong>:<\/p>\n\n\n\n A DataFrame is like a spreadsheet you can play with in Python. Want to find guests who are over 28?<\/p>\n\n\n\n Output<\/strong>:<\/p>\n\n\n\n Let\u2019s add a column for snacks and save it:<\/p>\n\n\n\n This creates a clean CSV file without extra numbers (the index) that Sometimes, CSV files are messy missing info or weird values. Let\u2019s say your Here\u2019s how to clean it up with Output<\/strong>:<\/p>\n\n\n\n This fixes missing values and makes sure the Let\u2019s say you\u2019re also tracking snacks and their costs in a file called You want to figure out the total cost and save it. Here\u2019s how with Output<\/strong>:<\/p>\n\n\n\n Your movie_night.csv<\/code>:<\/p>\n\n\n\nname,age,favorite_movie\nAlice,25,Inception\nBob,30,The Matrix\nCharlie,28,Star Wars\n<\/code><\/pre>\n\n\n\nWhy Use Python for CSVs?<\/h2>\n\n\n\n
\n
csv<\/code> module<\/strong>: Simple and perfect for basic tasks.<\/li>\n\n\n\npandas<\/code> library<\/strong>: A powerhouse for when you\u2019re doing more complex stuff, like analyzing big\u1e96 datasets.<\/li>\n<\/ul>\n\n\n\nUsing the
csv<\/code> Module<\/h2>\n\n\n\ncsv<\/code> module is like a trusty pen and paper simple and gets the job done. It\u2019s built into Python, so you don\u2019t need to install anything.<\/p>\n\n\n\nReading a CSV File<\/h3>\n\n\n\n
movie_night.csv<\/code> file and want to read it. Here\u2019s how:<\/p>\n\n\n\nimport csv\n\nwith open('movie_night.csv', 'r') as file:\n reader = csv.reader(file)\n header = next(reader) # Skip the header (name,age,favorite_movie)\n for row in reader:\n print(f\"{row[0]} is {row[1]} and loves {row[2]}!\")\n<\/code><\/pre>\n\n\n\n\n
with<\/code> statement it\u2019s like borrowing a book and making sure to return it properly.<\/li>\n\n\n\ncsv.reader<\/code> turns each row into a list, so row[0]<\/code> is the name, row[1]<\/code> is the age, etc.<\/li>\n\n\n\nnext(reader)<\/code> skips the header row so we only get the actual data.<\/li>\n<\/ul>\n\n\n\nAlice is 25 and loves Inception!\nBob is 30 and loves The Matrix!\nCharlie is 28 and loves Star Wars!\n<\/code><\/pre>\n\n\n\ncsv.DictReader<\/code>. It treats each row like a dictionary, so you can use column names instead of numbers:<\/p>\n\n\n\nimport csv\n\nwith open('movie_night.csv', 'r') as file:\n reader = csv.DictReader(file)\n for row in reader:\n print(f\"{row['name']} is {row['age']} and loves {row['favorite_movie']}!\")\n<\/code><\/pre>\n\n\n\nWriting a CSV File<\/h3>\n\n\n\n
import csv\n\n# Your movie night data\nguests = [\n ['name', 'age', 'snack'],\n ['Alice', 25, 'Popcorn'],\n ['Bob', 30, 'Chips'],\n ['Charlie', 28, 'Candy']\n]\n\nwith open('movie_snacks.csv', 'w', newline='') as file:\n writer = csv.writer(file)\n for row in guests:\n writer.writerow(row)\n<\/code><\/pre>\n\n\n\n\n
csv.writer<\/code> writes each row to movie_snacks.csv<\/code>.<\/li>\n\n\n\nnewline=''<\/code> makes sure the file works the same on any computer (Windows, Mac, whatever).<\/li>\n<\/ul>\n\n\n\nmovie_snacks.csv<\/code> will look like:<\/p>\n\n\n\nname,age,snack\nAlice,25,Popcorn\nBob,30,Chips\nCharlie,28,Candy\n<\/code><\/pre>\n\n\n\ncsv.DictWriter<\/code> if you\u2019re working with dictionaries:<\/p>\n\n\n\nimport csv\n\nguests = [\n {'name': 'Alice', 'age': 25, 'snack': 'Popcorn'},\n {'name': 'Bob', 'age': 30, 'snack': 'Chips'},\n {'name': 'Charlie', 'age': 28, 'snack': 'Candy'}\n]\n\nwith open('movie_snacks.csv', 'w', newline='') as file:\n fieldnames = ['name', 'age', 'snack']\n writer = csv.DictWriter(file, fieldnames=fieldnames)\n writer.writeheader() # Add the header\n for guest in guests:\n writer.writerow(guest)\n<\/code><\/pre>\n\n\n\nStepping Up with
pandas<\/code><\/h2>\n\n\n\ncsv<\/code> module is like a pen and paper, pandas<\/code> is like a fancy app that does everything for you. It\u2019s perfect for bigger files or when you want to analyze or clean data.<\/p>\n\n\n\nInstalling
pandas<\/code><\/h3>\n\n\n\npandas<\/code> first:<\/p>\n\n\n\npip install pandas\n<\/code><\/pre>\n\n\n\nReading a CSV with
pandas<\/code><\/h3>\n\n\n\nmovie_night.csv<\/code> again:<\/p>\n\n\n\nimport pandas as pd\n\n# Load the CSV into a DataFrame\ndf = pd.read_csv('movie_night.csv')\nprint(df)\n<\/code><\/pre>\n\n\n\n name age favorite_movie\n0 Alice 25 Inception\n1 Bob 30 The Matrix\n2 Charlie 28 Star Wars\n<\/code><\/pre>\n\n\n\nolder_guests = df[df['age'] > 28]\nprint(older_guests)\n<\/code><\/pre>\n\n\n\n name age favorite_movie\n1 Bob 30 The Matrix\n<\/code><\/pre>\n\n\n\nWriting a CSV with
pandas<\/code><\/h3>\n\n\n\nimport pandas as pd\n\n# Create a DataFrame\ndf = pd.DataFrame({\n 'name': ['Alice', 'Bob', 'Charlie'],\n 'age': [25, 30, 28],\n 'snack': ['Popcorn', 'Chips', 'Candy']\n})\n\n# Save to CSV\ndf.to_csv('movie_snacks_pandas.csv', index=False)\n<\/code><\/pre>\n\n\n\npandas<\/code> might add.<\/p>\n\n\n\nCleaning Up Messy Data<\/h3>\n\n\n\n
movie_night.csv<\/code> looks like this:<\/p>\n\n\n\nname,age,favorite_movie\nAlice,25,Inception\nBob,N\/A,The Matrix\nCharlie,28,\n<\/code><\/pre>\n\n\n\npandas<\/code>:<\/p>\n\n\n\nimport pandas as pd\n\n# Read CSV, treat 'N\/A' as missing\ndf = pd.read_csv('movie_night.csv', na_values=['N\/A'])\n\n# Fill missing values\ndf['favorite_movie'].fillna('Unknown', inplace=True)\ndf['age'].fillna(0, inplace=True)\n\n# Make age a whole number\ndf['age'] = df['age'].astype(int)\n\n# Save the cleaned file\ndf.to_csv('cleaned_movie_night.csv', index=False)\nprint(df)\n<\/code><\/pre>\n\n\n\n name age favorite_movie\n0 Alice 25 Inception\n1 Bob 0 The Matrix\n2 Charlie 28 Unknown\n<\/code><\/pre>\n\n\n\nage<\/code> column is numbers, not text. It\u2019s like tidying up your movie night plans so everything\u2019s clear.<\/p>\n\n\n\nA Quick Real-Life Example: Movie Night Budget<\/h2>\n\n\n\n
snacks_budget.csv<\/code>:<\/p>\n\n\n\nitem,quantity,price\nPopcorn,2,5\nChips,3,3\nCandy,1,4\n<\/code><\/pre>\n\n\n\npandas<\/code>:<\/p>\n\n\n\nimport pandas as pd\n\n# Read the CSV\ndf = pd.read_csv('snacks_budget.csv')\n\n# Calculate total cost per item\ndf['total'] = df['quantity'] * df['price']\n\n# Get the grand total\ngrand_total = df['total'].sum()\n\n# Save to a new CSV\ndf.to_csv('snacks_totals.csv', index=False)\nprint(df)\nprint(f\"Total Cost: ${grand_total}\")\n<\/code><\/pre>\n\n\n\n item quantity price total\n0 Popcorn 2 5 10\n1 Chips 3 3 9\n2 Candy 1 4 4\nTotal Cost: $23\n<\/code><\/pre>\n\n\n\nsnacks_totals.csv<\/code> now has the totals, and you know exactly how much you\u2019re spending on snacks!<\/p>\n\n\n\nTips to Make CSV Handling Easy<\/h2>\n\n\n\n
\n
with<\/code> Statements<\/strong>: It\u2019s like closing the door after you leave it keeps things tidy and avoids errors.<\/li>\n\n\n\ndelimiter=';'<\/code> in the csv<\/code> module or sep=';'<\/code> in pandas<\/code>.<\/li>\n\n\n\npandas<\/code>\u2019s fillna<\/code> or check for empty values in the csv<\/code> module so your code doesn\u2019t break.<\/li>\n\n\n\nencoding='utf-8'<\/code> when opening the file.<\/li>\n\n\n\npandas<\/code> with chunksize<\/code> to process them bit by bit.<\/li>\n<\/ol>\n\n\n\nWhen to Use
csv<\/code> vs. pandas<\/code><\/h2>\n\n\n\n