How to import CSV file in python?
A CSV file stands for comma separated values file is a text based format represents data found in spredsheet.
Now we will see how to read CSV file in python?
There are basically two methods to read the file :-
- By importing CSV module
- By importing pandas module
In the first method we have to directly import csv module from python packages. And then we are able to read the csv file by following the given syntax:-
import csv filename="file_name.csv" csv_reader=csv.reader(filename) print(csv_reader)
In the second method we have to import pandas module from the python packages.
syntax:-
import pandas as pd data=pd.read_csv("path of file") print(data)
We can also read and print some specific columns and rows .
syntax:-
import pandas as pd data=pd.read_csv("path of file") d=pd.read_csv("path of file", column="column_name") print(d)
This is all about how we can read from csv file in python.
Subscribe
Login
Please login to comment
0 Discussion