Python: Excel - Bar chart plot

[jamescooper]

import pandas as pd
import matplotlib.pyplot as plt
filtered_df = df[df['Hotel Name'] == 'Clayton Hotel']
today_format = datetime.strptime(datetime.today().strftime('%d/%m/%Y'), "%d/%m/%Y")
filtered_df = df[df['Date Captured'] == today_format]
df.plot(x="Check-In", y=["'Current price'"], kind="bar")

Any ideas what I am doing wrong here?

Many thanks.

 

[Cubist]

You might need plt.show()
TIMEOUT#! usually means the execution time took too long.

 

[Cubist]

Noticed something else you declared today_format after filtering it. You had it in correct order in post #1 but not #8.

 

[jamescooper]

Thanks.

Still no joy with the following, not sure if the order is wrong?

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 = df[df['Date Captured'] == today_format]
df.plot(x="Check-In", y=["Current price"], kind="bar")
filtered_df = df[df['Hotel Name'] == 'Clayton Hotel']
plt.show()

 

[Cubist]

The order is still wrong. Are you plotting df or filtered_df?

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 = df[(df['Hotel Name'] == 'Clayton Hotel') & (df['Date Captured'] == today_format)]
filtered_df.plot(x="Check-In", y=["Current price"], kind="bar")
plt.show()

 

[rowebca]

Thanks.

Still no joy with the following, not sure if the order is wrong?

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 = df[df['Date Captured'] == today_format]
df.plot(x="Check-In", y=["Current price"], kind="bar")
filtered_df = df[df['Hotel Name'] == 'Clayton Hotel']
plt.show()

You know that this line will output: 2025-02-09 00:00:00
Is this correct for you? Shouldn't be just 2025-02-09?


Regards,
GB

 

[jamescooper]

The order is still wrong. Are you plotting df or filtered_df?

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 = df[(df['Hotel Name'] == 'Clayton Hotel') & (df['Date Captured'] == today_format)]
filtered_df.plot(x="Check-In", y=["Current price"], kind="bar")
plt.show()

This is working! It only displays as an image is this correct?

 

[Cubist]

Yes, image objects.

 

[jamescooper]

Thanks,

how do I take 3 days away from: today_format = datetime.strptime(datetime.today().strftime('%d/%m/%Y'), "%d/%m/%Y")

Many thanks.

 

[Cubist]

from datetime import datetime, timedelta

formatted_date = (datetime.today() - timedelta(days=3)).strftime('%d/%m/%Y')