Skip to content

Instantly share code, notes, and snippets.

View nadinagray's full-sized avatar
🥑
wfw

Nadina Gray nadinagray

🥑
wfw
22 followers · 49 following
View GitHub Profile
@nadinagray
nadinagray / posts.csv
Created September 13, 2018 00:37
We can make this file beautiful and searchable if this error is corrected: Unclosed quoted field in line 4.
"Post date","Brand name","Brand profile image url","Post URL","Post image url","Message text","Comments","Likes","Shares","total comments value","Total likes value","Total shares value","Total views value","Engagement EMV"
"2018-07-15 17:43:00","Audi","","https://www.twitter.com/statuses/1018551518872686594","","@mchamberlain99 Can't blame you.","","","2","0.0","0.0","3.2978","0.0","3.2978"
"2018-07-15 19:47:07","Audi","","https://www.twitter.com/statuses/1018582752474460160","http://pbs.twimg.com/media/DiK6MEqV4AAFS9w.jpg","Stands out even in camo.
The #etron paid a visit stateside during the #NYCEprix. Learn more: https://t.co/j2pqCTS1lz https://t.co/H7vQgMThsg","","","96","0.0","0.0","158.2944","0.0","158.2944"
"2018-07-15 20:24:00","Audi","","https://www.facebook.com/96585976469/posts/10155420488556470","https://scontent.xx.fbcdn.net/v/t1.0-9/s720x720/37295083_10155420487511470_1481040431742451712_o.png?_nc_cat=0&oh=0b4fd0904e16ad41cc99dbce65aea1a7&oe=5BFC3C28","Stands out even in camo.
The #etron pai
@nadinagray
nadinagray / .block
Last active June 27, 2018 00:23
EMV with dots
license: gpl-3.0
@nadinagray
nadinagray / platformrefactor.json
Created June 26, 2018 21:41
[{"brand_id":20,"variable":"Total EMV","date":"2018-02-11T17:00:00.000","value":19.49,"name":"Vans - Facebook","platform_id":4},{"brand_id":20,"variable":"Average EMV","date":"2018-02-11T17:00:00.000","value":6.57,"name":"Vans - Facebook","platform_id":4},{"brand_id":20,"variable":"Total EMV","date":"2018-02-11T18:00:00.000","value":20.23,"name":"Vans - Facebook","platform_id":4},{"brand_id":20,"variable":"Average EMV","date":"2018-02-11T18:00:00.000","value":6.15,"name":"Vans - Facebook","platform_id":4},{"brand_id":20,"variable":"Total EMV","date":"2018-02-11T19:00:00.000","value":19.66,"name":"Vans - Facebook","platform_id":4},{"brand_id":20,"variable":"Average EMV","date":"2018-02-11T19:00:00.000","value":4.72,"name":"Vans - Facebook","platform_id":4},{"brand_id":20,"variable":"Total EMV","date":"2018-02-11T20:00:00.000","value":17.38,"name":"Vans - Facebook","platform_id":4},{"brand_id":20,"variable":"Average EMV","date":"2018-02-11T20:00:00.000","value":5.25,"name":"Vans - Facebook","platform_id":4},{"b
@nadinagray
nadinagray / platform.json
Last active June 26, 2018 21:17
[ { "brand_id": 21, "variable": "Total EMV", "date": "2018-02-11T17:00:00.000", "value": 13.87, "name": "Converse", "platform_id": 6, "post_id": "23402039579_10155847888699580", "post_url": "https://www.facebook.com/23402039579/posts/10155847888699580", "message_text": "They are real and they are coming soon. Find out more: https://bit.ly/2KtWwlU.", "comments": 114, "likes": 1409, "shares": 98, "tot_likes_value": 225.44, "tot_comments_value": 291.84, "tot_shares_value": 152.88, "total_emv_value": 13.87, "total_average_value": 13.87 }, { "brand_id": 21, "variable": "Average EMV", "date": "2018-02-11T17:00:00.000", "value": 2.35, "name": "Converse", "platform_id": 6, "post_id": "23402039579_10155867499509580", "post_url": "https://www.facebook.com/23402039579/posts/10155867499509580", "message_text": "Your summer staple is here. Shop Chuck 70: https://swoo.sh/2rvTrdk", "comments": 27, "likes": 1554, "shares": 53, "tot_likes_value": 248.64, "tot_comments_value": 69.12, "tot_shares_value": 82.68, "total_emv_value
@nadinagray
nadinagray / data_thirty.json
Created June 26, 2018 20:30
[
{
"date": "2018-05-01T00:00:00.00",
"name": "Converse",
"social_id": 4,
"brand_id": 13,
"post_id": "23402039579_10155847888699580",
"post_url": "https://www.facebook.com/23402039579/posts/10155847888699580",
"message_text": "They are real and they are coming soon. Find out more: https://bit.ly/2KtWwlU.",
"comments": 114,
@nadinagray
nadinagray / .block
Last active June 27, 2018 19:06
Social Values with Data Points
license: gpl-3.0
@nadinagray
nadinagray / data_social.json
Created June 26, 2018 19:19
[{"station_id":20,"variable":"Total EMV","date":"2018-02-11T17:00:00.000","value":19.49,"name":"Vans - Facebook","region_id":4},{"station_id":20,"variable":"Average EMV","date":"2018-02-11T17:00:00.000","value":6.57,"name":"Vans - Facebook","region_id":4},{"station_id":20,"variable":"Total EMV","date":"2018-02-11T18:00:00.000","value":20.23,"name":"Vans - Facebook","region_id":4},{"station_id":20,"variable":"Average EMV","date":"2018-02-11T18:00:00.000","value":6.15,"name":"Vans - Facebook","region_id":4},{"station_id":20,"variable":"Total EMV","date":"2018-02-11T19:00:00.000","value":19.66,"name":"Vans - Facebook","region_id":4},{"station_id":20,"variable":"Average EMV","date":"2018-02-11T19:00:00.000","value":4.72,"name":"Vans - Facebook","region_id":4},{"station_id":20,"variable":"Total EMV","date":"2018-02-11T20:00:00.000","value":17.38,"name":"Vans - Facebook","region_id":4},{"station_id":20,"variable":"Average EMV","date":"2018-02-11T20:00:00.000","value":5.25,"name":"Vans - Facebook","region_id":4},{"s
@nadinagray
nadinagray / data_new.json
Created June 26, 2018 18:58
data_new.json
[{"station_id":20,"variable":"MUFD","date":"2018-02-11T17:00:00.000","value":19.49,"name":"Vans","region_id":4},
{"station_id":20,"variable":"TEC","date":"2018-02-11T17:00:00.000","value":6.57,"name":"Vans","region_id":4},
{"station_id":20,"variable":"MUFD","date":"2018-02-11T18:00:00.000","value":20.23,"name":"Vans","region_id":4},{"station_id":20,"variable":"TEC","date":"2018-02-11T18:00:00.000","value":6.15,"name":"Vans","region_id":4},
{"station_id":20,"variable":"MUFD","date":"2018-02-11T19:00:00.000","value":19.66,"name":"Vans","region_id":4},{"station_id":20,"variable":"TEC","date":"2018-02-11T19:00:00.000","value":4.72,"name":"Vans","region_id":4},{"station_id":20,"variable":"MUFD","date":"2018-02-11T20:00:00.000","value":17.38,"name":"Vans","region_id":4},{"station_id":20,"variable":"TEC","date":"2018-02-11T20:00:00.000","value":5.25,"name":"Vans","region_id":4},{"station_id":20,"variable":"MUFD","date":"2018-02-11T21:00:00.000","value":17.98,"name":"Vans","region_id":4},{"station_id":20,"variable":"
@nadinagray
nadinagray / gist:ce00525656e044abbbad3f1a51f1d132
Created June 26, 2018 18:57
data_new.json
[{"station_id":20,"variable":"MUFD","date":"2018-02-11T17:00:00.000","value":19.49,"name":"Vans","region_id":4}{"station_id":20,"variable":"TEC","date":"2018-02-11T17:00:00.000","value":6.57,"name":"Vans","region_id":4}{"station_id":20,"variable":"MUFD","date":"2018-02-11T18:00:00.000","value":20.23,"name":"Vans","region_id":4},{"station_id":20,"variable":"TEC","date":"2018-02-11T18:00:00.000","value":6.15,"name":"Vans","region_id":4},{"station_id":20,"variable":"MUFD","date":"2018-02-11T19:00:00.000","value":19.66,"name":"Vans","region_id":4},{"station_id":20,"variable":"TEC","date":"2018-02-11T19:00:00.000","value":4.72,"name":"Vans","region_id":4},{"station_id":20,"variable":"MUFD","date":"2018-02-11T20:00:00.000","value":17.38,"name":"Vans","region_id":4},{"station_id":20,"variable":"TEC","date":"2018-02-11T20:00:00.000","value":5.25,"name":"Vans","region_id":4},{"station_id":20,"variable":"MUFD","date":"2018-02-11T21:00:00.000","value":17.98,"name":"Vans","region_id":4},{"station_id":20,"variable":"MUFD"
@nadinagray
nadinagray / data_small.json
Last active June 26, 2018 18:56
[
{"station_id":20,"variable":"MUFD","date":"2018-02-11T17:00:00.000","value":19.49,"name":"Vans","region_id":4},
{"station_id":20,"variable":"TEC","date":"2018-02-11T17:00:00.000","value":6.57,"name":"Vans","region_id":4},
{"station_id":20,"variable":"MUFD","date":"2018-02-11T18:00:00.000","value":20.23,"name":"Vans","region_id":4},
{"station_id":20,"variable":"TEC","date":"2018-02-11T18:00:00.000","value":6.15,"name":"Vans","region_id":4},
{"station_id":20,"variable":"MUFD","date":"2018-02-11T19:00:00.000","value":19.66,"name":"Vans","region_id":4},
{"station_id":20,"variable":"TEC","date":"2018-02-11T19:00:00.000","value":4.72,"name":"Vans","region_id":4},
{"station_id":20,"variable":"MUFD","date":"2018-02-11T20:00:00.000","value":17.38,"name":"Vans","region_id":4},
{"station_id":20,"variable":"TEC","date":"2018-02-11T20:00:00.000","value":5.25,"name":"Vans","region_id":4},
{"station_id":20,"variable":"MUFD","date":"2018-02-11T21:00:00.000","value":17.98,"name":"Vans","region_id":4},{"sta