Accessing columns row by row in dataframe in python

Question

I have a dataframe of 300 columns, I'm trying to calculate the mean of the columns in this dataframe, but I don't know how to change the columns.

count=0
for i in range(0,len(df)):
  count=count+1
  mean = statistics.mean(df.A1)
  print('C',count, " ", mean, sep= "")

I need to get the column names from A1 to A300 row by row. I didn't want to do this manually

My dataframe columns like A1,A2,A3.. A.300

how can i step by step change this columns name?

I'm trying to calculate the mean of the columns in this dataframe: have you tried df.mean(), no need to iterate. — mozway
– mozway, Commented Aug 1, 2021 at 19:09
Does this answer your question? pandas get column average/mean — mozway
– mozway, Commented Aug 1, 2021 at 19:11

RG_RG · Accepted Answer · 2021-08-01 15:35:15Z

1

Just iterate through columns,

cols = df.columns
for col in cols:
  mean = df[col].mean()
  print(col, mean)

edited Aug 1, 2021 at 15:35

answered Aug 1, 2021 at 15:18

RG_RG

4066 silver badges9 bronze badges

Sign up to request clarification or add additional context in comments.

6 Comments

gorkemco Over a year ago

Not work: ` TypeError: can't convert type 'str' to numerator/denominator ` @RG_RG

RG_RG Over a year ago

can you share your dataframe?

RG_RG Over a year ago

If you just want mean, you can use df.mean() function.

gorkemco Over a year ago

I don't need a function, i need a loop for the every columns mean. Like. A1 means, A2 means... A300 means. so i need change the column name. But i don't know i make this.

RG_RG Over a year ago

df.mean() is an inbuilt method. just use it like the code above, it works.

|

Collectives™ on Stack Overflow

Accessing columns row by row in dataframe in python

1 Answer 1

6 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

6 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related