Script to parse the generated CSV from the Forest App into a pandas dataframe

forestapp.cc.py

# Script to parse the csv from the Forest App into a pandas dataframe

#%%
import pandas as pd
from datetime import datetime

### Specify pattern for dates in Forest's csv export for dateparser
dateparse = lambda x: datetime.strptime(x, "%a %b %d %H:%M:%S %Z%z %Y")

### Sidenote: Alternative regex patterns
### (1) "%a %b %d %H:%M:%S GMT+08:00 %Y"
### (2) "%a %b %d %H:%M:%S %Z%z %Y"

#%% 
### Read the CSV
df = pd.read_csv("Plants.csv", parse_dates=["Start Time", "End Time"], date_parser=dateparse)
df.head()