Session 4 - Cleaning data - Githubissues

worldbank / dime-stata-training

MIT License

4 stars 8 forks source link

Session 4 - Cleaning data #5

Closed luizaandrade closed 2 years ago

luizaandrade commented 2 years ago

Cleaning strings:

[x] Trim
[x] Replace
[x] Missing values
[x] Lower/Upper

Cleaning dates:

[x] Identify date string format
[x] Convert to date
[x] Change format

Cleaning categorical variables:

[x] Encode
[x] Replacing values
[x] Value labels

Cleaning numeric variables:

[x] Destring
[x] Finding outliers

Annotate the data:

[x] Label variables
[x] Rename variables
[x] Order variables

Moved to appendix

Handling missing values

Moved to analysis

Export data to csv and Excel

luizaandrade commented 2 years ago

use daily(), not date()