Gather columns into rows
pd.melt(df)
Spread rows into columns
df.pivot(columns='var', values='val')
Append rows of DataFrames
pd.concat([df1,df2])
Append columns of DataFrames
pd.concat([df1,df2], axis=1)
Order rows by values of a column (low to high)
df.sort_values('mpg')
Order rows by values of a column (high to low)
df.sort_values('mpg’, ascending=False)
Rename the columns of a DataFrame
df.rename(columns = {'y':'year'})
Sort the index of a DataFrame
df.sort_index()
Reset index of DataFrame to row numbers, moving index to columns
df.reset_index()
Drop columns from DataFrame
df.drop(columns=['Length’, 'Height'])
Last changeda year ago