Lee Leslie
0
Q:

python read csv file

# Import pandas 
import pandas as pd 
  
# Read csv file  
table = pd.read_csv("filename.csv") 
# Print it out if you want to...
print(table)
5
import csv

with open('employee_birthday.txt') as csv_file:
    csv_reader = csv.reader(csv_file, delimiter=',')
    line_count = 0
    for row in csv_reader:
        if line_count == 0:
            print(f'Column names are {", ".join(row)}')
            line_count += 1
        else:
            print(f'\t{row[0]} works in the {row[1]} department, and was born in {row[2]}.')
            line_count += 1
    print(f'Processed {line_count} lines.')
7
# 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)
3
import pandas as pd 
data = pd.read_csv("filename.csv") 
data.head()
10
import pandas as pd
df=pd.read_csv('the_file.csv')
3
>>> import csv
>>> with open('eggs.csv', newline='') as csvfile:
...     spamreader = csv.reader(csvfile, delimiter=' ', quotechar='|')
...     for row in spamreader:
...         print(', '.join(row))
Spam, Spam, Spam, Spam, Spam, Baked Beans
Spam, Lovely Spam, Wonderful Spam
2

New to Communities?

Join the community