Python code for Excel

[jamescooper]

Got my data loaded through a connection, a sample of the data is shown below.

In Python for Excel I have successfully used:

df['Current price'].mean() To determine the mean

How do I now determine the mean of Check-In dates?

This is what I have tried without success.

df.groupby(["Check-In"]).['Current price'].mean()

Any help appreciated.

Source.Name	Date Captured	Hotel Name	Check-In	Check-Out	Price	rating	Original price	Current price
2025-01-22.xlsx	22/01/2025	Radisson Blu Hotel, Cardiff	22/01/2025	23/01/2025	Original price £104. Current price £94.	Scored 7.9	Original price £104	94
2025-01-22.xlsx	22/01/2025	Park Inn by Radisson Cardiff City Centre	22/01/2025	23/01/2025	Price £79	Scored 7.8	None	79
2025-01-22.xlsx	22/01/2025	Hotel Indigo - Cardiff, an IHG Hotel	22/01/2025	23/01/2025	Price £134	Scored 8.9	None	134
2025-01-22.xlsx	22/01/2025	Clayton Hotel Cardiff	22/01/2025	23/01/2025	Original price £139. Current price £125.	Scored 8.4	Original price £139	125
2025-01-22.xlsx	22/01/2025	Holiday Inn Cardiff City, an IHG Hotel	22/01/2025	23/01/2025	Price £94	Scored 8.1	None	94

 

[Cubist]

Try:

df.groupby('Check-In')['Current price'].mean()

 

[jamescooper]

Try:

df.groupby('Check-In')['Current price'].mean()

Thanks a lot!

Is there any Internet content you can recommend for learning these basics for Python formulas in Excel?

Thanks.

 

[saboh12617]

Hello,
From a Python/Pandas "point of view", your proposition was absolutely correct. There is no difference between single quote and double ones to delimit strings. I think the latter are forbidden/buggy? in Python for Excel as they might interfere with Excel double-quote string delimiter.

 

[Cubist]

Is there any Internet content you can recommend for learning these basics for Python formulas in Excel?

Python in Excel is simply Python.
There are many resources to learn Python.