Skip to content

Improve the usability of the Daylio CSV export and explore reports around your data โ˜บ๏ธ ๐Ÿ“† ๐Ÿ

License

Notifications You must be signed in to change notification settings

MichaelCurrin/daylio-csv-parser

Folders and files

NameName
Last commit message
Last commit date

Latest commit

ย 
ย 
ย 
ย 
ย 
ย 
ย 
ย 
ย 
ย 
ย 
ย 
ย 
ย 
ย 
ย 
ย 
ย 
ย 
ย 
ย 
ย 
ย 
ย 
ย 
ย 
ย 
ย 
ย 
ย 
ย 
ย 
ย 

Repository files navigation

Daylio CSV Parser โ˜บ๏ธ ๐Ÿ“† ๐Ÿ

Improve the usability of the Daylio CSV export and explore reports around your data

GitHub tag License

Made with Python Made with SQLite dependency - statsmodels dependency - pandas

This Python 3 CLI took will convert a Daylio CSV export into a more usable CSV and a SQLite database.

About Daylio CSV

What is Daylio? Read on this doc page.

This daylio-csv-parser application parses a CSV exported from Daylio (in premium mode) to create a more useful CSV.

In particular, the activities column with multiple activities listed in a single cell is split out into multiple columns, with appropriate names and values as 0 or 1.

Sample usage

A summary of the command-line API is covered below.

Main feature

Run the main script to read CSV exported from Daylio at a configured location and create a clean CSV.

$ make csv

Other features

Assuming you have created a clean CSV using the step above, you can run any of these commands if you wish to. The order does not matter.

Database

Create a database file from the cleaned CSV. You can then access data in the database.

$ make db

Aggregate mood report

View a report around mood score aggregate stats.

$ ./mood_report.py

Regression report

View a report on a stats model which was fitted your data.

$ ./fit_model.py

Documentation

view - Online docs

License

Released under MIT by @MichaelCurrin.