Reading a text file with Numpy/Pandas in Python

Question

I have an unlabeled dataset which contains 101 columns i.e. no column have any heading, now I want to start reading from column 2 to end i.e. 101th column. I am trying with this code :

data = np.loadtxt('structure-safety.inp', usecols = [2, 101])
or 
data = pd.read_fwf('structure-safety.inp', usecols = [2,1,101])

I also tried with usecols = [2, :], [2:101] or used () instead of [] but in vain, can anyone help me here with this problem.

James · Accepted Answer · 2017-11-19 03:01:49Z

1

Try:

data = pd.read_fwf('structure-safety.inp', usecols=list(range(2,102))

Keep in mind that the columns are numbered from 0. So column 2 is actually the third column.

Or you can drop a column:

data = pd.read_fwf('structure-safety.inp')
data = data.drop(df.columns[0:2], axis=1)

edited Nov 19, 2017 at 3:01

answered Nov 19, 2017 at 2:47

James

37k4 gold badges54 silver badges79 bronze badges

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

1 Comment

James Over a year ago

You may be better off just dropping a column then. See the edit.

Collectives™ on Stack Overflow

Reading a text file with Numpy/Pandas 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