search

alphacastio / connectors-main

Guidance and Project management for Open-Source Alphacast Connectors
MIT License
8 stars 5 forks source link

[DATA-RQ] USA Monthly GDP Index #42

Closed MacarenaOrtt closed 2 years ago

MacarenaOrtt commented 2 years ago

What is the estimated difficulty of this data request? Easy

What is the Source / Url of this Data The data comes from the IHS Markit Website

What is the format of the data source Excel

What is the name of the new datasets or datasets? Activity - USA - IHS Markit - Monthly GDP Estimate

In which repository will it be? USA Macro Basics

Which are the Entities of the new dataset [Date, country]

What data should be extracted?

image

In the website, click on the "Monthly GDP Index: Historical Data" link. It will download an Excel file containing all of the relevant data.

image

The Excel file has three sheets, only one of which is relevant: "Data". Index and Commentary can be disregarded.

image

To translate into a dataset, create two columns: one, labeled "Date", will have the monthly date, starting January 1992 and ending at the final month available. It has to be created in YYYY-MM-DD format. The second column will be labeled "country", and will say "United States" for every value.

Both of the columns containing data are relevant. They can keep the current names "Monthly Nominal GDP" and "Monthly Real GDP".

eze2286 commented 2 years ago

Hola Macarena, como estas?. Me podrías asignar este ISSUE?. Gracias. Saludos.