Hi!
I have a question about transforming my data table.
I have a table with 3 variables: postal codes (PC4), the number of available jobs (AvailableJobs) and the sectors in which the available jobs can be categorized (Sector). A small example I made in Excel of my data can be seen in the left table.
Now I want to convert/transform this left table to a table like the right table. Instead of a table with all separated observations (left), I want a table in which all available jobs per PC4 are added together and are divided over the mentioned sectors. So in fact the column G is the sum of columns H through N.
Can someone tell me if this is possible? And if so, which comments do I have to use?
Thank you in advance!
Array
Related Posts with Transforming datatable
Panel data quality with REGHDFEHi all, I am relative new to STATA and to panel data. I have a dataset with observations of 26 state…
non parametric regression discontinuity with interaction termi am writing to ask if is it possible to do a non parametric regression discontinuity with an intera…
Diagnostic tests for correlated random effects modelHi, What diagnostic tests can be done on a correlated random effects model? And if so how do I code…
Fixed effect xtreg - Panel data - P-valueHey everyone, I'm trying to find the regression of my panel dataset. I'm trying to calculate the re…
Problem regarding imputation of missing valueHii I am working on self reported cross section data set. Most of the variable are ordinal in nature…
Subscribe to:
Post Comments (Atom)
0 Response to Transforming datatable
Post a Comment