Answers for "how to open csv files in python"

18

python read csv

# pip install pandas 
import pandas as pd

# Read the csv file
data = pd.read_csv('data.csv')

# Print it out if you want
print(data)
Posted by: Guest on October-03-2020
7

import csv file in python

import pandas as pd

df = pd.read_csv (r'Path where the CSV file is storedFile name.csv')
print (df)
Posted by: Guest on June-07-2020
1

csv reader python

import csv

with open('employee_birthday.txt', mode='r') as csv_file:
    csv_reader = csv.DictReader(csv_file)
    line_count = 0
    for row in csv_reader:
        if line_count == 0:
            print(f'Column names are {", ".join(row)}')
            line_count += 1
        print(f't{row["name"]} works in the {row["department"]} department, and was born in {row["birthday month"]}.')
        line_count += 1
    print(f'Processed {line_count} lines.')
Posted by: Guest on May-15-2020
0

python read scv

import csv
with open('eggs.csv', newline='') as csvfile:
    spamreader = csv.reader(csvfile, delimiter=' ', quotechar='|')
    for row in spamreader:
        print(', '.join(row))

# Output:
# Spam, Spam, Spam, Spam, Spam, Baked Beans
# Spam, Lovely Spam, Wonderful Spam
Posted by: Guest on December-01-2020

Code answers related to "how to open csv files in python"

Python Answers by Framework

Browse Popular Code Answers by Language