products Namespace Reference

How to replace VBA with Python: OpenPyxl, Pandas, xlWings. More...

Variables
dictionary	product
	df = pd.DataFrame(product)
	window
	figsize
	label
	loc

Detailed Description

How to replace VBA with Python: OpenPyxl, Pandas, xlWings.

• py39-xlrd
• py39-xlsxwriter
• py39-openpyxl

Author

Paulo Roma

Since

07/11/2021

See also

https://www.datacamp.com/community/tutorials/moving-averages-in-pandas

https://pandas.pydata.org/pandas-docs/stable/reference/api/pandas.DataFrame.iloc.html

Variable Documentation

df

products.df = pd.DataFrame(product)

figsize

products.figsize

label

products.label

loc

products.loc

product

dictionary products.product

Initial value:

=  {'month': [1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12],
           'demand': [290, 260, 288, 300, 310, 303, 329, 340, 316, 330, 308, 310]}

window

products.window