def MonthsAfter(a): c = a[‘ShamsiYearMonth’] – a[‘CohortGroup’] if c>۱۲: return c-88 else : return c# mg[‘MonthsAfterFirst’]mg.apply(lambda x: MonthsAfter(x),axis=1)
from What Code single column df[‘food’] multiple columns df[[‘color’, ‘food’, ‘score’]] single row df.loc[‘Niko’] multiple rows df.loc[[‘Niko’, ‘Penelope’]] slice notation to select a range of…
df[‘PriceBin’] = pd.cut(df[‘PriceAvg’], bins = 3)df[‘PriceBin’].value_counts() (۵۴۰۶۰.۰, ۲۰۴۰۰۰۰.۰] ۲۰۹ (۲۰۴۰۰۰۰.۰, ۴۰۲۰۰۰۰.۰] ۴ (۴۰۲۰۰۰۰.۰, ۶۰۰۰۰۰۰.۰] ۱ Name: PriceBin, dtype: int64 df[‘PriceBin’] = pd.qcut(df[‘PriceAvg’], q=3) df[‘PriceBin’].value_counts().sort_index() (۵۹۹۹۹.۹۹۹,…
– To Rename the data framedf.rename(columns={“contract_id”:”deal_id”},inplace=True) – Where statement tips[tips[‘time’] == ‘Dinner’].head(۵) – vlookupmg = pd.merge(df,AgReg,on=”deal_id”,how=”left”) – choose the first column of an array or first part…
If you knew SQL before and want to migrate to Python, you can use this article. TiTle SQL Pandas Desc Simple SELECT total_bill, tip, smoker,…