github
html_url | issue_url | id | node_id | user | created_at | updated_at | author_association | body | reactions | issue | performed_via_github_app |
---|---|---|---|---|---|---|---|---|---|---|---|
https://github.com/simonw/sqlite-utils/issues/456#issuecomment-1190449764 | https://api.github.com/repos/simonw/sqlite-utils/issues/456 | 1190449764 | IC_kwDOCGYnMM5G9NJk | 45919695 | 2022-07-20T15:45:54Z | 2022-07-20T15:45:54Z | NONE | > hadley wickham's melt and reshape could be good inspo: http://had.co.nz/reshape/introduction.pdf Note that Hadley has since implemented `pivot_longer` and `pivot_wider` instead of the previous verbs/functions that he used. Those can be found in the tidyr package and are probably the best reference which includes all of the learnings from years of user feedback. https://tidyr.tidyverse.org/articles/pivot.html | {"total_count": 2, "+1": 2, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} | 1310243385 | |
https://github.com/simonw/sqlite-utils/pull/455#issuecomment-1190686273 | https://api.github.com/repos/simonw/sqlite-utils/issues/455 | 1190686273 | IC_kwDOCGYnMM5G-G5B | 9599 | 2022-07-20T19:46:15Z | 2022-07-20T19:46:15Z | OWNER | Can you add a new test for this? Something derived from the example in #423 would work great. | {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} | 1309542173 | |
https://github.com/simonw/sqlite-utils/issues/456#issuecomment-1189698289 | https://api.github.com/repos/simonw/sqlite-utils/issues/456 | 1189698289 | IC_kwDOCGYnMM5G6Vrx | 9599 | 2022-07-20T01:13:47Z | 2022-07-20T01:13:47Z | OWNER | Really interesting idea! Can you flesh out what this might look like, maybe with a before and after example schema? | {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} | 1310243385 | |
https://github.com/simonw/sqlite-utils/issues/456#issuecomment-1190578687 | https://api.github.com/repos/simonw/sqlite-utils/issues/456 | 1190578687 | IC_kwDOCGYnMM5G9sn_ | 9599 | 2022-07-20T17:50:50Z | 2022-07-20T17:50:50Z | OWNER | Wow https://tidyr.tidyverse.org/articles/pivot.html is _fascinating_. | {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} | 1310243385 | |
https://github.com/simonw/sqlite-utils/issues/456#issuecomment-1190272780 | https://api.github.com/repos/simonw/sqlite-utils/issues/456 | 1190272780 | IC_kwDOCGYnMM5G8h8M | 536941 | 2022-07-20T13:14:54Z | 2022-07-20T13:14:54Z | CONTRIBUTOR | for example, i have data on votes that look like this: | ballot_id | option_id | choice | |-|-|-| | 1 | 1 | 0 | | 1 | 2 | 1 | | 1 | 3 | 0 | | 1 | 4 | 1 | | 2 | 1 | 1 | | 2 | 2 | 0 | | 2 | 3 | 1 | | 2 | 4 | 0 | and i want to reshape from this long form to this wide form: | ballot_id | option_id_1 | option_id_2 | option_id_3 | option_id_ 4| |-|-|-|-| -| | 1 | 0 | 1 | 0 | 1 | | 2 | 1 | 0 | 1| 0 | i could do such a think like this. ```sql select ballot_id, sum(choice) filter (where option_id = 1) as option_id_1, sum(choice) filter (where option_id = 2) as option_id_2, sum(choice) filter (where option_id = 3) as option_id_3, sum(choice) filter (where option_id = 4) as option_id_4 from vote group by ballot_id ``` | {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} | 1310243385 | |
https://github.com/simonw/sqlite-utils/issues/456#issuecomment-1190277829 | https://api.github.com/repos/simonw/sqlite-utils/issues/456 | 1190277829 | IC_kwDOCGYnMM5G8jLF | 536941 | 2022-07-20T13:19:15Z | 2022-07-20T13:19:15Z | CONTRIBUTOR | hadley wickham's melt and reshape could be good inspo: http://had.co.nz/reshape/introduction.pdf | {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} | 1310243385 |