I am working on UCI machine learning challenge “Human Activity Recognition Using Smartphones Data Set”. This challenge has a dataset “X_train.txt” and when I import it using read_csv it stores all variables in a single column only (look at below code).
import pandas as pd df=pd.read_csv('C:/Users/Pravin/Desktop/UCI HAR Dataset/train/X_train.txt', sep="\t", header=None) df.head()
Please help me to read file as the numbers separated by spaces should be under different columns. One of the methods I have figured out save as txt file as csv and after that import it.