I'm looking to do some simple data mining that consists of going once per day to a single page and collect the following information:
- List of movie theaters
- Movies today on each theater
- Session times for each movie
- Availability of tickets for each session (boolean yes/no)
I want to catalog this information and after 1 year see an overlay graph showing for each movie (if the same movie exists on 2 theaters I want 2 distinct instances):
- x axis: time (discrete dates)
- y axis: number of sold out sessions
Aditionally, it would be useful to get another heatmap graph letting me know for each movie what times were the most sold out.
What would be a lightweight solution to go about this? I'm not familiar with data scraping tools or simple lightweight databases for this. I'm inexperienced in this line of work and looking to do the least coding possible. Excel would be fine for me. I've had past experience with Java and C# but would like to avoid killing a fly with a bazooka.
I'm currently thinking about doing this with ParseHub but not sure how to merge the information from 1 csv file per day to obtain the information I'm looking for.
PS: I found the JSON source that populates the web page so I could fetch that once per day, I just need to grab the important information from that file and structure it (in an Excel). Just don't know what tools I could use to accomplish such a task.