pandas choose columns code example

Example 1: how to keep only certain columns in dataframe

# Using DataFrame.drop
df.drop(df.columns[[1, 2]], axis=1, inplace=True)

# drop by Name
df1 = df1.drop(['B', 'C'], axis=1)

# Select the ones you want
df1 = df[['a','d']]

Example 2: how to pick out separate columns from the pandas dataframe object

df1 = df.iloc[:, 0:2] # If you want to do it by index. Remember that Python does not slice inclusive of the ending index.
df1 = df[['a', 'b']] ## if you want to do it b nae

Example 3: pandas iloc select certain columns

dataframe.iloc[:,[1,2]]

Example 4: select columns to include in new dataframe in python

new = old[['A', 'C', 'D']].copy()

Example 5: select columns pandas

df1 = df.iloc[:,0:2] # Remember that Python does not slice inclusive of the ending index.

Example 6: select columns to include in new dataframe in python

new = old.filter(['A','B','D'], axis=1)

Tags:

R Example