104.2.3 Manipulating datasets in python

link to the previous post : https://course.dvanalyticsmds.com/104-2-2-practice-working-with-datasets-in-python/

In this blog we will see how we can manipulate imported dataset into subsets.

import pandas as pd   
#The below line may throw some error
gdp=pd.read_csv("datasets\\World Bank Data\\GDP.csv",encoding = "ISO-8859-1")

gdp.shape

(194, 4)

gdp.columns.values

array(['Country_code', 'Rank', 'Country', 'GDP'], dtype=object)

gdp1 = gdp.head(10)
gdp2=gdp.iloc[[2,9,15,25]]
print(gdp2)

   Country_code  Rank             Country      GDP
2           JPN     3               Japan  4601461
9           RUS    10  Russian Federation  1860598
15          IDN    16           Indonesia   888538
25          NOR    26              Norway   499817

gdp3 = gdp[["Country", "Rank"]]
gdp3

gdp4 = gdp[["Country", "GDP"]][0:10]
gdp4

gdp5=gdp.drop(["Country_code"], axis=1)[0:12]
gdp5

The next post is a practice session on manipulating dataset in python.
Link to the next post : https://course.dvanalyticsmds.com/104-2-4-practice-manipulating-dataset-in-python/