Answers for "load a csv file 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
7

files python csv

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.')
Posted by: Guest on May-01-2020
0

csv manipulation python

import csv, sys
filename = 'some.csv'
with open(filename, 'rb') as f:
    reader = csv.reader(f)
    try:
        for row in reader:
            print row
    except csv.Error as e:
        sys.exit('file %s, line %d: %s' % (filename, reader.line_num, e))
Posted by: Guest on April-20-2020
0

import csv using python

import csv using python
credits: https://zetcode.com/python/csv/
Posted by: Guest on June-01-2021

Python Answers by Framework

Browse Popular Code Answers by Language