Practice Interview Questions
| Question | Status |
|---|---|
You are tasked with cleaning the Columne Project Management tool dataset.
The dataset activity_log contains the following columns: activity_id, session_id, user_id, activity_type, and activity_time. There are missing values in the activity_type column. Replace any missing values with "Unknown".
| activity_id | session_id | user_id | activity_type | activity_time |
|---|---|---|---|---|
| 1 | 1 | 1 | commented | 2025-03-08 09:23:00 |
| 2 | 1 | 1 |
| deleted_task |
| 2025-03-08 08:19:00 |
| 3 | 1 | 1 | updated_task | 2025-03-08 08:18:00 |
You are tasked with cleaning the Columne Project Management tool dataset.
The dataset activity_log contains the following columns: activity_id, session_id, user_id, activity_type, and activity_time. There are missing values in the activity_type column. Replace any missing values with "Unknown".
| activity_id | session_id | user_id | activity_type | activity_time |
|---|---|---|---|---|
| 1 | 1 | 1 | commented | 2025-03-08 09:23:00 |
| 2 | 1 | 1 | deleted_task | 2025-03-08 08:19:00 |
| 3 | 1 | 1 | updated_task | 2025-03-08 08:18:00 |