filmov
tv
Reading data from CSV file and creating Pandas DataFrame using read_csv() in Python with options

Показать описание
We can read one csv file from our system and using that we can create Pandas DataFrame. We will use read_csv() method for reading data from local system.
import pandas as pd
The path we used here is D drive and my_data as directory , you can change it based on location of csv file.
index_col
Dataframe will add one index column, we can specify to use one of our column as index column by saying index_col
header
By default the column header is 0. We can give integer values. Here is the code to start from 1st row
We can specify not to use any header and use all as data
names
We can specify our one list of names to be used as headers.
cl=['c1','c2','c3','c4']
#pandas_read_csv #dataframereadcsv #pandascsv #plus2net #pandas #datascience #pandastutorials
import pandas as pd
The path we used here is D drive and my_data as directory , you can change it based on location of csv file.
index_col
Dataframe will add one index column, we can specify to use one of our column as index column by saying index_col
header
By default the column header is 0. We can give integer values. Here is the code to start from 1st row
We can specify not to use any header and use all as data
names
We can specify our one list of names to be used as headers.
cl=['c1','c2','c3','c4']
#pandas_read_csv #dataframereadcsv #pandascsv #plus2net #pandas #datascience #pandastutorials