In [1]:
# Import libraries
import pandas as pd
import sys
In [2]:
# Our small data set
list_for_data = [0,1,2,3,4,5,6,7,8,9]
# Create dataframe
df = pd.DataFrame(list_for_data)
df
Out[2]:
In [3]:
df.columns
Out[3]:
In [4]:
df.columns = ['Rev']
df
Out[4]:
In [5]:
# Adding new column
df['NewCol'] = 5
In [6]:
df
Out[6]:
In [7]:
# Lets modify our new column
df['NewCol'] = df['NewCol'] + 1
df
Out[7]:
In [8]:
# We can delete columns
del df['NewCol']
df
Out[8]:
In [9]:
# Lets add a couple of columns
df['test'] = 3
df['col'] = df['Rev']
df
Out[9]:
In [10]:
df.index
Out[10]:
In [11]:
# change the name of the index
i = ['a','b','c','d','e','f','g','h','i','j']
df.index = i
df
Out[11]:
In [12]:
# select pieces of the dataframe using loc.
df.loc['a']
Out[12]:
In [13]:
# df.loc[inclusive:inclusive] -> few rows
df.loc['a':'d']
Out[13]:
In [14]:
# first three rows
df.iloc[0:3]
Out[14]:
In [15]:
df[['Rev', 'test']]
Out[15]:
In [16]:
df['col'][5:]
Out[16]:
In [17]:
# Select top N number of records (default = 5)
df.head()
Out[17]:
In [18]:
# Select bottom N number of records (default = 5)
df.tail()
Out[18]:
In [ ]: