Finding next month: Excel, Python

[jamescooper]

Hello the following returns "Feb 25"

today = datetime.datetime.today().date()
string_date = today.strftime("%b %y")

I now want to adapt so that it finds the next month from today, "Mar 25".

Any ideas, thanks.

 

[MARK858]

Thanks, why is the font critical?

So if I had Mar 25 in cell A1, so if I was able to put the text in bold in a cell?

 

[jamescooper]

Sorry, I must have typed that in error.

All I want to be able to do is refer to the cell. As shown in the code below.

Thanks Mark.

import pandas as pd
import matplotlib.pyplot as plt
from datetime import datetime
import datetime
import matplotlib.dates as mdates
import numpy as np
import matplotlib.ticker as plticker
from dateutil.relativedelta import relativedelta
import calendar

today = datetime.datetime.today().date()
string_date = Cell T1 (which is: Mar 25)

df["Date Captured"] = pd.to_datetime(df["Date Captured"])
df["Check-In"] = pd.to_datetime(df["Check-In"])
df_filtered = df[(df["Date Captured"].dt.date == today) & (df["Mon Year"] == string_date)]
grouped = df_filtered.groupby("Check-In")["Current price"].min().reset_index()

 

[MARK858]

Using openpyxl it would just be

wb = Workbook()

sheet = wb.active

YOURVARIABLE = sheet['T1'].Value

 

[jamescooper]

Thanks, I've tried this and I receive this error when referring to cell T1.

AttributeError: 'Cell' object has no attribute 'Value'

Any idea?

 

[MARK858]

Only if you haven't loaded your actual workbook or sheet

 

[jamescooper]

Not sure what you mean sorry?

 

[MARK858]

Using openpyxl

from openpyxl import load_workbook

yourWb = load_workbook(filename='YourFile.xlsx')

yourWs = yourWb['Sheet1']

YourString = yourWs['T1'].Value

 

[jamescooper]

So the cell, T1 is in the file I am working?

 

[jamescooper]

This is my entire code; it plots a bar chart in the spreadsheet I'm working. Cell "T1" is in sheet named "Visuals"

I've added in your suggestions. Hopefully this helps...

import pandas as pd
import matplotlib.pyplot as plt
from datetime import datetime
import datetime
import matplotlib.dates as mdates
import numpy as np
import matplotlib.ticker as plticker
from dateutil.relativedelta import relativedelta
import calendar
import openpyxl
from openpyxl import load_workbook

yourWb = load_workbook(filename='Python Testing.xlsm')
yourWs = yourWb['Visuals']

today = datetime.datetime.today().date()
string_date = yourWs['T1']
long_string_date = "March 2025"

df["Date Captured"] = pd.to_datetime(df["Date Captured"])
df["Check-In"] = pd.to_datetime(df["Check-In"])
df_filtered = df[(df["Date Captured"].dt.date == today) & (df["Mon Year"] == string_date)]
grouped = df_filtered.groupby("Check-In")["Current price"].min().reset_index()

fig, ax = plt.subplots()
p1 = ax.bar(grouped["Check-In"], grouped["Current price"], color='g')
ax.bar_label(p1, label_type="edge")
ax.bar_label(p1)

# Formatting the x-axis
ax.xaxis.set_major_formatter(mdates.DateFormatter("%a %d")) # Format as "Jan 2025"
loc = plticker.MultipleLocator(base=1.0) # this locator puts ticks at regular intervals
ax.xaxis.set_major_locator(loc)
plt.xlabel("Check-In Date")
plt.ylabel("Price (£)")
plt.title(long_string_date)
plt.xticks(rotation=90) # Rotate labels
plt.ylim(50, 200)
plt.show()

 

[MARK858]

Openpyxl isn't compliant with xlsm, I think you need to do some reading up on the libraries and Python programming as it will help you more than forums