Data Interview Qs - Creating a quick data pipeline

Suppose you're given the following dataframe:

Using this data, write a data processing pipeline to perform the following actions to the data:

• Groups the dataframe by a specified column and returns the mean age of the group
• Converts the column name to uppercase

If you're using a Python, you can build the dataframe out using the below code:

                    
import pandas as pd
                    
# Create empty dataframe
                    
df = pd.DataFrame()
                    
# Create columns
                    
df['name'] = ['Paul', 'Sean', 'Jenn']
                    
df['gender'] = ['Male', 'Male', 'Female']
                    
df['age'] = [23, 35, 17]
                    
# Preview dataframe
                    
df.head()
                    

Solution will be written in Python for premium users.