----- 1 -----. Clean the names of columns to lowercase and remove any empty columns if necessary. ----- 2 -----. Change the date column to the same format ‘YYYY-MM-DD’. ----- 3 -----. Change the name column to the title case (e.g: Jason Mraz). ----- 4 -----. Make a new “email” column with the form: {last_name}.{first_name}.{id}@yourcompany.com ----- 5 -----. Change the phone number column to the format “84……” ----- 6 -----. Find any duplicated ID and remove those who join later. ----- 7 -----. Filter those who join since 2019 and export to a csv file, delimited by “|”, file name “emp_{report_date}.csv” with report_date = today.
-
Notifications
You must be signed in to change notification settings - Fork 0
Source: Rinez
An-nguyen999/PROJECT-2--Cleaning-data
Folders and files
| Name | Name | Last commit message | Last commit date | |
|---|---|---|---|---|
Repository files navigation
About
Source: Rinez
Resources
Stars
Watchers
Forks
Releases
No releases published
Packages 0
No packages published