Not sure if you've solved this yet or not, but I've found Power BI (a free microsoft package) handles the json files well - you can select whatever folder they are in, set up the input and you end up with data that you can graph etc. I also like excel - one option is to do the json aggregation in power bi - not sure if you can then export the query back to Excel (you very well may be able to do so), but you can definitely export the resulting data file back into an excel or csv file and open in Excel easily. I don't anticipate this being a real problem, just a revision of the upload queries to fix the datetime to local when I can figure out which are which. So plotting HR vs O2 vs Sleep stage isn't necessarily aligned, so can't really process yet. The issue I have now is that the datetime fields are oddly formatted and some json files (maybe all, still looking) store info in GMT instead of local time. It took some finagaling to get the json files to work (I'm self-taught in Power BI) but was successful. sleep score) or combine multiple csv or json files into a single data table. I can download the Fitbit account archive onto the computer and then use Power BI to pull in the single csv files (e.g. I've had some success using Power BI (another Microsoft product, free on desktop) - it basically is the Excel power query made into a standalone produce.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |