CODEWITHSUNDEEP
pythonpandasslice
mapperx
mapperx

Reputation: 207

Multiple selection of dataframe using multiple column slices

I have a dataframe that has 10 columns, I am trying select columns 1 to 3 (first to third) and columns 5 to 8 (fifth to eighth). Is it possible to select using the iloc selector so that it can take multiple slices. The sample below can slice first to third, I would like to add the columns 5 to 8 as well

df = pc_df.iloc[:,0:4]

Upvotes: 2

Views: 156

Answers (2)

Rabinzel
Rabinzel

Reputation: 7923

Didn't know about np.r_, so also thanks to Tito from me!

If you don't want to use extra lib, you could also use pd.concat

pd.concat([df.iloc[:,:4], df.iloc[:, 5:9]],1)

Upvotes: 2

TitoOrt
TitoOrt

Reputation: 1305

You can use numpy:

#import  numpy as np
df.iloc[:,np.r_[0:4, 5:9]]

np.r_ will concatenate the indexes for you.

Upvotes: 2

Related Questions