0

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. enter image description here

contd. enter image description here

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

Improve this question
0

2 Answers 2

Reset to default
4

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

Improve this answer
Sign up to request clarification or add additional context in comments.

Comments

1

Try this

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

Comments

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.