Add Columns

Duplicate Column

IMDb2 = df.IMDB_Rating ** 2

df['IMDb_Squared'] = IMDb2

df.head(1)

Concatenate Columns

Concatenated_Column = df.Platform + '_' + df.Director

df['Concatenated_Column'] = Concatenated_Column

df.head(1)

Split Columns

df[['Genres1', 'Genres2', 'Genres3']]= df.Genres.str.split(',',expand=True,)

df.head(1)

Add w/ condition

import numpy as np

df['Type'] = np.where(df['ShowOrMovie']=='M', '1','2')

df.head(1)

Drop Columns

Drop by col number

df1 = df.drop(df.columns[[0,2,3,4,5,6,7,8,9,10]], axis=1)

df1.head(1)

Drop by col name

df1 = df.drop(["URL",'Year','MPAA_Rating', 'Duration', 'Summary'], axis=1)

df1.head(1)