alphacastio / connectors-main

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

[DATA-RQ] Monetary - Argentina - BCRA - Credit Conditions Survey (ECC) - Business Loans - Q1 #45

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 BCRA

What is the format of the data source Excel

What is the name of the new datasets or datasets?

There are 18 datasets:

  1. Monetary - Argentina - BCRA - Credit Conditions Survey (ECC) - Business Loans - Q1

  2. Monetary - Argentina - BCRA - Credit Conditions Survey (ECC) - Business Loans - Q2

  3. Monetary - Argentina - BCRA - Credit Conditions Survey (ECC) - Business Loans - Q3

  4. Monetary - Argentina - BCRA - Credit Conditions Survey (ECC) - Business Loans - Q4

  5. Monetary - Argentina - BCRA - Credit Conditions Survey (ECC) - Business Loans - Q5

  6. Monetary - Argentina - BCRA - Credit Conditions Survey (ECC) - Business Loans - Q6

  7. Monetary - Argentina - BCRA - Credit Conditions Survey (ECC) - Business Loans - Q7

  8. Monetary - Argentina - BCRA - Credit Conditions Survey (ECC) - Business Loans - Q8

  9. Monetary - Argentina - BCRA - Credit Conditions Survey (ECC) - Business Loans - Q9

  10. Monetary - Argentina - BCRA - Credit Conditions Survey (ECC) - Household Loans - Q1

  11. Monetary - Argentina - BCRA - Credit Conditions Survey (ECC) - Household Loans - Q2

  12. Monetary - Argentina - BCRA - Credit Conditions Survey (ECC) - Household Loans - Q3

  13. Monetary - Argentina - BCRA - Credit Conditions Survey (ECC) - Household Loans - Q4

  14. Monetary - Argentina - BCRA - Credit Conditions Survey (ECC) - Household Loans - Q5

  15. Monetary - Argentina - BCRA - Credit Conditions Survey (ECC) - Household Loans - Q6

  16. Monetary - Argentina - BCRA - Credit Conditions Survey (ECC) - Household Loans - Q7

  17. Monetary - Argentina - BCRA - Credit Conditions Survey (ECC) - Household Loans - Q8

  18. Monetary - Argentina - BCRA - Credit Conditions Survey (ECC) - Household Loans - Q9

In which repository will it be? Argentina - BCRA (id 17)

Which are the Entities of the new dataset Date: in YYYY-MM-DD format Entity: country

What data should be extracted?

The first 9 datasets are downloaded as follows:

image image

Each sheet of the spreadsheet forms a separate dataset (there are 9 sheets, so there are 9 datasets). The format is the same for everything. Variables should be named as following: "Variables name" + "Category". ATTENTION: Remove (%) in "Variables name". For example: Mas flexibles - Nivel General. IMPORTANT: Take into consideration all the categories (all te tables) in every sheet. image

For the following datasets (10 to 18), should be dowland the following spreadsheet:

image

Each sheet of the spreadsheet forms a separate dataset (there are 9 sheets, so there are 9 datasets). The format is the same for everything. Variables should be named as following: "Variables name" + "Category". ATTENTION: Remove (%) in "Variables name". For example: Mas flexibles - Creditos Hipotecarios

image

IMPORTANT