# Average each Column and Row in Pandas DataFrame

You may use the following syntax to get the average for each column and row in pandas DataFrame:

(1) Average for each column:

```df.mean(axis=0)
```

(2) Average for each row:

```df.mean(axis=1)
```

Next, I’ll review an example with the steps to get the average for each column and row for a given DataFrame

## Steps to get the Average for each Column and Row in Pandas DataFrame

### Step 1: Gather the data

To start, gather the data that needs to be averaged.

For example, I gathered the following data about the commission earned by 3 employees (over the first 6 months of the year): The goal is to get the average of the commission earned:

• For each employee over the first 6 months (average by column)
• For each month across all employees (average by row)

### Step 2: Create the DataFrame

Next, create the DataFrame in order to capture the above data in Python:

```import pandas as pd

data = {'Month': ['Jan ','Feb ','Mar ','Apr ','May ','Jun '],
'Jon Commission': [7000,5500,6000,4500,8000,6000],
'Maria Commission': [10000,7500,6500,6000,9000,8500],
'Olivia Commission': [3000,6000,4500,4500,4000,5500]
}

df = pd.DataFrame(data,columns=['Month','Jon Commission','Maria Commission','Olivia Commission'])
print (df)
```

Run the code in Python, and you’ll get the following DataFrame: ### Step 3: Get the Average for each Column and Row in Pandas DataFrame

You can then apply the following syntax to get the average for each column:

```df.mean(axis=0)
```

For our example, this is the complete Python code to get the average commission earned for each employee over the 6 first months (average by column):

```import pandas as pd

data = {'Month': ['Jan ','Feb ','Mar ','Apr ','May ','Jun '],
'Jon Commission': [7000,5500,6000,4500,8000,6000],
'Maria Commission': [10000,7500,6500,6000,9000,8500],
'Olivia Commission': [3000,6000,4500,4500,4000,5500]
}

df = pd.DataFrame(data,columns=['Month','Jon Commission','Maria Commission','Olivia Commission'])

av_column = df.mean(axis=0)
print (av_column)
```

Run the code, and you’ll get the average commission per employee: Alternatively, you can get the average for each row using the following syntax:

```df.mean(axis=1)
```

Here is the code that you can use to get the average commission earned for each month across all employees (average by row):

```import pandas as pd

data = {'Month': ['Jan ','Feb ','Mar ','Apr ','May ','Jun '],
'Jon Commission': [7000,5500,6000,4500,8000,6000],
'Maria Commission': [10000,7500,6500,6000,9000,8500],
'Olivia Commission': [3000,6000,4500,4500,4000,5500]
}

df = pd.DataFrame(data,columns=['Month','Jon Commission','Maria Commission','Olivia Commission'], index =['Jan ','Feb ','Mar ','Apr ','May ','Jun '])

av_row = df.mean(axis=1)
print (av_row)
```

Once you run the code in Python, you’ll get the average commission earned per month: You may also want to check the following source that explains the steps to get the sum for each column and row in pandas DataFrame.