My goal is counting the number of posts of every single day from Oct 04, 2018 to Jan 14 2019 for both mdayonliner and S_th... Zero post of a day will also be included.
So far I have done this....
- Converted the spreadsheet file to txt file
- Wrote few simple scripts
- Kept only the dates I do not need everything else
- Wrote few more scripts to read the files and added them to a mySQL database
- Some simple query gave me these data
mdayonliner: http://masudulkabir.com/MDAYnotS_TH/mdaywtzero.txt
S_th: http://masudulkabir.com/MDAYnotS_TH/S_thwtzero.txt
- Then I dumped the data to a google Spreadsheet and drew this two graph. https://docs.google.com/spreadsheets/d/1x6ysRhmNlwJDRFNrZfzq6AwpVsBd7eZPrsQjz2IveMk/edit?usp=sharing
Please see the mday_count and S_the_count tabs
But still it's not the output I am looking for. I need the days with no posts too.
So far I have done this....
- Converted the spreadsheet file to txt file
- Wrote few simple scripts
- Kept only the dates I do not need everything else
- Wrote few more scripts to read the files and added them to a mySQL database
- Some simple query gave me these data
mdayonliner: http://masudulkabir.com/MDAYnotS_TH/mdaywtzero.txt
S_th: http://masudulkabir.com/MDAYnotS_TH/S_thwtzero.txt
- Then I dumped the data to a google Spreadsheet and drew this two graph. https://docs.google.com/spreadsheets/d/1x6ysRhmNlwJDRFNrZfzq6AwpVsBd7eZPrsQjz2IveMk/edit?usp=sharing
Please see the mday_count and S_the_count tabs
But still it's not the output I am looking for. I need the days with no posts too.
Is this what are you looking for? Since I already have data for both of you I can easily make a comparison graph.
It looks like you were not at all active from 13-10-2018 to 06-12-2018? but S_Therapist was quite active during the same period... (Is it true or do I need to revisit my data?)
mdayonliner vs S_Therapist post counts from 04-10-2018 to 15-01-2019
https://imgur.com/KzaqOEm