Pandas read csv fails

Question

Given a text file (.txt) containing comma seperated values such as 6,3,2,6,3,7,6,4,... I want to read the integer values to a pandas data frame with the method .read_csv.

import pandas as pd

data_frame = pd.read_csv(csv_config['path'], sep=",")

The resulting values are stored in data_frame.columns and look like this: 6, 3, 2, 6.1, 3.1, 7, 6.2, 4, ...

Where do the float values come from, when I expected Integer values?

pnovotnyq · Accepted Answer · 2019-05-25 13:08:03Z

2

Pandas assign a unique name to each column. So the first occurence of 6 has a column name "6", the second has "6.1" etc. Note that they are strings rather than floats.

If you want to read the first row as values (instead of column headers), you should do:

df = pd.read_csv(csv, header=None)

answered May 25, 2019 at 13:08

pnovotnyq

5473 silver badges12 bronze badges

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

Collectives™ on Stack Overflow

Pandas read csv fails

1 Answer 1

Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Related