git clone [email protected]:pjlee11/browser-stats-percentage.gitcd browser-stats-percentagenpm install
The browser-stats.json data is frivolous as this is a public repo. For actual use cases we should retrieve the data from our analytics reports. These reports are often supplied as a .xlsx format.
We need to tidy the data so it is in the following format:
| Row Name 1 | Row Name 2 | Row Name 3 |
|---|---|---|
| data 1A | data 1B | data 1C |
| data 2A | data 2B | data 2C |
| data 3A | data 3B | data 3C |
| data 4A | data 4B | data 4C |
| data 5A | data 5B | data 5C |
This can then be saved/exported as a .csv format. See browser-stats-example.csv for a detailed example of the desired format.
Once the data is in a .csv format we can add it to our local copy of this repo saving it with the filename browser-stats.csv. Then we can run the command npm run csvtojson to convert the file into JSON.
Following this we can now run the commands to get browser and OS percentages per service.
This logs the percentage each browser makes up of the total viewership per service.
This logs the percentage each operating system makes up of the total viewership per service.
This logs the percentage each browser and operating system makes up of the total viewership per service.
This gives a breakdown of the browser verions that meet our support threshold for each service.
-
Rename
browser-stats-example.csvtobrowser-stats.csv -
npm run csvtojson -
npm run getBrowserPercentages -
Copy the console output and paste into a Github comment and preview the table.
It should look something like this:
| Service | Browser & Version | Percentage |
|---|---|---|
| news | Safari 12.x | 20.000 |
| news | Chrome for iOS 68.x | 50.000 |
| news | Facebook for iPhone 63.x | 30.000 |
| news-ws-yoruba | Chrome for iOS 68.x | 25.000 |
| news-ws-yoruba | Facebook for Android 73.x | 75.000 |
| news-ws-igbo | BlackBerry Browser 10.x | 41.667 |
| news-ws-igbo | Firefox 52.x | 58.333 |