This is my survey of Idly Dose Vada Coffee Prices across darshinis in Bangalore. Idea is to collect the data over time across Bangalore for fun and analysis.
Collection
It uses Kobo toolbox for collection and hence you need a free account for submission.
Multiple submissions are okay. Here is the web submission form that you can use both online and offline. If you have the KoboCollect app installed then you can download the form and use it. Here is the project page on Kobo.
Live Charts
Showing data from current year, 2023
Data
- Data is licensed under Open Data Commons Open Database License (ODbL)
- The data is available in JSON format and SQLite format.
Each document looks like this
{
"id": "20df46da-637a-47ae-8f57-de4ac38e30dc",
"key": "20df46da-637a-47ae-8f57-de4ac38e30dc",
"value":
{
"_id": "20df46da-637a-47ae-8f57-de4ac38e30dc",
"_rev": "3-b81deb73a91c71b5d4eea17b32d33a89",
"type": "data",
"name_of_restaurant": "Sagar Fast Food",
"idly_two": 30,
"masala_dosa": 50,
"vada": 30,
"regular_coffee": null,
"mini_coffee": 13,
"ac": "no",
"type_of_restaurant":
[
"standing_sitting_inside"
],
"lat": "12.9306728",
"lng": "77.6228462",
"submission_time": "2022-05-29T14:43:06.00+05:30",
"submitted_by": "thejeshgn"
}
}
Stats
current_stats
We generate stats every time we update the data. "current_stats" shows the current year's stats. The document looks like this.
{
"_id": "current_stats",
"_rev": "11-2069593d4e60d21fce4798b4c7df8b6a",
"type": "stat",
"last_updated_on": "2023-03-23T20:58:48.539125+05:30",
"idly_two":
{
"max": 80.0,
"min": 20.0,
"mean": 35.0,
"median": 30.0,
"mode": 30.0,
"sd": 16.83
},
"masala_dosa":
{
"max": 150.0,
"min": 50.0,
"mean": 70.5,
"median": 57.5,
"mode": 50.0,
"sd": 32.36
},
"vada":
{
"max": 53.0,
"min": 25.0,
"mean": 33.0,
"median": 30.0,
"mode": 25.0,
"sd": 10.39
},
"regular_coffee":
{
"max": 50.0,
"min": 10.0,
"mean": 19.0,
"median": 14.0,
"mode": 12.0,
"sd": 12.62
}
}
stats_2022
{
"_id": "stats_2022",
"_rev": "1-4f49fc483eaa0b8a00a46578433447fb",
"type": "stat",
"last_updated_on": "2022-12-31T23:56:51.111023+05:30",
"idly_two": {
"max": 76,
"min": 20,
"mean": 33.5,
"median": 30,
"mode": 30,
"sd": 12.18
},
"masala_dosa": {
"max": 113,
"min": 40,
"mean": 61.96,
"median": 55,
"mode": 50,
"sd": 20.17
},
"vada": {
"max": 56,
"min": 15,
"mean": 28.53,
"median": 25,
"mode": 25,
"sd": 8.78
},
"regular_coffee": {
"max": 41,
"min": 10,
"mean": 16.43,
"median": 15,
"mode": 15,
"sd": 7.67
}
}
Code
The code and data is on Github thejeshgn/idvc.