How to import a CSV file in Python?
This recipe helps you import a CSV file in Python
Recipe Objective
Before using any model first thing you have to do is to import the dataset. There are many ways to do it.
So this is the recipe on how we can import a CSV file in Python.
Table of Contents
Step 1 - Import the library
import csv
import numpy
import pandas
We have imported numpy, csv and pandas which is needed.
Step 2 - Loading CSV
We are first importing dataset with use of CSV library. Here we need to pass the file name, the quoting in the csv.reader function and the parameter delimiter which signifies that by which charactor the data is seperated. we can also store it in a object and can use the data by calling the object.
filename = "load.csv"
raw_data = open(filename, "rt")
reader = csv.reader(raw_data, delimiter=",", quoting=csv.QUOTE_NONE)
x = list(reader)
data = numpy.array(x).astype("float")
print(data.shape)
We can also do this with the help of numpy. For this we have to pass the file name in numpy.loadtxt and we have to also set the delimiter which signifies that by which charactor the data is seperated.
filename = "load.csv"
raw_data = open(filename, "rt")
data = numpy.loadtxt(raw_data, delimiter=",")
print(data.shape)
We can also do this with the help of pandas. For CSV we need to make a array of names of columns before importing the data then to import we have to pass the file name and the array we have created to the pandas.read_csv function.
filename = "load.csv"
names = ["preg", "plas", "pres", "skin", "test",
"mass", "pedi", "age", "class"]
data = pandas.read_csv(filename, names=names)
print(data.shape)
Download Materials
What Users are saying..
Abhinav Agarwal
I come from Northwestern University, which is ranked 9th in the US. Although the high-quality academics at school taught me all the basics I needed, obtaining practical experience was a challenge.... Read More