Getting Null Values while reading Values into a dataframe in python

Question

I am trying to read a .csv file into a Python dataframe but it is showing null values.

The .csv file has columns separated by ;.

I am using this code:

import pandas as pd    
data = pd.read_csv('testfile.csv', sep = ';')

and this is the output:

All values are null and number of rows got doubled

Open up the csv in a text editor (like notepad++) and see what it looks like — Riley
– Riley, Commented Oct 30, 2021 at 6:22
data= pd.read_csv('testfile.csv' , sep = ';', encoding = 'UTF-16') it worked — Gaurav Raina
– Gaurav Raina, Commented Oct 30, 2021 at 6:26

Gaurav Raina · Accepted Answer · 2021-10-30 06:29:19Z

1

data = pd.read_csv('testfile.csv', sep = ';' , encoding = 'UTF-16')

answered Oct 30, 2021 at 6:29

Gaurav Raina

659 bronze badges

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

1 Comment

Community Over a year ago

Your answer could be improved with additional supporting information. Please edit to add further details, such as citations or documentation, so that others can confirm that your answer is correct. You can find more information on how to write good answers in the help center.

Collectives™ on Stack Overflow

Getting Null Values while reading Values into a dataframe in python

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related