Read CSV file in Pandas Python

Question

I'm trying to read CSV file.

import pandas as pd
df = pd.read_csv(r'C:\Users\San\TEMP OLSTP MECH AMT.csv')
df.head()

But when I show the dataset, it looks messed up.

contd.

How to fix it? Is there any set up needed?

Answer 1

Your data is ;-sheared, you need to inform pandas about that, try

import pandas as pd
df = pd.read_csv(r'C:\Users\San\TEMP OLSTP MECH AMT.csv',sep=";")
df.head()

Read pandas.read_csv docs if you want to know more

Answer 2

Try this

  import pandas as pd
 df = pd.read_csv(r'C:\Users\San\TEMP OLSTP MECH 
           AMT.csv', sep=';' ) 
  df.head()