Creating mean for every row inside dataframe

Question

I want to create mean for every row but the one of the row don't show up in my code. Here is what the dataframe looks like :

    A           
0   230     235     210     235
1   345     375     385     378
2   222     292     260     292

And here is my code

df = pd.DataFrame({'A':[230,345,222],' ':[235,375,292],'   ':[210,385,260],'  ':[235,378,292]})
data = df.iloc[:,0:3]
mean = data.mean(axis=0)

and what i got as result

A      265.666667
       300.666667
       285.000000
dtype: float64

I only got 3 mean result but the results should be 4 means. After that I want to average the results again but that is problem for later. Any ideas?

`df.iloc[:,0:3]` will only take first three rows. – CodeIt Mar 31 '20 at 14:29 — CodeIt, Mar 31 '20 at 14:29
@CodeIt first three rows? or three columns? – Quang Hoang Mar 31 '20 at 14:39 — Quang Hoang, Mar 31 '20 at 14:39
@QuangHoang Sorry, my bad. It is first three columns. – CodeIt Mar 31 '20 at 14:59 — CodeIt, Mar 31 '20 at 14:59

kederrac · Accepted Answer · 2020-03-31T14:42:02.740

3

you can use:

df.mean()

output:

A      265.666667
       300.666667
       285.000000
       301.666667
dtype: float64

After that I want to average the results again

you may use:

df.mean().mean()

output:

288.25

edited Mar 31 '20 at 14:42

answered Mar 31 '20 at 14:33

kederrac

sorry but I need to use iloc for this code, I just want to average the first 3 row – ojasony Mar 31 '20 at 16:23

1 Answers1