In [4]:

    

import matplotlib.pyplot as plt
import numpy as np
import pandas as pd


    

In [16]:

    

data=pd.read_csv("raintemp.csv", index_col=None)
for line in data:
    print(line)


    

    




loc
lat
long
year
month
rain(mm)
temp(dC)

In [28]:

    

table=pd.pivot_table(data, values=["rain(mm)","temp(dC)"], index=["loc","month"])
table
table.query('loc=="Agna"')


    

    
Out[28]:






  

    

      

      

      
rain(mm)
      
temp(dC)
    
    

      
loc
      
month
      

      

    
  
  

    

      
Agna
      
1
      
44.266667
      
2.823810
    
    

      
2
      
47.095238
      
4.223810
    
    

      
3
      
55.095238
      
8.657143
    
    

      
4
      
74.257143
      
12.885714
    
    

      
5
      
78.342857
      
18.042857
    
    

      
6
      
72.666667
      
21.800000
    
    

      
7
      
50.333333
      
23.700000
    
    

      
8
      
64.780952
      
23.204762
    
    

      
9
      
79.295238
      
18.609524
    
    

      
10
      
86.323810
      
13.933333
    
    

      
11
      
81.400000
      
8.614286
    
    

      
12
      
60.523810
      
3.680952