|
|
| Line 1: |
Line 1: |
| = '''General Pulling Instructions for World Bank Data''' = | | = '''General Pulling Instructions for World Bank Data''' = |
| [[index.php?title=File:WBscreenshot10.jpg|right|frameless|507x507px]] | | [[File:WBscreenshot10.jpg|right|frameless|455x455px]] |
| 1. To pull data from the world bank, navigate to [https://data.worldbank.org/ data.worldbank.org]
| | [[File:WBscreenshot11.jpg|frameless|522x522px|right]] |
| [[File:WBscreenshot.jpg|frameless|1x1px|right]]
| |
| | |
| 2. To find the series, you can type in the search bar, click <Country> or click <Indicator>
| |
| | |
| 3. Go to step 4 if clicked on <Country> or to step 7 if clicked on <Indicator>
| |
| | |
| [[File:WBscreenshot3.jpg|frameless|506x506px|right]]
| |
| [[File:WBscreenshot14.jpg|frameless|507x507px|right]]
| |
| [[index.php?title=File:WBscreenshot15.jpg|right|frameless|513x513px]]
| |
| 4. If clicked on <Country>, you can click on an individual country or options under various categories, such as <Region> and <Income levels>. This example will use the <High Income> category.
| |
| | |
| | |
| 5. If a category is chosen, the following example screen of <High Income> will formulate. From here, choose the relevant topic/theme/SDG Goal, then click on the desired indicator. Then skip to steps 10-12, which show how to download an indicator.
| |
|
| |
| | |
| 6. If an individual country is chosen, the following example screen will formulate. From here, choose the relevant topic/theme/SDG Goal, then click on the desired indicator. Then skip to steps 10-12, which show how to download an indicator.
| |
| | |
| | |
| [[File:WBscreenshot11.jpg|frameless|522x522px|right]]7. If clicked on <Indicator>, navigate to the relevant category of the desired indicator or type in the search bar. | |
| | |
| | |
| | |
| | |
| | |
| | |
| [[File:WBscreenshot4.jpg|frameless|526x526px|right]][[File:WBscreenshot5.jpg|frameless|532x532px|right]]
| |
| | |
| 8. The indicator <Access to electricity (% of population)> will be used as an example. For this data, click on the <Climate Change> category.
| |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| 9. Clicking on <Access to electricity (% of population)> will lead to this page.
| |
| | |
| [[File:WBscreenshot12.jpg|frameless|540x540px|right]]10. If a more specific variable is desired, click one of the options of the right side. As an example, <Access to electricity, urban (% of urban population)> is showed here.
| |
| | |
| [[File:WBscreenshot13.jpg|frameless|541x541px|right]]
| |
| | |
| 11. Before downloading, select desired time range on the sliding scale beneath the graph.
| |
| [[File:WBscreenshot9.jpg|frameless|1x1px|right]]
| |
| | |
| | |
| | |
| 12. On the right side of the graph, under <Download>, click <EXCEL>. An excel data set will immediately download. You may also click <WDI Tables> to see the data in a slightly different format.
| |
| | |
| = Pulling Instructions for World Bank Data- World Development Indicators (WDI) =
| |
| [[File:WBwdiScreenshot2.jpg|frameless|1x1px|right]][[File:WBwdiScreenshot9.jpg|frameless|505x505px|right]]
| |
| | |
| 1. To pull data from the World Bank's World Development Indicators database, navigate to https://databank.worldbank.org/source/world-development-indicators
| |
| | |
| 2. In order to pull data, you'll need to first make selections regarding the database to pull from, countries, series, and time. These variables are on the left hand side.
| |
| | |
| | |
| | |
| [[File:WBwdiScreenshot.jpg|frameless|497x497px|right]][[File:WBwdiScreenshot10.jpg|frameless|495x495px|right]][[File:WBwdiScreenshot4.jpg|frameless|500x500px|right]][[File:WBwdiScreenshot11.jpg|frameless|509x509px|right]]
| |
| | |
| 3. First, choose a database. This example will stay with WDI.
| |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| 4. Second, choose the countries to include in the data. To choose all countries, click the checkbox above the list of country names
| |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| 5. Third, choose series from keywords or alphabetical list. This example will choose <Access to electricity, (% of population)>.
| |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| 6. Finally, choose time as range of years. To choose all countries, click the checkbox above the list of years.
| |
| | |
| | |
| | |
| | |
| | |
| [[File:WBwdiScreenshot12.jpg|frameless|514x514px|right]]
| |
| | |
| | |
| | |
| 7. When all variables have been selected, click <Apply Changes>.
| |
| | |
| | |
| | |
| | |
| | |
| | |
| [[File:WBwdiScreenshot7.jpg|frameless|513x513px|right]][[File:WBwdiScreenshot8.jpg|frameless|516x516px|right]]8. The following preview page will formulate. You can also adjust the layout on the left side under the <Layout> tab, and you can preview data in different formats by clicking on <nowiki><Table>, <Chart>, and <Map>.</nowiki>
| |
| | |
| | |
| | |
| | |
| | |
| 9. To download, click <Download Options> in right hand corner. Then click <Excel> and an Excel dataset will immediately download.
| |
| # | | # |