notebook.community

Edit and run



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



In [3]:

    
df.columns









    Out[3]:





Int64Index([0], dtype='int64')



In [4]:

    
df.columns = ['Rev']
df



In [5]:

    
# Adding new column
df['NewCol'] = 5



In [6]:

    
df



In [7]:

    
# Lets modify our new column
df['NewCol'] = df['NewCol'] + 1
df



In [8]:

    
# We can delete columns
del df['NewCol']
df



In [9]:

    
# Lets add a couple of columns
df['test'] = 3
df['col'] = df['Rev']
df



In [10]:

    
df.index









    Out[10]:





Int64Index([0, 1, 2, 3, 4, 5, 6, 7, 8, 9], dtype='int64')



In [11]:

    
# change the name of the index
i = ['a','b','c','d','e','f','g','h','i','j']
df.index = i
df



In [12]:

    
# select pieces of the dataframe using loc.
df.loc['a']









    Out[12]:





Rev     0
test    3
col     0
Name: a, dtype: int64



In [13]:

    
# df.loc[inclusive:inclusive] -> few rows
df.loc['a':'d']



In [14]:

    
# first three rows
df.iloc[0:3]



In [15]:

    
df[['Rev', 'test']]



In [16]:

    
df['col'][5:]









    Out[16]:





f    5
g    6
h    7
i    8
j    9
Name: col, dtype: int64



In [17]:

    
# Select top N number of records (default = 5)
df.head()



In [18]:

    
# Select bottom N number of records (default = 5)
df.tail()



In [ ]: