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.
https://www.plus2net.com/python/panda...
import pandas as pd
df=pd.read_csv('D:\\my_data\\my_file.xlsx')
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
df=pd.read_csv('D:\\my_data\\my_file.xlsx',index_col='id')
header
By default the column header is 0. We can give integer values. Here is the code to start from 1st row
df=pd.read_csv('D:\\my_data\\my_file.xlsx',header=1)
We can specify not to use any header and use all as data
df=pd.read_csv('D:\\my_data\\my_file.xlsx',header=None)
names
We can specify our one list of names to be used as headers.
cl=['c1','c2','c3','c4']
df=pd.read_csv('D:\\my_data\\my_file.xlsx',names=cl)
/ plus2net
#pandas_read_csv #dataframereadcsv #pandascsv #plus2net #pandas #datascience #pandastutorials
In questa pagina del sito puoi guardare il video online Reading data from CSV file and creating Pandas DataFrame using read_csv() in Python with options della durata di ore minuti seconda in buona qualità , che l'utente ha caricato plus2net 13 maggio 2021, condividi il link con amici e conoscenti, su youtube questo video è già stato visto 1,250 volte e gli è piaciuto 7 spettatori. Buona visione!
