Excercises on JSON data
- To get familiar with packages for dealing with JSON
- Study examples with JSON strings and files
- Work on exercise to be completed and submitted
Objective: Using data in file 'data/world_bank_projects.json' and the techniques demonstrated above,
- Find the 10 countries with most projects
- Find the top 10 major project themes (using column 'mjtheme_namecode')
- In 2. above you will notice that some entries have only the code and the name is missing. Create a dataframe with the missing names filled in