Info Vidor

Inside the titan submarine , 5 deaths are claimed by the cost guard on the titan vessel.

I was trying to calculate mean of a row in my weather forecast dataset,first try was with for loop but it was taking time on 16 lac rows. Then i found a method using (iloc) in padas calculate average with out mean , it was a great trick so i am going to share,

Description:

first of all import libraries, then in 3rd line read dataset file. in 4th line convert ds into dataframe. in 5th line use slicing (:)used for range, all rows and (4:0) from 4th column to onward (n cols). in 6th line apply mean on (iloc) selected rows and cols. in 7th line add a new column with label i want to write as column name. Then print df contained all those cols and rows.

Code:

/////////////////////////////////////////////////////////////////////

1) = import pandas as pd (import pandas lib)

2) =import numpy as np (import numpy lib)

3) = data = pd.read_csv('mintmp2019.csv')

4) = df = pd.DataFrame(data)

5) = df.iloc[:,4:]

6) = df.iloc[:,4:].mean(axis=1)

7) = df['mintemp_mean']=df.iloc[:,4:].mean(axis=1)

8) = print(df)

////////////////////////////////////////////////////////////////////