Personal Project - First names in Belgium
Switch branches/tags
Nothing to show
Clone or download
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Permalink
Failed to load latest commit information.
Full population
Joke names
.gitignore
Cleaned file - First names Belgian Population anno 2013.csv
Cleaned file - First names in Belgium born 1995-2016.csv
First names boys 1995-2016.xls
First names full Belgian Population.xls
First names girls 1995-2016.xls
PP1---First-names-in-Belgium.Rproj
README.md

README.md

First names in Belgium

Data source

Belgian government (data link)

Data

Data came in the form of two excel files, one for girls and one for boys. Every file contains a sheet for every year (1995-2016), and then numbers per region per name.

Original data file contains the numbers for Belgium as a whole, and for every region seperate (Flander, Wallonia and Brussels). Only the Belgian data is pulled out into the clean file right now.

To note: no names below 5 occurences are present in the database, presumably for privacy reasons.

Cleaning

First part of the code describes a function to get the data in from every sheet into one dataframe, and then merges the boys and girls file.

The clean file is outputted as "First names in Belgium 1995-2016 cleaned.csv"