mazi76erX2/Auto-Report-Generator

Auto-Report-Generator

Generates a excel and powerpoint report using pandas, openpyxl and python-pptx using data exported from DataScouting and Mention.

Place the following files in the same directory and rename them as follows:

DataScouting File --> print.xlsx

Mention --> onlineandsocial.xlsx

Google sheets --> broadcast.xlsx

Mention --> onlineSSA.xlsx

Mention --> socialSSA.xlsx

delete_list.csv

AVE Template.xlsx

run nissan_weekly_pandas.py. This will generate the following files:

AVE Data.xlsx

AVE Report (start date) - (end date).xlsx for example AVE Report 09.08.2018 - 15.08.2018.xlsx

SSA digital data for weekly report (start date) - (end date).xlsx

The output excel file looks like this:

AVE Data

Select the articles the articles that you would like to add to the powerpoint presentation as follows:

In the Print and Online tab highlight 5 product articles in yellow (#FFFFFF00) and 5 corporate articles in green (#FF92D050).

In the Broadcast tab highlight 2 broadcasts in red (#FFFF0000).

AVE Data

In the OnlineSSA and SocialSSA highlight 5 articles in orange (#FFFFC000) and 3 tweets in light blue (#FF00B0F0).

AVE Data

run powerpoint_nissan.py. This will generate the following file:

Nissan Weekly Report (start date) - (end date).pptx for example Nissan Weekly Report 09 August - 15 August 2018

AVE Data

0 likes · 10 views · Sep 20, 2023

Generates a report using openxyl and pandas. Contribute to mazi76erX2/Auto-Report-Generator development by creating an account on GitHub.