Skip to content

Instantly share code, notes, and snippets.

@33sticks

33sticks/aa-py-remove-header.py

Created July 28, 2017 18:33
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save 33sticks/eadbdcbb9ab0a48edd97751e4836ab74 to your computer and use it in GitHub Desktop.
Save 33sticks/eadbdcbb9ab0a48edd97751e4836ab74 to your computer and use it in GitHub Desktop.
Download ZIP
This Python script will remove the comment header from a downloaded Adobe Analytics report
Raw
aa-py-remove-header.py
#import the pandas library
import pandas as pd
#pull adobe report download into a dataframe; ignorning the comment header
df = pd.read_csv("/Users/jasonthompson/Documents/analysis/python/sp/adobe_id.csv", comment="#", header=1)
#export cleaned data to a new csv file
df.to_csv("/Users/jasonthompson/Documents/analysis/python/sp/adobe_id_no-comments.csv", encoding='utf-8')
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment