Pandas

Question 1

pd.concat()

Answer 1

(df1,df2,axis=0)

Question 2

df.sort_values()

Answer 2

( [ ] ,ascending= , inplace=)

Question 3

df.fillna()

Answer 3

( ‘ ‘ , inplace= )

Question 4

df.drop()

Answer 4

( [ ] ,axis=1)

Question 5

df.rename()

Answer 5

( columns={ } , inplace=)

Question 6

df.merge()

Answer 6

( df2, left_on=’‘,right_on=’’, how= )

Question 7

df.replace()

Answer 7

( { } , inplace= )

Question 8

df.drop_duplicates()

Answer 8

([ ], keep= , inplace= )

Question 9

df.dropna()

Answer 9

(subset= ,inplace= )

Question 10

df.rank()

Answer 10

(ascending= , method=’dense’)

Question 11

pd.DataFrame( )

Answer 11

“userid”: [1, 2, 3, 4, 5],
“country_id”: [46, 46, 358, 49, None]

Question 12

fix the index

Answer 12

reset_index(drop=True)

Question 13

df.apply()

Answer 13

(lambda x : ‘Sweden’ if x[‘name’]==’Christian’ else x[‘country’], axis=1)

or

(function,axis=1)

Question 14

df.groupby()

Answer 14

( [ ] )

Question 15

.agg()

Answer 15

(user_count=(‘user_count’, ‘count’))

Question 16

make df[‘signup_date’] to month

Answer 16

.dt.month

Question 17

.rolling()

Answer 17

(window=7, min_periods=1).sum()

Question 18

remove time in datetime

Answer 18

df.normalize()

Question 19

row_number

Answer 19

df.reset_index(drop=True).index + 1

Question 20

+ pd.to_timedelta()

Answer 20

(3, unit=’D’)

Question 21

unique()

Answer 21

tar fram alla columner