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

Variables
	df = pd.read_csv("AirQualityUCI/AirQualityUCI.csv", sep=";", decimal=",")

	inplace

	df_T = pd.DataFrame(df.iloc[:, -2])

	min_periods

	DateTime

	index

	figsize

	label

	loc

	span

	adjust

Detailed Description

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

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; https://archive.ics.uci.edu/ml/datasets/air+quality

Variable Documentation

air.adjust

air.DateTime

air.df = pd.read_csv("AirQualityUCI/AirQualityUCI.csv", sep=";", decimal=",")

air.df_T = pd.DataFrame(df.iloc[:, -2])

air.figsize

air.index

air.inplace

air.label

air.loc

air.min_periods

air.span