{"action":"created","issue":{"url":"https://api.github.com/repos/jsoma/data-studio-projects/issues/168","repository_url":"https://api.github.com/repos/jsoma/data-studio-projects","labels_url":"https://api.github.com/repos/jsoma/data-studio-projects/issues/168/labels{/name}","comments_url":"https://api.github.com/repos/jsoma/data-studio-projects/issues/168/comments","events_url":"https://api.github.com/repos/jsoma/data-studio-projects/issues/168/events","html_url":"https://github.com/jsoma/data-studio-projects/issues/168","id":341766097,"node_id":"MDU6SXNzdWUzNDE3NjYwOTc=","number":168,"title":" [PROJECT] What do we like to eat!? - Germany edition","user":{"login":"jlstro","id":3785873,"node_id":"MDQ6VXNlcjM3ODU4NzM=","avatar_url":"https://avatars0.githubusercontent.com/u/3785873?v=4","gravatar_id":"","url":"https://api.github.com/users/jlstro","html_url":"https://github.com/jlstro","followers_url":"https://api.github.com/users/jlstro/followers","following_url":"https://api.github.com/users/jlstro/following{/other_user}","gists_url":"https://api.github.com/users/jlstro/gists{/gist_id}","starred_url":"https://api.github.com/users/jlstro/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jlstro/subscriptions","organizations_url":"https://api.github.com/users/jlstro/orgs","repos_url":"https://api.github.com/users/jlstro/repos","events_url":"https://api.github.com/users/jlstro/events{/privacy}","received_events_url":"https://api.github.com/users/jlstro/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":6,"created_at":"2018-07-17T04:58:37Z","updated_at":"2018-07-26T18:21:35Z","closed_at":null,"author_association":"NONE","body":"Please complete all of the following sections, or the ghost of Joseph Pulitzer will spookily dance around your issue! A completed version of this template can be found at https://github.com/jsoma/data-studio-projects/issues/1\r\n\r\n# Pitch\r\nPeople eat stuff - let the data show what they think is good food!\r\n## Summary\r\n(There are screenshots below)\r\nI scraped som 70.000 recipes from chefkoch.de, Germany's biggest (and somtimes most horrible, if it comes to taste) platform for recipes. Think of a facebook for house ladies and gentlemen who chat, share their newest creation and talk about what their family hates for dinner.\r\n## Details\r\nThe data set includes the name, the ingredients (with amounts), a community rating and the number of votes. \r\n**Possible headline(s):** \r\nButter makes everything better and here's the data to proof that\r\n**Data set(s):** \r\nSee above, it is from [chefkoch](https://www.chefkoch.de/)'s _random recipe_ section\r\n**Code repository:**  \r\nwill show up on Github eventually\r\n**Possible problems/fears/questions:** \r\nThe ingredients part is hard - what do I focus on? Shall I randomly pick some and plot them? Can I find a way to correlate rating and ingredients? Will we be able to create the **perfect recipe** with the help of a computer?\r\n## Work so far\r\nI cleaned the data, dropped empty and messed up lines and did some very basic analysis: What are the best rated, what the worst rated dishes? Which got the highest number of votes? How many of them include Milk, Butter, Salt, Sugar..?\r\n![grafik](https://user-images.githubusercontent.com/3785873/42796388-d814d5ae-8957-11e8-823d-7b761e1838b4.png)\r\n\r\n![grafik](https://user-images.githubusercontent.com/3785873/42796685-8b103c60-8959-11e8-8046-b26bc47895cb.png)\r\n\r\n![grafik](https://user-images.githubusercontent.com/3785873/42797087-8460a22c-895b-11e8-84a8-d491fbcce857.png)\r\n\r\n## Checklist\r\n\r\nThis checklist must be completed before you submit your draft.\r\n\r\n- [x] I have already spent time with my data set, opening it, exploring it, etc\r\n- [ ] I have created a \"DIARY.md\" file to save links and list all of the terrible, no good problems I come across\r\n- [x] My issue links to my data set(s)\r\n- [x] My issue links to my code repository\r\n- [x] My issue explains what I'd like to explore in the data set\r\n- [x] My issue includes images - either inspiration or what I've done so far"},"comment":{"url":"https://api.github.com/repos/jsoma/data-studio-projects/issues/comments/408189480","html_url":"https://github.com/jsoma/data-studio-projects/issues/168#issuecomment-408189480","issue_url":"https://api.github.com/repos/jsoma/data-studio-projects/issues/168","id":408189480,"node_id":"MDEyOklzc3VlQ29tbWVudDQwODE4OTQ4MA==","user":{"login":"collleenwang","id":39416429,"node_id":"MDQ6VXNlcjM5NDE2NDI5","avatar_url":"https://avatars2.githubusercontent.com/u/39416429?v=4","gravatar_id":"","url":"https://api.github.com/users/collleenwang","html_url":"https://github.com/collleenwang","followers_url":"https://api.github.com/users/collleenwang/followers","following_url":"https://api.github.com/users/collleenwang/following{/other_user}","gists_url":"https://api.github.com/users/collleenwang/gists{/gist_id}","starred_url":"https://api.github.com/users/collleenwang/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/collleenwang/subscriptions","organizations_url":"https://api.github.com/users/collleenwang/orgs","repos_url":"https://api.github.com/users/collleenwang/repos","events_url":"https://api.github.com/users/collleenwang/events{/privacy}","received_events_url":"https://api.github.com/users/collleenwang/received_events","type":"User","site_admin":false},"created_at":"2018-07-26T18:21:35Z","updated_at":"2018-07-26T18:21:35Z","author_association":"NONE","body":"I like the topic! The last name one is better than the chart! If a designer can draw those delicious food, it will be perfect! But now, I think the practical way to improve it is the color part. Umm, food topic is a relaxed one, right? Why don't use brighter colors? "}}
{"actor":{"display_login":"collleenwang"}}