how can I FIX this, thank you
CodePudding user response:
You have to specify that your csv
file seperator is whitespace
.
To do so you have to add sep='\s '
as this says that the seperator in the file is one or more spaces (Regex expression).
The better way
You have to specify delim_whitespace=True
as parametes as it is faster that regex
I shown you above.
So your code should be like:
pd.read_csv("beer_drug_1687_1739.txt", header=None, delim_whitespace=True)
And also I see that your first row has the names of your columns. So you have to change header=None
to header=[0]
to get the names of your columns.
If you have any questions feel free to ask.