Data Analyst
Python and pandas questions
30 questions on Python and pandas for data analysts, easiest first.
Easy 12
- Dividing two integers in SQLeasy
- Lost leading zeros in IDseasy
- Counting missing values in pandaseasy
- Total sales per city in pandaseasy
- Type of a 1 to 5 ratingeasy
- Box plots per city in Pythoneasy
- SUM ignores some numberseasy
- Cleaning extra spaces from nameseasy
- Filling a pattern from one exampleeasy
- Splitting "City, State" into two columnseasy
- Deleting repeated rowseasy
- Deleting duplicate rowseasy
Medium 11
- Filling missing income valuesmedium
- Same cleaning every Mondaymedium
- Outlier cutoff with the IQR rulemedium
- Rows after a pandas left mergemedium
- Lookup fails for values that look identicalmedium
- ID 1001 not foundmedium
- Removing commas from amountsmedium
- Filling blanks with the value abovemedium
- LAG in pandasmedium
- Marking duplicates in an UPDATEmedium
- RANK in pandasmedium