read csv to dataframe code example
Example 1: read csv uisng pandas
import pandas as pd #import pandas
#syntax: pd.read_csv('file_location/file_name.csv')
data = pd.read_csv('filelocation/fileName.csv') #reading data from csv
Example 2: pandas read csv
import pandas as pd
cereal_df = pd.read_csv("/tmp/tmp07wuam09/data/cereal.csv")
cereal_df2 = pd.read_csv("data/cereal.csv")
# Are they the same?
print(pd.DataFrame.equals(cereal_df, cereal_df2))
Example 3: convert csv to pandas dataframe
import pandas as pd
df = pd.read_csv("sample_data.csv")
# .csv file format
column1,column2
1,2
3,4
5,6
# pandas dataframe
column1 column2
0 1 2
1 3 4
2 5 6
Example 4: csv file in dataframe
import pandas as pddf = pd.read_csv ('file_name.csv')print(df)
Example 5: readv csv pandas
>>> pd.read_csv('data.csv')