Python in Excel: Crosstab with

[jamescooper]

I have the following crosstab working returning the max values.

import pandas as pd
ct_mean = pd.crosstab(df['Check-In'], df['Date Captured'],
values=df['Current price'], aggfunc='max')


Now want to add another variable: Hotel Name column needs to be equal to "A" (for example).

How would I add this variable to the code above?

Many thanks.

 

[Cubist]

You can filter the data set first. Something like this. Not tested.

import pandas as pd

filtered_df = df[df['Hotel Name'] == 'A']

ct_mean = pd.crosstab(filtered_df['Check-In'], filtered_df['Date Captured'], values=filtered_df['Current price'], aggfunc='max')

 

[jamescooper]

Thank you so much again Cubist.

 

[Cubist]

You're welcome.