Python chart: Minimum value

[jamescooper]

Not sure why this doesn't work?

import pandas as pd
from datetime import datetime
import matplotlib.pyplot as plt

today_format = datetime.strptime(datetime.today().strftime('%d/%m/%Y'), "%d/%m/%Y")
filtered_df = values=df['Current price'], aggfunc='min') & (df['Date Captured'] == today_format)]
filtered_df.plot(x="Mon Year", y=["Current price"], kind="bar")
plt.title("Minimum Price")
plt.xlabel("Month Year")
plt.ylabel("Price (£)")
plt.locator_params(axis='x', nbins=12)
plt.show()

 

[Cubist]

filtered_df = values=df['Current price'], aggfunc='min') & (df['Date Captured'] == today_format)]

What are you trying to do here? Syntax looks wrong.

 

[jamescooper]

Yeah that's the bit that is wrong.

Minimum value of Current price

 

[Cubist]

Minimum of the entire column or aggregate min by some other field?

 

[jamescooper]

Thanks.

Minimum per the current date, i.e. date captured.

(df['Date Captured'] == today_format)]

 

[Cubist]

Maybe this.

import pandas as pd
from datetime import datetime
import matplotlib.pyplot as plt

df['Date Captured'] = pd.to_datetime(df['Date Captured'], format='%d/%m/%Y')
today_format = datetime.today().strftime('%Y-%m-%d')
grouped_df = df.groupby('Date Captured')['Current price'].min().reset_index()
filtered_df = grouped_df[grouped_df['Date Captured'] == today_format]
filtered_df['Mon Year'] = filtered_df['Date Captured'].dt.strftime('%b %Y')
plt.bar(filtered_df['Mon Year'], filtered_df['Current price'])

plt.title("Minimum Price")
plt.xlabel("Month Year")
plt.ylabel("Price (£)")
plt.show()

 

[jamescooper]

Maybe this.

import pandas as pd
from datetime import datetime
import matplotlib.pyplot as plt

df['Date Captured'] = pd.to_datetime(df['Date Captured'], format='%d/%m/%Y')
today_format = datetime.today().strftime('%Y-%m-%d')
grouped_df = df.groupby('Date Captured')['Current price'].min().reset_index()
filtered_df = grouped_df[grouped_df['Date Captured'] == today_format]
filtered_df['Mon Year'] = filtered_df['Date Captured'].dt.strftime('%b %Y')
plt.bar(filtered_df['Mon Year'], filtered_df['Current price'])

plt.title("Minimum Price")
plt.xlabel("Month Year")
plt.ylabel("Price (£)")
plt.show()

This is close, this returns the minimum value for all Check-In dates, I'd like all dates to be shown in the data set.

 

[Cubist]

But you want to plot "Month Year" only...confused. Post a sample of your data set.

 

[jamescooper]

So it is as below, I'd like "Check-in" date along the x-axis and "Current price" (Minimum) along the y-axis, for today's date as "Date captured"

Hopefully that makes sense?

Date Captured	Hotel Name	Check-In	Current price
2025-02-13	Radisson Blu Hotel, Cardiff	2025-02-13	£83
2025-02-13	Hilton Cardiff	2025-02-13	£109
2025-02-13	Central Cardiff - 3 Bedroom Home - Free Parking - Walk to Shopping Town Centre And Cardiff Castle	2025-02-13	£170
2025-02-13	Clayton Hotel Cardiff	2025-02-13	£85
2025-02-13	The Parkgate Hotel	2025-02-13	£103
2025-02-13	Sleeperz Hotel Cardiff	2025-02-13	£56
2025-02-13	Mercure Cardiff Holland House Hotel & Spa	2025-02-13	£89
2025-02-13	Novotel Cardiff Centre	2025-02-13	£84
2025-02-13	Park Plaza Cardiff	2025-02-13	£92
2025-02-13	Leonardo Hotel Cardiff	2025-02-13	£89
2025-02-13	Park Inn by Radisson Cardiff City Centre	2025-02-13	£89
2025-02-13	Cardiff Marriott Hotel	2025-02-13	£114
2025-02-13	The Angel Hotel	2025-02-13	£60
2025-02-13	Holiday Inn Cardiff City by IHG	2025-02-13	£85
2025-02-13	Cardiff Sandringham Hotel	2025-02-13	£43
2025-02-13	Hotel Indigo - Cardiff by IHG	2025-02-13	£99
2025-02-13	ML Lodge	2025-02-13	£47
2025-02-13	Dray Court - Luxury 2 Bedroom Apartment	2025-02-13	£156
2025-02-13	Sky Night Serviced Apartments	2025-02-13	£98

 

[jamescooper]

Did that help?

Thanks Cubist!