Feature Request: Parse JSON files with gpt

[etewiah]

This is as much a note to myself as anything else. I'm planning to send all my saved json files to gpt and ask it to generate a report from it for me.

Opening an issue here so if anyone else is planning on doing this they can share their results here.

[etewiah]

Just to get started I pasted in my json data for a few days on the chat gpt web interface and asked for it to be summarised. This is what I got back:

This JSON file contains an array of objects, where each object represents a time duration and its corresponding date. The date and time are given in the ISO 8601 format, and the duration is given in seconds. The data appears to cover a period from December 31, 2019, to January 4, 2020.

[etewiah]

This was the data I pasted so I was pretty impressed with it!

[{"date":"2020-01-04T02:38:25Z","duration":744},{"date":"2020-01-03T17:48:38Z","duration":2927},{"date":"2020-01-03T16:54:26Z","duration":2855},{"date":"2020-01-03T15:25:55Z","duration":2689},{"date":"2020-01-03T14:29:08Z","duration":2522},{"date":"2020-01-03T08:12:55Z","duration":462},{"date":"2020-01-03T02:43:45Z","duration":1764},{"date":"2020-01-02T20:12:26Z","duration":2791},{"date":"2020-01-02T18:23:32Z","duration":2661},{"date":"2020-01-02T17:20:02Z","duration":2749},{"date":"2020-01-02T15:32:43Z","duration":2806},{"date":"2020-01-02T14:19:46Z","duration":2802},{"date":"2020-01-02T13:02:28Z","duration":3065},{"date":"2020-01-02T08:14:12Z","duration":3256},{"date":"2020-01-02T06:55:21Z","duration":3889},{"date":"2020-01-02T05:25:59Z","duration":3478},{"date":"2020-01-02T03:56:30Z","duration":3},{"date":"2020-01-02T03:56:26Z","duration":2333},{"date":"2020-01-01T18:37:29Z","duration":1},{"date":"2020-01-01T18:37:26Z","duration":107754},{"date":"2019-12-31T12:36:54Z","duration":3445},{"date":"2019-12-31T11:39:28Z","duration":2442}]

[etewiah]

When I asked it to summarise hours per day though it got that quite wrong:

Prompt:

Please summarise how many hours were logged on each given day

Result:

To summarize the number of hours logged on each given day, we can calculate the total duration for each day and convert it into hours. Here's the summary:

December 31, 2019: 0.96 hours
January 1, 2020: 29.93 hours
January 2, 2020: 25.56 hours
January 3, 2020: 2.84 hours
January 4, 2020: 0.21 hours

Note that the duration is rounded to two decimal places.