How to Import CSV and XLS Data into Pandas

Pandas is a Python Data Analysis Library. It allows you to play around with data and perform powerful data analysis.

In this example I will show you how to read data from CSV and Excel files in Pandas. You can then save the read output as in a Pandas dataframe. The sample data used in the below exercise was generated by https://mockaroo.com/.

import pandas as pd

csv_data_df = pd.read_csv('data/MOCK_DATA.csv')

Preview the first 5 lines of the data with .head() to ensure that it loaded.

csv_data_df.head()

.dataframe thead tr:only-child th {
    text-align: right;
}

.dataframe thead th {
    text-align: left;
}

.dataframe tbody tr th {
    vertical-align: top;
}

	id	first_name	last_name	email	gender	ip_address
0	1	Ross	Ricart	[e-mail]	Male	217.151.154.186
1	2	Jenn	Pizer	[e-mail]	Female	104.123.13.234
2	3	Delainey	Sulley	[e-mail]	Male	6.101.0.150
3	4	Nessie	Feirn	[e-mail]	Female	97.93.173.170
4	5	Noami	Flanner	[e-mail]	Female	174.228.138.242

You will need to pip install xlrd if you haven't already. In order to import data from Excel.

import xlrd
excel_data_df = pd.read_excel('data/MOCK_DATA.xlsx')

excel_data_df.head()

.dataframe thead tr:only-child th {
    text-align: right;
}

.dataframe thead th {
    text-align: left;
}

.dataframe tbody tr th {
    vertical-align: top;
}

	id	first_name	last_name	email	gender	ip_address
0	1	Chloris	Antliff	[e-mail]	Female	131.17.2.171
1	2	Brion	Gierok	[e-mail]	Male	245.41.126.3
2	3	Fleur	Skells	[e-mail]	Female	75.0.34.132
3	4	Dora	Privost	[e-mail]	Female	51.202.4.39
4	5	Annabella	Hucker	[e-mail]	Female	124.80.181.41

Image Courtesy of jballeis (Own work) CC BY-SA 3.0, via Wikimedia Commons

A version of this article was originally published by Monica Powell on www.datalogues.com