Skip to content

Instantly share code, notes, and snippets.

@DerekHawkins

DerekHawkins/report_automation_part_4.py

Created July 29, 2019 11:58
Show Gist options
  • Save DerekHawkins/601962957930b3388490d9aa075dfb95 to your computer and use it in GitHub Desktop.
Save DerekHawkins/601962957930b3388490d9aa075dfb95 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
report_automation_part_4.py
### Record All Data ###
writer = pd.ExcelWriter('kpi_report_%s.xlsx' % (date_main), engine='xlsxwriter')
# Write each dataframe to a different worksheet.
final_search_presence.to_excel(writer, sheet_name='SERP Presence')
serp_results.to_excel(writer, sheet_name='SERP Engagement')
new_bl.to_excel(writer, sheet_name="{} Backlinks".format(len(new_bl.first_seen)))
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment