GDP is an abbreviation for Gross Domestic Product, which refers to the total amount of production activity in a country or region in a certain period of time, and is one of the most important ways to measure the size and level of development of the economy.
This section crawls the GDP data of Russia and Ukraine over the years, uses PowerQuery data cleaning, including data format conversion, numerical extraction, data reverse perspective, etc., and finally visualizes dynamic data with the help of dysprosium chart dynamic line template.
1. Data acquisition
The data crawled in this section comes from The Easy Banking Network, after entering the webpage, click Custom Country Filter.
Second, data crawling
Copy and paste the web page URL as follows, create a new empty Excel workbook, click the Data tab, select From Web, copy and paste the page URL to the address, click Go, import the data.
https://www.kylc.com/stats/global/yearly_per_country/g_gdp/rus-ukr.html 3. Data cleaning
Delete excess data, select all data, click from the table, and enter the PowerQuery data cleaning interface.
Right-click a column of data and click Delete Column to delete the excess column.
Click the filtered inverted triangle symbol and click Delete Empty to delete the blank rows.
Extract the GDP value of Russia, click Extract, select the text between the separators.
Set the start separator and end separator of the separator separately, and click OK.
Similarly, extract Ukraine's GDP value.
The extracted GDP value is of type text, which is set to integer type in the data type.
Since the value is larger, here directly divide the value by 100000000, click standard, select division, enter 1000000000 in the value here, click Confirm.
Click the Close and Apply button above to load the data into an Excel workbook.
Fourth, data visualization
Data Dynamic Visualization Here select the Dysprosium Chart, a website for online data visualization and analysis.
Select a dynamic line change chart in the chart template.
Click Edit Data to upload the cleaned data to the data editing interface.
After the data is loaded in, you can edit the chart, including setting the chart title, data source, line color, etc., and you can download and export the .mp4 video after the chart is edited.
If you like it, retweet it and share it, and continue to share data analysis content~