Specialized on Data processing, Data management Implementation plan, Data Collection tools - electronic and paper base, Data cleaning specifications, Data extraction, Data transformation, Data load, Analytical Datasets, and Data analysis. BJ Data Tech Solutions teaches on design and developing Electronic Data Collection Tools using CSPro, and STATA commands for data manipulation. Setting up Data Management systems using modern data technologies such as Relational Databases, C#, PHP and Android.
Saturday, February 5, 2022
Reshaping Data, Wide format from long
Hello everyone,
I'm having trouble formatting my data. I have a dataset that looks like this:
Country Year Gender Observation
Afghanistan 1976 Female 112587
Afghanistan 1976 All genders 729667
Afghanistan 1975 All genders 692342
Afghanistan 1975 Female 104019
Albania 2014 All genders 195720
Albania 2014 Female 92609
I want to format it to look like this instead:
Country Year Female All genders
Afghanistan 1976 112587 729667
Afghanistan 1975 104019 692342
Albania 2014 92609 195720
Any idea on how I could do this?
Thanks
No comments:
Post a Comment