Rで何かをしたり、読書をするブログ

政府統計の総合窓口のデータや、OECDやUCIやのデータを使って、Rの練習をしています。ときどき、読書記録も載せています。

OECD Net ODA data analysis 2 - summary() function is to see summary stats. the maximum ODAFLOWS is 36551.15 million USD.

f:id:cross_hyou:20210627092939j:plain

Photo by kazuend on Unsplash

 

www.crosshyou.info

 This blog is following of above blog.

This time, let's import country name data too.

I hvae below CSV file which contains ISO code and country name.

f:id:cross_hyou:20210627093548p:plain

I use read_csv() function to read this data into R.

f:id:cross_hyou:20210627093727p:plain

Then, I use inner_join() to merge previous data frame:df and this data frame:iso_code.

f:id:cross_hyou:20210627093910p:plain

We use summary() to see summary stats of df.

f:id:cross_hyou:20210627094013p:plain

We see ODAFLOWS has 3248 observations, ODAGRANT data has 347 observations, MLN_USD has 1988 observations, PC_GNI has 1607 observations.
The oldest time is 1960 and the latest time is 2020.

The minimum value is 0.00, the maximum value is 37079.53, median value is 45.18 and average value is 1708.01.

 

We use table(9 function to see subjecgt and measure combinations.

f:id:cross_hyou:20210627094456p:plain

We see most frequent combination is ODAFLOWS & MLN_USD, 2nd is ODAFLOWS & PC_GNI, 3rd is ODAGRANT & MLN_USD, the 4th is ODAGRANT & PC_GNI.

Let's see ODAFLOWS & MLN_USD more.

f:id:cross_hyou:20210627094940p:plain

time has 1960 to 2020 range. value has 0.39 to 36551.15 range.

How about ODAFLOWS & PC_GNI?

f:id:cross_hyou:20210627095219p:plain

time has 1960 to 2017 range, it is a shorter than ODAFLOWS & MLN_USD.

value has 0.001316 to 1.404549.

Let's see ODAGRANT & MLN_USD

f:id:cross_hyou:20210627095525p:plain

time range is 2015 to 2020, it is very shorther than ODAFLOWS data.

value range is 19.96 to 37079.53.

How about ODAGRANT & PC_GNI?

f:id:cross_hyou:20210627095801p:plain

time range is 2018 to 2020. value range is 0.02748 to 1.15007.

That's it.

To see the 1st blog,

 

www.crosshyou.info

 The next blog is

 

www.crosshyou.info