#Rename columns:
df = df.rename(columns={"col1": "column1", "col2": "column2"}
#Drop columns:
df.drop(columns = ["column1", "column2"], axis=1, inplace=True)
#Unique values in each column:
df.nunique()
#Number of missing values in each column:
df.isnull().sum()
#Convert a string column to date:
df["date_column"] = pd.to_datetime(df["string_column"], dayfirst = True)
#Get the day element from a date column:
df["day"] = df["date_column"].dt.day
#Get the weekday name (e.g. Monday, Tuesday) from a date column:
df["weekday_name"] = df["date_column"].dt.day_name(locale='English')
#Group by 2 columns and get the row count:
df.groupby(["column1","column2"]).size()
#Combine 2 data frames:
df = pd.concat([df1, df2], axis=1)
29 March 2021
Pandas
Leave a Comment »
No comments yet.
Leave a Reply