Re-tracking

[Meiska12]

New issue to discuss the problems and issues we are facing with our data.

[Meiska12]

Hello @rpseely,

• We currently have the PWT and World Bank data, and we have decided to analyze one of the data sites. Each site has data about the global countries but not the variables directly related to manufacturing. Hence, we decided to change the data sets and find new ones, which we failed to do so. We faced issues in finding new sites, and on top of that, we couldn't download the data accurately.
• We were thinking of analyzing the new variables from the World Bank site that have manufacturing value added and a few other variables for correlation, such as the employment labor forces and manufacturing labor added.
• The dilemma is whether we need to start over from scratch or continue with new variables closer to manufacturing employment and development within the two data sets we have (or one).

[rpseely]

@Meiska12 Thanks for creating this issue! Will you please add links with the data sources you currently plan to use, i.e., a link to where the data you have downloaded on GitHub and can you tell me which variables you plan to use? Then I can take a look and see if it's possible to answer your research question given the data you currently have.

Also, if you could send links to the data you tried to use, I'll see if I can open it up and give some pointers on how to access it in Stata.

[Meiska12]

Here is the one for World Bank and PWT. For the World Bank data set, previously used variables were employment, GNI, Population growth, and life expectancy, and that is what we analyzed. -- Now we plan to use Manufacturing (value added GDP), employment number (labor force and 2 others.

Lucia and I found the data set this. We tried downloading the developed and developing data separately, but it was not accurate.

[kbuzard]

@ecn310/development My computer failed while I was traveling, so I'm just catching up on all this now that I'm back home. I apologize for the delay in getting back to Lucia's email from yesterday afternoon, which said:

We need some guidance on how to go forward with the data structure after the class feedback. With the current data that we have we are only able to get one or two variables relating to manufacturing which we can run the correlation on. We also tried getting other data, but each source has its own issue being either downloading or formatting, hence if we are to take new data, we'd like some extra time if that was possible.

You only need one manufacturing variable (assuming it's a good one) to run a correlation with whatever measure of growth / human development you are focusing on, so I don't see this as a problem. Manufacturing value added in GDP is fine.

• I don't, however, see this in the data that you linked to that is for the UAE only. I do see it on the World Bank website, so I think you just need to download the data that includes the new variables you want to work with.
• You will then need to modify the code in WDI edited.do to take account of the different set of variables.

I'm not sure about the usefulness of the webpage to which you linked ("Lucia and I found the data set this"); it doesn't seem to have any years other than 1960 and 2022.

[rpseely]

@ecn310/development @kbuzard

I was able to open up the linked "Our World In Data" CSV file in Stata and it has observations for the "Manufacturing jobs as a share of total employment" variable from 2000 to 2023 for 221 entities, which includes countries and grouped regions like in your other dataset. There is also a PDF on the website for the metadata for this variable. Make sure you read through that to ensure that this variable is offering what you want, but at first glance I think it looks good.

I imported the data into Stata using the URL of the CSV file found on the website. I am not sure if it is possible to download this dataset with other variables from their catalog. I think it is worth looking into seeing if you can download this dataset and add the other variables that you want to from Our World In Data. If you can't download other variables, you can merge it with your other data. Please let me know if you need any more clarification or help! Filippo and I briefly corresponded over email, but to all of you; I am able to meet tomorrow morning between 10 a.m. and 12 p.m. to give you some guidance.

[Meiska12]

Idea for Data

1a. Code for pulling in Manufacturing data (developing) URL:

import delimited "https://ourworldindata.org/grapher/manufacturing-share-of-total-employment.csv?v=1&csvType=filtered&useColumnShortNames=true&tab=chart&country=DOM~BLR~CHN~THA~MKD~GEO~BIH~ARM~COL~BWA~IRN~BRB~LCA~AZE~BRA~SUR~GRD~PLW~PRY~ZAF~MDA~LBN~EGY~PER~OWID_KOS~IDN~FJI~LKA~MNG~BTN~DMA~VNM~DZA~NRU~ECU~UKR~TUN~JAM~NAM~JOR~BLZ~SLV~IRQ~GTM~SWZ~PHL~BOL~MAR~UZB~LAO~CPV~IND~BGD~TON~MHL~AGO~NIC~PSE~HND~CIV~GHA~PAK~MRT~WSM~KGZ~DJI~NGA~KEN~TUV~KHM~MMR~NPL~TJK~TLS~PNG~CMR~COG~SDN~SEN~STP~BEN~ZMB~COM~HTI~FSM~VUT~GIN~TZA~ETH~RWA~UGA~SLB~LSO~ZWE~TGO~BFA~MLI~GMB~KIR~GNB~SLE~AFG~MDG~MWI~LBR~SOM~TCD~NER~MOZ~COD~BDI", clear `

Code for pulling in Manufacturing data (developed) URL:

import delimited "https://ourworldindata.org/grapher/manufacturing-share-of-total-employment.csv?v=1&csvType=filtered&useColumnShortNames=true&tab=chart&country=LUX~IRL~SGP~QAT~BMU~ARE~CHE~CYM~NOR~USA~SMR~DNK~NLD~BRN~HKG~AUT~ISL~SWE~BEL~DEU~BHR~MAC~AUS~SAU~CAN~KWT~FIN~MLT~GBR~FRA~KOR~NZL~CYP~ISR~ITA~JPN~ABW~CZE~SVN~ESP~LTU~EST~POL~PRT~GUY~HUN~OMN~BHS~HRV~PRI~PAN~SVK~TUR~LVA~ROU~GRC~KNA~MYS~BGR~RUS~KAZ~CHL~SYC~URY~TTO~CUW~MUS~ARG~ATG~MNE~CRI~SRB~TCA~MEX", clear

2a. Code for pulling in GDP per Capita data (developed) URL:

import delimited "https://ourworldindata.org/grapher/gdp-per-capita-worldbank.csv?v=1&csvType=filtered&useColumnShortNames=true&tab=chart&country=LUX~IRL~SGP~QAT~BMU~ARE~CHE~
> CYM~NOR~USA~WB_NA~SMR~DNK~NLD~BRN~HKG~AUT~ISL~SWE~DEU~BEL~BHR~MAC~AUS~SAU~KWT~CAN~FIN~MLT~GBR~FRA~KOR~NZL~CYP~ISR~ITA~JPN~ABW~CZE~SVN~ESP~LTU~EST~POL~PRT~GUY~HUN~OMN~BHS~HRV~
> PRI~PAN~SVK~TUR~LVA~ROU~GRC~KNA~MYS~RUS~BGR~KAZ~CHL~SYC~URY~TTO~CUW~MUS~ARG~ATG~MNE~CRI~MDV~SRB~TCA~MEX", clear

b. Code for pulling in GDP per Capita data (developing) URL:

import delimited "https://ourworldindata.org/grapher/gdp-per-capita worldbank.csvv=1&csvType=filtered&useColumnShortNames=true&tab=chart&country=LBY~DOM~WB_EAP~BLR~CHN~THA~MKD~GEO~ARM~COL~BIH~BWA~ALB~IRN~BRB~LCA~AZE~SUR~BRA~GNQ~TKM~GRD~VCT~PLW~GAB~PRY~ZAF~MDA~LBN~EGY~PER~OWID_KOS~IDN~FJI~LKA~MNG~BTN~DMA~VNM~DZA~NRU~ECU~UKR~TUN~JAM~NAM~JOR~BLZ~SLV~IRQ~GTM~SWZ~PHL~BOL~MAR~UZB~LAO~CPV~IND~WB_SA~BGD~MHL~TON~AGO~NIC~PSE~HND~CIV~GHA~PAK~MRT~WSM~KGZ~DJI~NGA~KEN~TUV~KHM~MMR~TJK~NPL~TLS~PNG~CMR~COG~SDN~SEN~STP~BEN~ZMB~FSM~COM~HTI~VUT~GIN~TZA~ETH~RWA~UGA~SLB~LSO~ZWE~TGO~BFA~MLI~GMB~KIR~GNB~SLE~AFG~MDG~MWI~LBR~SOM~TCD~NER~MOZ~COD~BDI~CAF", clear