Back to Browse

Pandas: MultiIndex

63 views
Jan 23, 2021
30:30

Code you can copy / paste into your coding environment: quart_yrs = pd.MultiIndex.from_arrays([ ['2019','2019','2019','2019','2020','2020','2020','2020','2021','2021','2021','2021'], ['Q1', 'Q2','Q3','Q4','Q1', 'Q2','Q3','Q4','Q1', 'Q2','Q3','Q4']]) sales = [1456,2760,2340,4780,2890,3360,2440,5150,3780,np.nan,np.nan,np.nan] print(quart_yrs, sales) tuples = [ ('2019', 'Q1'), ('2019', 'Q2'), ('2019', 'Q3'), ('2019', 'Q4'), ('2020', 'Q1'), ('2020', 'Q2'), ('2020', 'Q3'), ('2020', 'Q4'), ('2021', 'Q1'), ('2021', 'Q2'), ('2021', 'Q3'), ('2021', 'Q4')] sales = [1456,2760,2340,4780,2890,3360,2440,5150,3780,np.nan,np.nan,np.nan] employees = pd.DataFrame([ [1043,'Tim Smith','HR','HR Mgr'], [3453,'Sally Jones','Sales','Sales Rep'], [4342,'Linda Gupta','Sales','Sales Rep'], [4776,'Jack Jones','Sales','Sales Mgr'], [2343,'Shawn Peters','HR','HR Mgr'], [4323,'Trisha Yallows','Sales','Sales Rep'], [1008,'Brand Opus','Sales','Sales Rep'], [2005,'Kimi King','Sales','Sales Rep'], [1099,'Jack Avey','HR','HR Mgr'], [2765,'Jan Levin','HR','Director, HR'], [3111,'Jacob Robins','Service','Cust Serv Rep']], columns = ['EE_ID', 'EE_Name', 'Dept', 'Position']) employees

Download

0 formats

No download links available.

Pandas: MultiIndex | NatokHD