Export Read Delete CSV File Using Pandas Module of Python

Export Read Delete CSV File Using Pandas Module of Python. The following shows how to read form csv file, write data to csv and delete csv file using pandas module.

Importing Module:

import pandas as pd
import sys

Creating Data:

Code:

names = ['Bob','Jessica','Mary','John','Mel']
births = [968, 155, 77, 578, 973]

BabyData = list(zip(names, births))
BabyData

Output:

[('Bob', 968), ('Jessica', 155), ('Mary', 77), ('John', 578), ('Mel', 973)]

Making DataFrame:

Code:

df = pd.DataFrame(data = BabyData, columns=['Names', 'Births'])
df

Output:

Export the dataframe to a csv file:

df.to_csv('Data/births.csv', index=False, header=False)
df.to_csv('Data/births1880.csv', index=False, header=['Names', 'Births'])

Get Dataframe for a csv file:

ndf = pd.read_csv('Data/births.csv', header=None)
ndf

Output:

ndf = pd.read_csv('Data/births.csv', names=['Names', 'Births'])
ndf

 Output:

Delete CSV file:

import os
os.remove('Data/births1880.csv')