DF Editing

Rename Column Headers

df.rename(columns={'URL': "Amazing_New_URL", 'Title': "Amazing_New_Title"}, inplace = True)

Replace Data Values

df.MPAA_Rating.replace('TV-14', 'Not_TV-14' , inplace=True)

Replace Partial or Whole Values

ReplaceThis = ['m']

df.Duration = df.Duration.str.replace('|'.join(ReplaceThis), ' Minutes').str.strip()

Change Data Type

#################### Removing 'M' from the durations ########################

ReplaceThis = ['m']

df.Duration = df.Duration.str.replace('|'.join(ReplaceThis), '').str.strip()

###################################################################

df['Duration'] = df['Duration'].astype(float)

df['IMDB_Rating'] = df['IMDB_Rating'].astype(int)

df.dtypes

Groupby into DF

Group = df.groupby('Platform')

df1 = pd.DataFrame(Group.IMDB_Rating.count())

df2 = df1.reset_index()