{ "cells": [ { "cell_type": "markdown", "metadata": { "extensions": { "jupyter_dashboards": { "version": 1, "views": { "grid_default": { "col": 0, "height": 4, "hidden": false, "row": 0, "width": 4 }, "report_default": { "hidden": false } } } } }, "source": [ "# Project: Wrangling and Analysis of 'WeRateDogs' tweet archive data" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "## Table of contents\n", "\n", "
\n", " | tweet_id | \n", "in_reply_to_status_id | \n", "in_reply_to_user_id | \n", "timestamp | \n", "source | \n", "text | \n", "retweeted_status_id | \n", "retweeted_status_user_id | \n", "retweeted_status_timestamp | \n", "expanded_urls | \n", "rating_numerator | \n", "rating_denominator | \n", "name | \n", "doggo | \n", "floofer | \n", "pupper | \n", "puppo | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0 | \n", "892420643555336193 | \n", "NaN | \n", "NaN | \n", "2017-08-01 16:23:56 +0000 | \n", "<a href=\"http://twitter.com/download/iphone\" r... | \n", "This is Phineas. He's a mystical boy. Only eve... | \n", "NaN | \n", "NaN | \n", "NaN | \n", "https://twitter.com/dog_rates/status/892420643... | \n", "13 | \n", "10 | \n", "Phineas | \n", "None | \n", "None | \n", "None | \n", "None | \n", "
1 | \n", "892177421306343426 | \n", "NaN | \n", "NaN | \n", "2017-08-01 00:17:27 +0000 | \n", "<a href=\"http://twitter.com/download/iphone\" r... | \n", "This is Tilly. She's just checking pup on you.... | \n", "NaN | \n", "NaN | \n", "NaN | \n", "https://twitter.com/dog_rates/status/892177421... | \n", "13 | \n", "10 | \n", "Tilly | \n", "None | \n", "None | \n", "None | \n", "None | \n", "
2 | \n", "891815181378084864 | \n", "NaN | \n", "NaN | \n", "2017-07-31 00:18:03 +0000 | \n", "<a href=\"http://twitter.com/download/iphone\" r... | \n", "This is Archie. He is a rare Norwegian Pouncin... | \n", "NaN | \n", "NaN | \n", "NaN | \n", "https://twitter.com/dog_rates/status/891815181... | \n", "12 | \n", "10 | \n", "Archie | \n", "None | \n", "None | \n", "None | \n", "None | \n", "
\n", " | tweet_id | \n", "jpg_url | \n", "img_num | \n", "p1 | \n", "p1_conf | \n", "p1_dog | \n", "p2 | \n", "p2_conf | \n", "p2_dog | \n", "p3 | \n", "p3_conf | \n", "p3_dog | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|
0 | \n", "666020888022790149 | \n", "https://pbs.twimg.com/media/CT4udn0WwAA0aMy.jpg | \n", "1 | \n", "Welsh_springer_spaniel | \n", "0.465074 | \n", "True | \n", "collie | \n", "0.156665 | \n", "True | \n", "Shetland_sheepdog | \n", "0.061428 | \n", "True | \n", "
1 | \n", "666029285002620928 | \n", "https://pbs.twimg.com/media/CT42GRgUYAA5iDo.jpg | \n", "1 | \n", "redbone | \n", "0.506826 | \n", "True | \n", "miniature_pinscher | \n", "0.074192 | \n", "True | \n", "Rhodesian_ridgeback | \n", "0.072010 | \n", "True | \n", "
2 | \n", "666033412701032449 | \n", "https://pbs.twimg.com/media/CT4521TWwAEvMyu.jpg | \n", "1 | \n", "German_shepherd | \n", "0.596461 | \n", "True | \n", "malinois | \n", "0.138584 | \n", "True | \n", "bloodhound | \n", "0.116197 | \n", "True | \n", "
\n", " | tweet_id | \n", "retweet_count | \n", "favorite_count | \n", "
---|---|---|---|
0 | \n", "892420643555336193 | \n", "6979 | \n", "33728 | \n", "
1 | \n", "892177421306343426 | \n", "5280 | \n", "29255 | \n", "
2 | \n", "891815181378084864 | \n", "3466 | \n", "21987 | \n", "
3 | \n", "891689557279858688 | \n", "7198 | \n", "36823 | \n", "
4 | \n", "891327558926688256 | \n", "7723 | \n", "35207 | \n", "
\n", " | tweet_id | \n", "in_reply_to_status_id | \n", "in_reply_to_user_id | \n", "timestamp | \n", "source | \n", "text | \n", "retweeted_status_id | \n", "retweeted_status_user_id | \n", "retweeted_status_timestamp | \n", "expanded_urls | \n", "rating_numerator | \n", "rating_denominator | \n", "name | \n", "doggo | \n", "floofer | \n", "pupper | \n", "puppo | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0 | \n", "892420643555336193 | \n", "NaN | \n", "NaN | \n", "2017-08-01 16:23:56 +0000 | \n", "<a href=\"http://twitter.com/download/iphone\" r... | \n", "This is Phineas. He's a mystical boy. Only eve... | \n", "NaN | \n", "NaN | \n", "NaN | \n", "https://twitter.com/dog_rates/status/892420643... | \n", "13 | \n", "10 | \n", "Phineas | \n", "None | \n", "None | \n", "None | \n", "None | \n", "
1 | \n", "892177421306343426 | \n", "NaN | \n", "NaN | \n", "2017-08-01 00:17:27 +0000 | \n", "<a href=\"http://twitter.com/download/iphone\" r... | \n", "This is Tilly. She's just checking pup on you.... | \n", "NaN | \n", "NaN | \n", "NaN | \n", "https://twitter.com/dog_rates/status/892177421... | \n", "13 | \n", "10 | \n", "Tilly | \n", "None | \n", "None | \n", "None | \n", "None | \n", "
2 | \n", "891815181378084864 | \n", "NaN | \n", "NaN | \n", "2017-07-31 00:18:03 +0000 | \n", "<a href=\"http://twitter.com/download/iphone\" r... | \n", "This is Archie. He is a rare Norwegian Pouncin... | \n", "NaN | \n", "NaN | \n", "NaN | \n", "https://twitter.com/dog_rates/status/891815181... | \n", "12 | \n", "10 | \n", "Archie | \n", "None | \n", "None | \n", "None | \n", "None | \n", "
3 | \n", "891689557279858688 | \n", "NaN | \n", "NaN | \n", "2017-07-30 15:58:51 +0000 | \n", "<a href=\"http://twitter.com/download/iphone\" r... | \n", "This is Darla. She commenced a snooze mid meal... | \n", "NaN | \n", "NaN | \n", "NaN | \n", "https://twitter.com/dog_rates/status/891689557... | \n", "13 | \n", "10 | \n", "Darla | \n", "None | \n", "None | \n", "None | \n", "None | \n", "
4 | \n", "891327558926688256 | \n", "NaN | \n", "NaN | \n", "2017-07-29 16:00:24 +0000 | \n", "<a href=\"http://twitter.com/download/iphone\" r... | \n", "This is Franklin. He would like you to stop ca... | \n", "NaN | \n", "NaN | \n", "NaN | \n", "https://twitter.com/dog_rates/status/891327558... | \n", "12 | \n", "10 | \n", "Franklin | \n", "None | \n", "None | \n", "None | \n", "None | \n", "
5 | \n", "891087950875897856 | \n", "NaN | \n", "NaN | \n", "2017-07-29 00:08:17 +0000 | \n", "<a href=\"http://twitter.com/download/iphone\" r... | \n", "Here we have a majestic great white breaching ... | \n", "NaN | \n", "NaN | \n", "NaN | \n", "https://twitter.com/dog_rates/status/891087950... | \n", "13 | \n", "10 | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "
6 | \n", "890971913173991426 | \n", "NaN | \n", "NaN | \n", "2017-07-28 16:27:12 +0000 | \n", "<a href=\"http://twitter.com/download/iphone\" r... | \n", "Meet Jax. He enjoys ice cream so much he gets ... | \n", "NaN | \n", "NaN | \n", "NaN | \n", "https://gofundme.com/ydvmve-surgery-for-jax,ht... | \n", "13 | \n", "10 | \n", "Jax | \n", "None | \n", "None | \n", "None | \n", "None | \n", "
7 | \n", "890729181411237888 | \n", "NaN | \n", "NaN | \n", "2017-07-28 00:22:40 +0000 | \n", "<a href=\"http://twitter.com/download/iphone\" r... | \n", "When you watch your owner call another dog a g... | \n", "NaN | \n", "NaN | \n", "NaN | \n", "https://twitter.com/dog_rates/status/890729181... | \n", "13 | \n", "10 | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "
8 | \n", "890609185150312448 | \n", "NaN | \n", "NaN | \n", "2017-07-27 16:25:51 +0000 | \n", "<a href=\"http://twitter.com/download/iphone\" r... | \n", "This is Zoey. She doesn't want to be one of th... | \n", "NaN | \n", "NaN | \n", "NaN | \n", "https://twitter.com/dog_rates/status/890609185... | \n", "13 | \n", "10 | \n", "Zoey | \n", "None | \n", "None | \n", "None | \n", "None | \n", "
9 | \n", "890240255349198849 | \n", "NaN | \n", "NaN | \n", "2017-07-26 15:59:51 +0000 | \n", "<a href=\"http://twitter.com/download/iphone\" r... | \n", "This is Cassie. She is a college pup. Studying... | \n", "NaN | \n", "NaN | \n", "NaN | \n", "https://twitter.com/dog_rates/status/890240255... | \n", "14 | \n", "10 | \n", "Cassie | \n", "doggo | \n", "None | \n", "None | \n", "None | \n", "
10 | \n", "890006608113172480 | \n", "NaN | \n", "NaN | \n", "2017-07-26 00:31:25 +0000 | \n", "<a href=\"http://twitter.com/download/iphone\" r... | \n", "This is Koda. He is a South Australian decksha... | \n", "NaN | \n", "NaN | \n", "NaN | \n", "https://twitter.com/dog_rates/status/890006608... | \n", "13 | \n", "10 | \n", "Koda | \n", "None | \n", "None | \n", "None | \n", "None | \n", "
11 | \n", "889880896479866881 | \n", "NaN | \n", "NaN | \n", "2017-07-25 16:11:53 +0000 | \n", "<a href=\"http://twitter.com/download/iphone\" r... | \n", "This is Bruno. He is a service shark. Only get... | \n", "NaN | \n", "NaN | \n", "NaN | \n", "https://twitter.com/dog_rates/status/889880896... | \n", "13 | \n", "10 | \n", "Bruno | \n", "None | \n", "None | \n", "None | \n", "None | \n", "
12 | \n", "889665388333682689 | \n", "NaN | \n", "NaN | \n", "2017-07-25 01:55:32 +0000 | \n", "<a href=\"http://twitter.com/download/iphone\" r... | \n", "Here's a puppo that seems to be on the fence a... | \n", "NaN | \n", "NaN | \n", "NaN | \n", "https://twitter.com/dog_rates/status/889665388... | \n", "13 | \n", "10 | \n", "None | \n", "None | \n", "None | \n", "None | \n", "puppo | \n", "
13 | \n", "889638837579907072 | \n", "NaN | \n", "NaN | \n", "2017-07-25 00:10:02 +0000 | \n", "<a href=\"http://twitter.com/download/iphone\" r... | \n", "This is Ted. He does his best. Sometimes that'... | \n", "NaN | \n", "NaN | \n", "NaN | \n", "https://twitter.com/dog_rates/status/889638837... | \n", "12 | \n", "10 | \n", "Ted | \n", "None | \n", "None | \n", "None | \n", "None | \n", "
14 | \n", "889531135344209921 | \n", "NaN | \n", "NaN | \n", "2017-07-24 17:02:04 +0000 | \n", "<a href=\"http://twitter.com/download/iphone\" r... | \n", "This is Stuart. He's sporting his favorite fan... | \n", "NaN | \n", "NaN | \n", "NaN | \n", "https://twitter.com/dog_rates/status/889531135... | \n", "13 | \n", "10 | \n", "Stuart | \n", "None | \n", "None | \n", "None | \n", "puppo | \n", "
15 | \n", "889278841981685760 | \n", "NaN | \n", "NaN | \n", "2017-07-24 00:19:32 +0000 | \n", "<a href=\"http://twitter.com/download/iphone\" r... | \n", "This is Oliver. You're witnessing one of his m... | \n", "NaN | \n", "NaN | \n", "NaN | \n", "https://twitter.com/dog_rates/status/889278841... | \n", "13 | \n", "10 | \n", "Oliver | \n", "None | \n", "None | \n", "None | \n", "None | \n", "
16 | \n", "888917238123831296 | \n", "NaN | \n", "NaN | \n", "2017-07-23 00:22:39 +0000 | \n", "<a href=\"http://twitter.com/download/iphone\" r... | \n", "This is Jim. He found a fren. Taught him how t... | \n", "NaN | \n", "NaN | \n", "NaN | \n", "https://twitter.com/dog_rates/status/888917238... | \n", "12 | \n", "10 | \n", "Jim | \n", "None | \n", "None | \n", "None | \n", "None | \n", "
17 | \n", "888804989199671297 | \n", "NaN | \n", "NaN | \n", "2017-07-22 16:56:37 +0000 | \n", "<a href=\"http://twitter.com/download/iphone\" r... | \n", "This is Zeke. He has a new stick. Very proud o... | \n", "NaN | \n", "NaN | \n", "NaN | \n", "https://twitter.com/dog_rates/status/888804989... | \n", "13 | \n", "10 | \n", "Zeke | \n", "None | \n", "None | \n", "None | \n", "None | \n", "
18 | \n", "888554962724278272 | \n", "NaN | \n", "NaN | \n", "2017-07-22 00:23:06 +0000 | \n", "<a href=\"http://twitter.com/download/iphone\" r... | \n", "This is Ralphus. He's powering up. Attempting ... | \n", "NaN | \n", "NaN | \n", "NaN | \n", "https://twitter.com/dog_rates/status/888554962... | \n", "13 | \n", "10 | \n", "Ralphus | \n", "None | \n", "None | \n", "None | \n", "None | \n", "
19 | \n", "888202515573088257 | \n", "NaN | \n", "NaN | \n", "2017-07-21 01:02:36 +0000 | \n", "<a href=\"http://twitter.com/download/iphone\" r... | \n", "RT @dog_rates: This is Canela. She attempted s... | \n", "8.874740e+17 | \n", "4.196984e+09 | \n", "2017-07-19 00:47:34 +0000 | \n", "https://twitter.com/dog_rates/status/887473957... | \n", "13 | \n", "10 | \n", "Canela | \n", "None | \n", "None | \n", "None | \n", "None | \n", "
20 | \n", "888078434458587136 | \n", "NaN | \n", "NaN | \n", "2017-07-20 16:49:33 +0000 | \n", "<a href=\"http://twitter.com/download/iphone\" r... | \n", "This is Gerald. He was just told he didn't get... | \n", "NaN | \n", "NaN | \n", "NaN | \n", "https://twitter.com/dog_rates/status/888078434... | \n", "12 | \n", "10 | \n", "Gerald | \n", "None | \n", "None | \n", "None | \n", "None | \n", "
21 | \n", "887705289381826560 | \n", "NaN | \n", "NaN | \n", "2017-07-19 16:06:48 +0000 | \n", "<a href=\"http://twitter.com/download/iphone\" r... | \n", "This is Jeffrey. He has a monopoly on the pool... | \n", "NaN | \n", "NaN | \n", "NaN | \n", "https://twitter.com/dog_rates/status/887705289... | \n", "13 | \n", "10 | \n", "Jeffrey | \n", "None | \n", "None | \n", "None | \n", "None | \n", "
22 | \n", "887517139158093824 | \n", "NaN | \n", "NaN | \n", "2017-07-19 03:39:09 +0000 | \n", "<a href=\"http://twitter.com/download/iphone\" r... | \n", "I've yet to rate a Venezuelan Hover Wiener. Th... | \n", "NaN | \n", "NaN | \n", "NaN | \n", "https://twitter.com/dog_rates/status/887517139... | \n", "14 | \n", "10 | \n", "such | \n", "None | \n", "None | \n", "None | \n", "None | \n", "
23 | \n", "887473957103951883 | \n", "NaN | \n", "NaN | \n", "2017-07-19 00:47:34 +0000 | \n", "<a href=\"http://twitter.com/download/iphone\" r... | \n", "This is Canela. She attempted some fancy porch... | \n", "NaN | \n", "NaN | \n", "NaN | \n", "https://twitter.com/dog_rates/status/887473957... | \n", "13 | \n", "10 | \n", "Canela | \n", "None | \n", "None | \n", "None | \n", "None | \n", "
24 | \n", "887343217045368832 | \n", "NaN | \n", "NaN | \n", "2017-07-18 16:08:03 +0000 | \n", "<a href=\"http://twitter.com/download/iphone\" r... | \n", "You may not have known you needed to see this ... | \n", "NaN | \n", "NaN | \n", "NaN | \n", "https://twitter.com/dog_rates/status/887343217... | \n", "13 | \n", "10 | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "
25 | \n", "887101392804085760 | \n", "NaN | \n", "NaN | \n", "2017-07-18 00:07:08 +0000 | \n", "<a href=\"http://twitter.com/download/iphone\" r... | \n", "This... is a Jubilant Antarctic House Bear. We... | \n", "NaN | \n", "NaN | \n", "NaN | \n", "https://twitter.com/dog_rates/status/887101392... | \n", "12 | \n", "10 | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "
26 | \n", "886983233522544640 | \n", "NaN | \n", "NaN | \n", "2017-07-17 16:17:36 +0000 | \n", "<a href=\"http://twitter.com/download/iphone\" r... | \n", "This is Maya. She's very shy. Rarely leaves he... | \n", "NaN | \n", "NaN | \n", "NaN | \n", "https://twitter.com/dog_rates/status/886983233... | \n", "13 | \n", "10 | \n", "Maya | \n", "None | \n", "None | \n", "None | \n", "None | \n", "
27 | \n", "886736880519319552 | \n", "NaN | \n", "NaN | \n", "2017-07-16 23:58:41 +0000 | \n", "<a href=\"http://twitter.com/download/iphone\" r... | \n", "This is Mingus. He's a wonderful father to his... | \n", "NaN | \n", "NaN | \n", "NaN | \n", "https://www.gofundme.com/mingusneedsus,https:/... | \n", "13 | \n", "10 | \n", "Mingus | \n", "None | \n", "None | \n", "None | \n", "None | \n", "
28 | \n", "886680336477933568 | \n", "NaN | \n", "NaN | \n", "2017-07-16 20:14:00 +0000 | \n", "<a href=\"http://twitter.com/download/iphone\" r... | \n", "This is Derek. He's late for a dog meeting. 13... | \n", "NaN | \n", "NaN | \n", "NaN | \n", "https://twitter.com/dog_rates/status/886680336... | \n", "13 | \n", "10 | \n", "Derek | \n", "None | \n", "None | \n", "None | \n", "None | \n", "
29 | \n", "886366144734445568 | \n", "NaN | \n", "NaN | \n", "2017-07-15 23:25:31 +0000 | \n", "<a href=\"http://twitter.com/download/iphone\" r... | \n", "This is Roscoe. Another pupper fallen victim t... | \n", "NaN | \n", "NaN | \n", "NaN | \n", "https://twitter.com/dog_rates/status/886366144... | \n", "12 | \n", "10 | \n", "Roscoe | \n", "None | \n", "None | \n", "pupper | \n", "None | \n", "
... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "
2326 | \n", "666411507551481857 | \n", "NaN | \n", "NaN | \n", "2015-11-17 00:24:19 +0000 | \n", "<a href=\"http://twitter.com/download/iphone\" r... | \n", "This is quite the dog. Gets really excited whe... | \n", "NaN | \n", "NaN | \n", "NaN | \n", "https://twitter.com/dog_rates/status/666411507... | \n", "2 | \n", "10 | \n", "quite | \n", "None | \n", "None | \n", "None | \n", "None | \n", "
2327 | \n", "666407126856765440 | \n", "NaN | \n", "NaN | \n", "2015-11-17 00:06:54 +0000 | \n", "<a href=\"http://twitter.com/download/iphone\" r... | \n", "This is a southern Vesuvius bumblegruff. Can d... | \n", "NaN | \n", "NaN | \n", "NaN | \n", "https://twitter.com/dog_rates/status/666407126... | \n", "7 | \n", "10 | \n", "a | \n", "None | \n", "None | \n", "None | \n", "None | \n", "
2328 | \n", "666396247373291520 | \n", "NaN | \n", "NaN | \n", "2015-11-16 23:23:41 +0000 | \n", "<a href=\"http://twitter.com/download/iphone\" r... | \n", "Oh goodness. A super rare northeast Qdoba kang... | \n", "NaN | \n", "NaN | \n", "NaN | \n", "https://twitter.com/dog_rates/status/666396247... | \n", "9 | \n", "10 | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "
2329 | \n", "666373753744588802 | \n", "NaN | \n", "NaN | \n", "2015-11-16 21:54:18 +0000 | \n", "<a href=\"http://twitter.com/download/iphone\" r... | \n", "Those are sunglasses and a jean jacket. 11/10 ... | \n", "NaN | \n", "NaN | \n", "NaN | \n", "https://twitter.com/dog_rates/status/666373753... | \n", "11 | \n", "10 | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "
2330 | \n", "666362758909284353 | \n", "NaN | \n", "NaN | \n", "2015-11-16 21:10:36 +0000 | \n", "<a href=\"http://twitter.com/download/iphone\" r... | \n", "Unique dog here. Very small. Lives in containe... | \n", "NaN | \n", "NaN | \n", "NaN | \n", "https://twitter.com/dog_rates/status/666362758... | \n", "6 | \n", "10 | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "
2331 | \n", "666353288456101888 | \n", "NaN | \n", "NaN | \n", "2015-11-16 20:32:58 +0000 | \n", "<a href=\"http://twitter.com/download/iphone\" r... | \n", "Here we have a mixed Asiago from the Galápagos... | \n", "NaN | \n", "NaN | \n", "NaN | \n", "https://twitter.com/dog_rates/status/666353288... | \n", "8 | \n", "10 | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "
2332 | \n", "666345417576210432 | \n", "NaN | \n", "NaN | \n", "2015-11-16 20:01:42 +0000 | \n", "<a href=\"http://twitter.com/download/iphone\" r... | \n", "Look at this jokester thinking seat belt laws ... | \n", "NaN | \n", "NaN | \n", "NaN | \n", "https://twitter.com/dog_rates/status/666345417... | \n", "10 | \n", "10 | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "
2333 | \n", "666337882303524864 | \n", "NaN | \n", "NaN | \n", "2015-11-16 19:31:45 +0000 | \n", "<a href=\"http://twitter.com/download/iphone\" r... | \n", "This is an extremely rare horned Parthenon. No... | \n", "NaN | \n", "NaN | \n", "NaN | \n", "https://twitter.com/dog_rates/status/666337882... | \n", "9 | \n", "10 | \n", "an | \n", "None | \n", "None | \n", "None | \n", "None | \n", "
2334 | \n", "666293911632134144 | \n", "NaN | \n", "NaN | \n", "2015-11-16 16:37:02 +0000 | \n", "<a href=\"http://twitter.com/download/iphone\" r... | \n", "This is a funny dog. Weird toes. Won't come do... | \n", "NaN | \n", "NaN | \n", "NaN | \n", "https://twitter.com/dog_rates/status/666293911... | \n", "3 | \n", "10 | \n", "a | \n", "None | \n", "None | \n", "None | \n", "None | \n", "
2335 | \n", "666287406224695296 | \n", "NaN | \n", "NaN | \n", "2015-11-16 16:11:11 +0000 | \n", "<a href=\"http://twitter.com/download/iphone\" r... | \n", "This is an Albanian 3 1/2 legged Episcopalian... | \n", "NaN | \n", "NaN | \n", "NaN | \n", "https://twitter.com/dog_rates/status/666287406... | \n", "1 | \n", "2 | \n", "an | \n", "None | \n", "None | \n", "None | \n", "None | \n", "
2336 | \n", "666273097616637952 | \n", "NaN | \n", "NaN | \n", "2015-11-16 15:14:19 +0000 | \n", "<a href=\"http://twitter.com/download/iphone\" r... | \n", "Can take selfies 11/10 https://t.co/ws2AMaNwPW | \n", "NaN | \n", "NaN | \n", "NaN | \n", "https://twitter.com/dog_rates/status/666273097... | \n", "11 | \n", "10 | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "
2337 | \n", "666268910803644416 | \n", "NaN | \n", "NaN | \n", "2015-11-16 14:57:41 +0000 | \n", "<a href=\"http://twitter.com/download/iphone\" r... | \n", "Very concerned about fellow dog trapped in com... | \n", "NaN | \n", "NaN | \n", "NaN | \n", "https://twitter.com/dog_rates/status/666268910... | \n", "10 | \n", "10 | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "
2338 | \n", "666104133288665088 | \n", "NaN | \n", "NaN | \n", "2015-11-16 04:02:55 +0000 | \n", "<a href=\"http://twitter.com/download/iphone\" r... | \n", "Not familiar with this breed. No tail (weird).... | \n", "NaN | \n", "NaN | \n", "NaN | \n", "https://twitter.com/dog_rates/status/666104133... | \n", "1 | \n", "10 | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "
2339 | \n", "666102155909144576 | \n", "NaN | \n", "NaN | \n", "2015-11-16 03:55:04 +0000 | \n", "<a href=\"http://twitter.com/download/iphone\" r... | \n", "Oh my. Here you are seeing an Adobe Setter giv... | \n", "NaN | \n", "NaN | \n", "NaN | \n", "https://twitter.com/dog_rates/status/666102155... | \n", "11 | \n", "10 | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "
2340 | \n", "666099513787052032 | \n", "NaN | \n", "NaN | \n", "2015-11-16 03:44:34 +0000 | \n", "<a href=\"http://twitter.com/download/iphone\" r... | \n", "Can stand on stump for what seems like a while... | \n", "NaN | \n", "NaN | \n", "NaN | \n", "https://twitter.com/dog_rates/status/666099513... | \n", "8 | \n", "10 | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "
2341 | \n", "666094000022159362 | \n", "NaN | \n", "NaN | \n", "2015-11-16 03:22:39 +0000 | \n", "<a href=\"http://twitter.com/download/iphone\" r... | \n", "This appears to be a Mongolian Presbyterian mi... | \n", "NaN | \n", "NaN | \n", "NaN | \n", "https://twitter.com/dog_rates/status/666094000... | \n", "9 | \n", "10 | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "
2342 | \n", "666082916733198337 | \n", "NaN | \n", "NaN | \n", "2015-11-16 02:38:37 +0000 | \n", "<a href=\"http://twitter.com/download/iphone\" r... | \n", "Here we have a well-established sunblockerspan... | \n", "NaN | \n", "NaN | \n", "NaN | \n", "https://twitter.com/dog_rates/status/666082916... | \n", "6 | \n", "10 | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "
2343 | \n", "666073100786774016 | \n", "NaN | \n", "NaN | \n", "2015-11-16 01:59:36 +0000 | \n", "<a href=\"http://twitter.com/download/iphone\" r... | \n", "Let's hope this flight isn't Malaysian (lol). ... | \n", "NaN | \n", "NaN | \n", "NaN | \n", "https://twitter.com/dog_rates/status/666073100... | \n", "10 | \n", "10 | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "
2344 | \n", "666071193221509120 | \n", "NaN | \n", "NaN | \n", "2015-11-16 01:52:02 +0000 | \n", "<a href=\"http://twitter.com/download/iphone\" r... | \n", "Here we have a northern speckled Rhododendron.... | \n", "NaN | \n", "NaN | \n", "NaN | \n", "https://twitter.com/dog_rates/status/666071193... | \n", "9 | \n", "10 | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "
2345 | \n", "666063827256086533 | \n", "NaN | \n", "NaN | \n", "2015-11-16 01:22:45 +0000 | \n", "<a href=\"http://twitter.com/download/iphone\" r... | \n", "This is the happiest dog you will ever see. Ve... | \n", "NaN | \n", "NaN | \n", "NaN | \n", "https://twitter.com/dog_rates/status/666063827... | \n", "10 | \n", "10 | \n", "the | \n", "None | \n", "None | \n", "None | \n", "None | \n", "
2346 | \n", "666058600524156928 | \n", "NaN | \n", "NaN | \n", "2015-11-16 01:01:59 +0000 | \n", "<a href=\"http://twitter.com/download/iphone\" r... | \n", "Here is the Rand Paul of retrievers folks! He'... | \n", "NaN | \n", "NaN | \n", "NaN | \n", "https://twitter.com/dog_rates/status/666058600... | \n", "8 | \n", "10 | \n", "the | \n", "None | \n", "None | \n", "None | \n", "None | \n", "
2347 | \n", "666057090499244032 | \n", "NaN | \n", "NaN | \n", "2015-11-16 00:55:59 +0000 | \n", "<a href=\"http://twitter.com/download/iphone\" r... | \n", "My oh my. This is a rare blond Canadian terrie... | \n", "NaN | \n", "NaN | \n", "NaN | \n", "https://twitter.com/dog_rates/status/666057090... | \n", "9 | \n", "10 | \n", "a | \n", "None | \n", "None | \n", "None | \n", "None | \n", "
2348 | \n", "666055525042405380 | \n", "NaN | \n", "NaN | \n", "2015-11-16 00:49:46 +0000 | \n", "<a href=\"http://twitter.com/download/iphone\" r... | \n", "Here is a Siberian heavily armored polar bear ... | \n", "NaN | \n", "NaN | \n", "NaN | \n", "https://twitter.com/dog_rates/status/666055525... | \n", "10 | \n", "10 | \n", "a | \n", "None | \n", "None | \n", "None | \n", "None | \n", "
2349 | \n", "666051853826850816 | \n", "NaN | \n", "NaN | \n", "2015-11-16 00:35:11 +0000 | \n", "<a href=\"http://twitter.com/download/iphone\" r... | \n", "This is an odd dog. Hard on the outside but lo... | \n", "NaN | \n", "NaN | \n", "NaN | \n", "https://twitter.com/dog_rates/status/666051853... | \n", "2 | \n", "10 | \n", "an | \n", "None | \n", "None | \n", "None | \n", "None | \n", "
2350 | \n", "666050758794694657 | \n", "NaN | \n", "NaN | \n", "2015-11-16 00:30:50 +0000 | \n", "<a href=\"http://twitter.com/download/iphone\" r... | \n", "This is a truly beautiful English Wilson Staff... | \n", "NaN | \n", "NaN | \n", "NaN | \n", "https://twitter.com/dog_rates/status/666050758... | \n", "10 | \n", "10 | \n", "a | \n", "None | \n", "None | \n", "None | \n", "None | \n", "
2351 | \n", "666049248165822465 | \n", "NaN | \n", "NaN | \n", "2015-11-16 00:24:50 +0000 | \n", "<a href=\"http://twitter.com/download/iphone\" r... | \n", "Here we have a 1949 1st generation vulpix. Enj... | \n", "NaN | \n", "NaN | \n", "NaN | \n", "https://twitter.com/dog_rates/status/666049248... | \n", "5 | \n", "10 | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "
2352 | \n", "666044226329800704 | \n", "NaN | \n", "NaN | \n", "2015-11-16 00:04:52 +0000 | \n", "<a href=\"http://twitter.com/download/iphone\" r... | \n", "This is a purebred Piers Morgan. Loves to Netf... | \n", "NaN | \n", "NaN | \n", "NaN | \n", "https://twitter.com/dog_rates/status/666044226... | \n", "6 | \n", "10 | \n", "a | \n", "None | \n", "None | \n", "None | \n", "None | \n", "
2353 | \n", "666033412701032449 | \n", "NaN | \n", "NaN | \n", "2015-11-15 23:21:54 +0000 | \n", "<a href=\"http://twitter.com/download/iphone\" r... | \n", "Here is a very happy pup. Big fan of well-main... | \n", "NaN | \n", "NaN | \n", "NaN | \n", "https://twitter.com/dog_rates/status/666033412... | \n", "9 | \n", "10 | \n", "a | \n", "None | \n", "None | \n", "None | \n", "None | \n", "
2354 | \n", "666029285002620928 | \n", "NaN | \n", "NaN | \n", "2015-11-15 23:05:30 +0000 | \n", "<a href=\"http://twitter.com/download/iphone\" r... | \n", "This is a western brown Mitsubishi terrier. Up... | \n", "NaN | \n", "NaN | \n", "NaN | \n", "https://twitter.com/dog_rates/status/666029285... | \n", "7 | \n", "10 | \n", "a | \n", "None | \n", "None | \n", "None | \n", "None | \n", "
2355 | \n", "666020888022790149 | \n", "NaN | \n", "NaN | \n", "2015-11-15 22:32:08 +0000 | \n", "<a href=\"http://twitter.com/download/iphone\" r... | \n", "Here we have a Japanese Irish Setter. Lost eye... | \n", "NaN | \n", "NaN | \n", "NaN | \n", "https://twitter.com/dog_rates/status/666020888... | \n", "8 | \n", "10 | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "
2356 rows × 17 columns
\n", "\n", " | tweet_id | \n", "in_reply_to_status_id | \n", "in_reply_to_user_id | \n", "timestamp | \n", "source | \n", "text | \n", "retweeted_status_id | \n", "retweeted_status_user_id | \n", "retweeted_status_timestamp | \n", "expanded_urls | \n", "rating_numerator | \n", "rating_denominator | \n", "name | \n", "doggo | \n", "floofer | \n", "pupper | \n", "puppo | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1062 | \n", "741099773336379392 | \n", "NaN | \n", "NaN | \n", "2016-06-10 02:48:49 +0000 | \n", "<a href=\"http://vine.co\" rel=\"nofollow\">Vine -... | \n", "This is Ted. He's given up. 11/10 relatable af... | \n", "NaN | \n", "NaN | \n", "NaN | \n", "https://vine.co/v/ixHYvdxUx1L | \n", "11 | \n", "10 | \n", "Ted | \n", "None | \n", "None | \n", "None | \n", "None | \n", "
2347 | \n", "666057090499244032 | \n", "NaN | \n", "NaN | \n", "2015-11-16 00:55:59 +0000 | \n", "<a href=\"http://twitter.com/download/iphone\" r... | \n", "My oh my. This is a rare blond Canadian terrie... | \n", "NaN | \n", "NaN | \n", "NaN | \n", "https://twitter.com/dog_rates/status/666057090... | \n", "9 | \n", "10 | \n", "a | \n", "None | \n", "None | \n", "None | \n", "None | \n", "
555 | \n", "803692223237865472 | \n", "NaN | \n", "NaN | \n", "2016-11-29 20:08:52 +0000 | \n", "<a href=\"http://twitter.com/download/iphone\" r... | \n", "RT @dog_rates: I present to you... Dog Jesus. ... | \n", "6.914169e+17 | \n", "4.196984e+09 | \n", "2016-01-25 00:26:41 +0000 | \n", "https://twitter.com/dog_rates/status/691416866... | \n", "13 | \n", "10 | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "
1305 | \n", "707387676719185920 | \n", "NaN | \n", "NaN | \n", "2016-03-09 02:08:59 +0000 | \n", "<a href=\"http://twitter.com/download/iphone\" r... | \n", "Meet Clarkus. He's a Skinny Eastern Worcesters... | \n", "NaN | \n", "NaN | \n", "NaN | \n", "https://twitter.com/dog_rates/status/707387676... | \n", "10 | \n", "10 | \n", "Clarkus | \n", "None | \n", "None | \n", "None | \n", "None | \n", "
1060 | \n", "741438259667034112 | \n", "NaN | \n", "NaN | \n", "2016-06-11 01:13:51 +0000 | \n", "<a href=\"http://twitter.com/download/iphone\" r... | \n", "This is Tucker. He's still figuring out couche... | \n", "NaN | \n", "NaN | \n", "NaN | \n", "https://twitter.com/dog_rates/status/741438259... | \n", "9 | \n", "10 | \n", "Tucker | \n", "None | \n", "None | \n", "None | \n", "None | \n", "
149 | \n", "863079547188785154 | \n", "6.671522e+17 | \n", "4.196984e+09 | \n", "2017-05-12 17:12:53 +0000 | \n", "<a href=\"http://twitter.com/download/iphone\" r... | \n", "Ladies and gentlemen... I found Pipsy. He may ... | \n", "NaN | \n", "NaN | \n", "NaN | \n", "https://twitter.com/dog_rates/status/863079547... | \n", "14 | \n", "10 | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "
1073 | \n", "739932936087216128 | \n", "NaN | \n", "NaN | \n", "2016-06-06 21:32:13 +0000 | \n", "<a href=\"http://twitter.com/download/iphone\" r... | \n", "Say hello to Rorie. She's zen af. Just enjoyin... | \n", "NaN | \n", "NaN | \n", "NaN | \n", "https://twitter.com/dog_rates/status/739932936... | \n", "10 | \n", "10 | \n", "Rorie | \n", "None | \n", "None | \n", "None | \n", "None | \n", "
1828 | \n", "676263575653122048 | \n", "NaN | \n", "NaN | \n", "2015-12-14 04:52:55 +0000 | \n", "<a href=\"http://twitter.com/download/iphone\" r... | \n", "All this pupper wanted to do was go skiing. No... | \n", "NaN | \n", "NaN | \n", "NaN | \n", "https://twitter.com/dog_rates/status/676263575... | \n", "10 | \n", "10 | \n", "None | \n", "None | \n", "None | \n", "pupper | \n", "None | \n", "
1938 | \n", "673906403526995968 | \n", "NaN | \n", "NaN | \n", "2015-12-07 16:46:21 +0000 | \n", "<a href=\"http://twitter.com/download/iphone\" r... | \n", "Guys I'm getting real tired of this. We only r... | \n", "NaN | \n", "NaN | \n", "NaN | \n", "https://twitter.com/dog_rates/status/673906403... | \n", "3 | \n", "10 | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "
1054 | \n", "742423170473463808 | \n", "NaN | \n", "NaN | \n", "2016-06-13 18:27:32 +0000 | \n", "<a href=\"http://twitter.com/download/iphone\" r... | \n", "This is Bell. She likes holding hands. 12/10 w... | \n", "NaN | \n", "NaN | \n", "NaN | \n", "https://twitter.com/dog_rates/status/742423170... | \n", "12 | \n", "10 | \n", "Bell | \n", "None | \n", "None | \n", "None | \n", "None | \n", "
\n", " | tweet_id | \n", "in_reply_to_status_id | \n", "in_reply_to_user_id | \n", "timestamp | \n", "source | \n", "text | \n", "retweeted_status_id | \n", "retweeted_status_user_id | \n", "retweeted_status_timestamp | \n", "expanded_urls | \n", "rating_numerator | \n", "rating_denominator | \n", "name | \n", "doggo | \n", "floofer | \n", "pupper | \n", "puppo | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0 | \n", "False | \n", "True | \n", "True | \n", "False | \n", "False | \n", "False | \n", "True | \n", "True | \n", "True | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "
1 | \n", "False | \n", "True | \n", "True | \n", "False | \n", "False | \n", "False | \n", "True | \n", "True | \n", "True | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "
2 | \n", "False | \n", "True | \n", "True | \n", "False | \n", "False | \n", "False | \n", "True | \n", "True | \n", "True | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "
3 | \n", "False | \n", "True | \n", "True | \n", "False | \n", "False | \n", "False | \n", "True | \n", "True | \n", "True | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "
4 | \n", "False | \n", "True | \n", "True | \n", "False | \n", "False | \n", "False | \n", "True | \n", "True | \n", "True | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "
5 | \n", "False | \n", "True | \n", "True | \n", "False | \n", "False | \n", "False | \n", "True | \n", "True | \n", "True | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "
6 | \n", "False | \n", "True | \n", "True | \n", "False | \n", "False | \n", "False | \n", "True | \n", "True | \n", "True | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "
7 | \n", "False | \n", "True | \n", "True | \n", "False | \n", "False | \n", "False | \n", "True | \n", "True | \n", "True | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "
8 | \n", "False | \n", "True | \n", "True | \n", "False | \n", "False | \n", "False | \n", "True | \n", "True | \n", "True | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "
9 | \n", "False | \n", "True | \n", "True | \n", "False | \n", "False | \n", "False | \n", "True | \n", "True | \n", "True | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "
10 | \n", "False | \n", "True | \n", "True | \n", "False | \n", "False | \n", "False | \n", "True | \n", "True | \n", "True | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "
11 | \n", "False | \n", "True | \n", "True | \n", "False | \n", "False | \n", "False | \n", "True | \n", "True | \n", "True | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "
12 | \n", "False | \n", "True | \n", "True | \n", "False | \n", "False | \n", "False | \n", "True | \n", "True | \n", "True | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "
13 | \n", "False | \n", "True | \n", "True | \n", "False | \n", "False | \n", "False | \n", "True | \n", "True | \n", "True | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "
14 | \n", "False | \n", "True | \n", "True | \n", "False | \n", "False | \n", "False | \n", "True | \n", "True | \n", "True | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "
15 | \n", "False | \n", "True | \n", "True | \n", "False | \n", "False | \n", "False | \n", "True | \n", "True | \n", "True | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "
16 | \n", "False | \n", "True | \n", "True | \n", "False | \n", "False | \n", "False | \n", "True | \n", "True | \n", "True | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "
17 | \n", "False | \n", "True | \n", "True | \n", "False | \n", "False | \n", "False | \n", "True | \n", "True | \n", "True | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "
18 | \n", "False | \n", "True | \n", "True | \n", "False | \n", "False | \n", "False | \n", "True | \n", "True | \n", "True | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "
19 | \n", "False | \n", "True | \n", "True | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "
20 | \n", "False | \n", "True | \n", "True | \n", "False | \n", "False | \n", "False | \n", "True | \n", "True | \n", "True | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "
21 | \n", "False | \n", "True | \n", "True | \n", "False | \n", "False | \n", "False | \n", "True | \n", "True | \n", "True | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "
22 | \n", "False | \n", "True | \n", "True | \n", "False | \n", "False | \n", "False | \n", "True | \n", "True | \n", "True | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "
23 | \n", "False | \n", "True | \n", "True | \n", "False | \n", "False | \n", "False | \n", "True | \n", "True | \n", "True | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "
24 | \n", "False | \n", "True | \n", "True | \n", "False | \n", "False | \n", "False | \n", "True | \n", "True | \n", "True | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "
25 | \n", "False | \n", "True | \n", "True | \n", "False | \n", "False | \n", "False | \n", "True | \n", "True | \n", "True | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "
26 | \n", "False | \n", "True | \n", "True | \n", "False | \n", "False | \n", "False | \n", "True | \n", "True | \n", "True | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "
27 | \n", "False | \n", "True | \n", "True | \n", "False | \n", "False | \n", "False | \n", "True | \n", "True | \n", "True | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "
28 | \n", "False | \n", "True | \n", "True | \n", "False | \n", "False | \n", "False | \n", "True | \n", "True | \n", "True | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "
29 | \n", "False | \n", "True | \n", "True | \n", "False | \n", "False | \n", "False | \n", "True | \n", "True | \n", "True | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "
... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "
2326 | \n", "False | \n", "True | \n", "True | \n", "False | \n", "False | \n", "False | \n", "True | \n", "True | \n", "True | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "
2327 | \n", "False | \n", "True | \n", "True | \n", "False | \n", "False | \n", "False | \n", "True | \n", "True | \n", "True | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "
2328 | \n", "False | \n", "True | \n", "True | \n", "False | \n", "False | \n", "False | \n", "True | \n", "True | \n", "True | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "
2329 | \n", "False | \n", "True | \n", "True | \n", "False | \n", "False | \n", "False | \n", "True | \n", "True | \n", "True | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "
2330 | \n", "False | \n", "True | \n", "True | \n", "False | \n", "False | \n", "False | \n", "True | \n", "True | \n", "True | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "
2331 | \n", "False | \n", "True | \n", "True | \n", "False | \n", "False | \n", "False | \n", "True | \n", "True | \n", "True | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "
2332 | \n", "False | \n", "True | \n", "True | \n", "False | \n", "False | \n", "False | \n", "True | \n", "True | \n", "True | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "
2333 | \n", "False | \n", "True | \n", "True | \n", "False | \n", "False | \n", "False | \n", "True | \n", "True | \n", "True | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "
2334 | \n", "False | \n", "True | \n", "True | \n", "False | \n", "False | \n", "False | \n", "True | \n", "True | \n", "True | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "
2335 | \n", "False | \n", "True | \n", "True | \n", "False | \n", "False | \n", "False | \n", "True | \n", "True | \n", "True | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "
2336 | \n", "False | \n", "True | \n", "True | \n", "False | \n", "False | \n", "False | \n", "True | \n", "True | \n", "True | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "
2337 | \n", "False | \n", "True | \n", "True | \n", "False | \n", "False | \n", "False | \n", "True | \n", "True | \n", "True | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "
2338 | \n", "False | \n", "True | \n", "True | \n", "False | \n", "False | \n", "False | \n", "True | \n", "True | \n", "True | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "
2339 | \n", "False | \n", "True | \n", "True | \n", "False | \n", "False | \n", "False | \n", "True | \n", "True | \n", "True | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "
2340 | \n", "False | \n", "True | \n", "True | \n", "False | \n", "False | \n", "False | \n", "True | \n", "True | \n", "True | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "
2341 | \n", "False | \n", "True | \n", "True | \n", "False | \n", "False | \n", "False | \n", "True | \n", "True | \n", "True | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "
2342 | \n", "False | \n", "True | \n", "True | \n", "False | \n", "False | \n", "False | \n", "True | \n", "True | \n", "True | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "
2343 | \n", "False | \n", "True | \n", "True | \n", "False | \n", "False | \n", "False | \n", "True | \n", "True | \n", "True | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "
2344 | \n", "False | \n", "True | \n", "True | \n", "False | \n", "False | \n", "False | \n", "True | \n", "True | \n", "True | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "
2345 | \n", "False | \n", "True | \n", "True | \n", "False | \n", "False | \n", "False | \n", "True | \n", "True | \n", "True | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "
2346 | \n", "False | \n", "True | \n", "True | \n", "False | \n", "False | \n", "False | \n", "True | \n", "True | \n", "True | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "
2347 | \n", "False | \n", "True | \n", "True | \n", "False | \n", "False | \n", "False | \n", "True | \n", "True | \n", "True | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "
2348 | \n", "False | \n", "True | \n", "True | \n", "False | \n", "False | \n", "False | \n", "True | \n", "True | \n", "True | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "
2349 | \n", "False | \n", "True | \n", "True | \n", "False | \n", "False | \n", "False | \n", "True | \n", "True | \n", "True | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "
2350 | \n", "False | \n", "True | \n", "True | \n", "False | \n", "False | \n", "False | \n", "True | \n", "True | \n", "True | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "
2351 | \n", "False | \n", "True | \n", "True | \n", "False | \n", "False | \n", "False | \n", "True | \n", "True | \n", "True | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "
2352 | \n", "False | \n", "True | \n", "True | \n", "False | \n", "False | \n", "False | \n", "True | \n", "True | \n", "True | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "
2353 | \n", "False | \n", "True | \n", "True | \n", "False | \n", "False | \n", "False | \n", "True | \n", "True | \n", "True | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "
2354 | \n", "False | \n", "True | \n", "True | \n", "False | \n", "False | \n", "False | \n", "True | \n", "True | \n", "True | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "
2355 | \n", "False | \n", "True | \n", "True | \n", "False | \n", "False | \n", "False | \n", "True | \n", "True | \n", "True | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "
2356 rows × 17 columns
\n", "\n", " | tweet_id | \n", "jpg_url | \n", "img_num | \n", "p1 | \n", "p1_conf | \n", "p1_dog | \n", "p2 | \n", "p2_conf | \n", "p2_dog | \n", "p3 | \n", "p3_conf | \n", "p3_dog | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|
0 | \n", "666020888022790149 | \n", "https://pbs.twimg.com/media/CT4udn0WwAA0aMy.jpg | \n", "1 | \n", "Welsh_springer_spaniel | \n", "0.465074 | \n", "True | \n", "collie | \n", "0.156665 | \n", "True | \n", "Shetland_sheepdog | \n", "0.061428 | \n", "True | \n", "
1 | \n", "666029285002620928 | \n", "https://pbs.twimg.com/media/CT42GRgUYAA5iDo.jpg | \n", "1 | \n", "redbone | \n", "0.506826 | \n", "True | \n", "miniature_pinscher | \n", "0.074192 | \n", "True | \n", "Rhodesian_ridgeback | \n", "0.072010 | \n", "True | \n", "
2 | \n", "666033412701032449 | \n", "https://pbs.twimg.com/media/CT4521TWwAEvMyu.jpg | \n", "1 | \n", "German_shepherd | \n", "0.596461 | \n", "True | \n", "malinois | \n", "0.138584 | \n", "True | \n", "bloodhound | \n", "0.116197 | \n", "True | \n", "
3 | \n", "666044226329800704 | \n", "https://pbs.twimg.com/media/CT5Dr8HUEAA-lEu.jpg | \n", "1 | \n", "Rhodesian_ridgeback | \n", "0.408143 | \n", "True | \n", "redbone | \n", "0.360687 | \n", "True | \n", "miniature_pinscher | \n", "0.222752 | \n", "True | \n", "
4 | \n", "666049248165822465 | \n", "https://pbs.twimg.com/media/CT5IQmsXIAAKY4A.jpg | \n", "1 | \n", "miniature_pinscher | \n", "0.560311 | \n", "True | \n", "Rottweiler | \n", "0.243682 | \n", "True | \n", "Doberman | \n", "0.154629 | \n", "True | \n", "
5 | \n", "666050758794694657 | \n", "https://pbs.twimg.com/media/CT5Jof1WUAEuVxN.jpg | \n", "1 | \n", "Bernese_mountain_dog | \n", "0.651137 | \n", "True | \n", "English_springer | \n", "0.263788 | \n", "True | \n", "Greater_Swiss_Mountain_dog | \n", "0.016199 | \n", "True | \n", "
6 | \n", "666051853826850816 | \n", "https://pbs.twimg.com/media/CT5KoJ1WoAAJash.jpg | \n", "1 | \n", "box_turtle | \n", "0.933012 | \n", "False | \n", "mud_turtle | \n", "0.045885 | \n", "False | \n", "terrapin | \n", "0.017885 | \n", "False | \n", "
7 | \n", "666055525042405380 | \n", "https://pbs.twimg.com/media/CT5N9tpXIAAifs1.jpg | \n", "1 | \n", "chow | \n", "0.692517 | \n", "True | \n", "Tibetan_mastiff | \n", "0.058279 | \n", "True | \n", "fur_coat | \n", "0.054449 | \n", "False | \n", "
8 | \n", "666057090499244032 | \n", "https://pbs.twimg.com/media/CT5PY90WoAAQGLo.jpg | \n", "1 | \n", "shopping_cart | \n", "0.962465 | \n", "False | \n", "shopping_basket | \n", "0.014594 | \n", "False | \n", "golden_retriever | \n", "0.007959 | \n", "True | \n", "
9 | \n", "666058600524156928 | \n", "https://pbs.twimg.com/media/CT5Qw94XAAA_2dP.jpg | \n", "1 | \n", "miniature_poodle | \n", "0.201493 | \n", "True | \n", "komondor | \n", "0.192305 | \n", "True | \n", "soft-coated_wheaten_terrier | \n", "0.082086 | \n", "True | \n", "
10 | \n", "666063827256086533 | \n", "https://pbs.twimg.com/media/CT5Vg_wXIAAXfnj.jpg | \n", "1 | \n", "golden_retriever | \n", "0.775930 | \n", "True | \n", "Tibetan_mastiff | \n", "0.093718 | \n", "True | \n", "Labrador_retriever | \n", "0.072427 | \n", "True | \n", "
11 | \n", "666071193221509120 | \n", "https://pbs.twimg.com/media/CT5cN_3WEAAlOoZ.jpg | \n", "1 | \n", "Gordon_setter | \n", "0.503672 | \n", "True | \n", "Yorkshire_terrier | \n", "0.174201 | \n", "True | \n", "Pekinese | \n", "0.109454 | \n", "True | \n", "
12 | \n", "666073100786774016 | \n", "https://pbs.twimg.com/media/CT5d9DZXAAALcwe.jpg | \n", "1 | \n", "Walker_hound | \n", "0.260857 | \n", "True | \n", "English_foxhound | \n", "0.175382 | \n", "True | \n", "Ibizan_hound | \n", "0.097471 | \n", "True | \n", "
13 | \n", "666082916733198337 | \n", "https://pbs.twimg.com/media/CT5m4VGWEAAtKc8.jpg | \n", "1 | \n", "pug | \n", "0.489814 | \n", "True | \n", "bull_mastiff | \n", "0.404722 | \n", "True | \n", "French_bulldog | \n", "0.048960 | \n", "True | \n", "
14 | \n", "666094000022159362 | \n", "https://pbs.twimg.com/media/CT5w9gUW4AAsBNN.jpg | \n", "1 | \n", "bloodhound | \n", "0.195217 | \n", "True | \n", "German_shepherd | \n", "0.078260 | \n", "True | \n", "malinois | \n", "0.075628 | \n", "True | \n", "
15 | \n", "666099513787052032 | \n", "https://pbs.twimg.com/media/CT51-JJUEAA6hV8.jpg | \n", "1 | \n", "Lhasa | \n", "0.582330 | \n", "True | \n", "Shih-Tzu | \n", "0.166192 | \n", "True | \n", "Dandie_Dinmont | \n", "0.089688 | \n", "True | \n", "
16 | \n", "666102155909144576 | \n", "https://pbs.twimg.com/media/CT54YGiWUAEZnoK.jpg | \n", "1 | \n", "English_setter | \n", "0.298617 | \n", "True | \n", "Newfoundland | \n", "0.149842 | \n", "True | \n", "borzoi | \n", "0.133649 | \n", "True | \n", "
17 | \n", "666104133288665088 | \n", "https://pbs.twimg.com/media/CT56LSZWoAAlJj2.jpg | \n", "1 | \n", "hen | \n", "0.965932 | \n", "False | \n", "cock | \n", "0.033919 | \n", "False | \n", "partridge | \n", "0.000052 | \n", "False | \n", "
18 | \n", "666268910803644416 | \n", "https://pbs.twimg.com/media/CT8QCd1WEAADXws.jpg | \n", "1 | \n", "desktop_computer | \n", "0.086502 | \n", "False | \n", "desk | \n", "0.085547 | \n", "False | \n", "bookcase | \n", "0.079480 | \n", "False | \n", "
19 | \n", "666273097616637952 | \n", "https://pbs.twimg.com/media/CT8T1mtUwAA3aqm.jpg | \n", "1 | \n", "Italian_greyhound | \n", "0.176053 | \n", "True | \n", "toy_terrier | \n", "0.111884 | \n", "True | \n", "basenji | \n", "0.111152 | \n", "True | \n", "
20 | \n", "666287406224695296 | \n", "https://pbs.twimg.com/media/CT8g3BpUEAAuFjg.jpg | \n", "1 | \n", "Maltese_dog | \n", "0.857531 | \n", "True | \n", "toy_poodle | \n", "0.063064 | \n", "True | \n", "miniature_poodle | \n", "0.025581 | \n", "True | \n", "
21 | \n", "666293911632134144 | \n", "https://pbs.twimg.com/media/CT8mx7KW4AEQu8N.jpg | \n", "1 | \n", "three-toed_sloth | \n", "0.914671 | \n", "False | \n", "otter | \n", "0.015250 | \n", "False | \n", "great_grey_owl | \n", "0.013207 | \n", "False | \n", "
22 | \n", "666337882303524864 | \n", "https://pbs.twimg.com/media/CT9OwFIWEAMuRje.jpg | \n", "1 | \n", "ox | \n", "0.416669 | \n", "False | \n", "Newfoundland | \n", "0.278407 | \n", "True | \n", "groenendael | \n", "0.102643 | \n", "True | \n", "
23 | \n", "666345417576210432 | \n", "https://pbs.twimg.com/media/CT9Vn7PWoAA_ZCM.jpg | \n", "1 | \n", "golden_retriever | \n", "0.858744 | \n", "True | \n", "Chesapeake_Bay_retriever | \n", "0.054787 | \n", "True | \n", "Labrador_retriever | \n", "0.014241 | \n", "True | \n", "
24 | \n", "666353288456101888 | \n", "https://pbs.twimg.com/media/CT9cx0tUEAAhNN_.jpg | \n", "1 | \n", "malamute | \n", "0.336874 | \n", "True | \n", "Siberian_husky | \n", "0.147655 | \n", "True | \n", "Eskimo_dog | \n", "0.093412 | \n", "True | \n", "
25 | \n", "666362758909284353 | \n", "https://pbs.twimg.com/media/CT9lXGsUcAAyUFt.jpg | \n", "1 | \n", "guinea_pig | \n", "0.996496 | \n", "False | \n", "skunk | \n", "0.002402 | \n", "False | \n", "hamster | \n", "0.000461 | \n", "False | \n", "
26 | \n", "666373753744588802 | \n", "https://pbs.twimg.com/media/CT9vZEYWUAAlZ05.jpg | \n", "1 | \n", "soft-coated_wheaten_terrier | \n", "0.326467 | \n", "True | \n", "Afghan_hound | \n", "0.259551 | \n", "True | \n", "briard | \n", "0.206803 | \n", "True | \n", "
27 | \n", "666396247373291520 | \n", "https://pbs.twimg.com/media/CT-D2ZHWIAA3gK1.jpg | \n", "1 | \n", "Chihuahua | \n", "0.978108 | \n", "True | \n", "toy_terrier | \n", "0.009397 | \n", "True | \n", "papillon | \n", "0.004577 | \n", "True | \n", "
28 | \n", "666407126856765440 | \n", "https://pbs.twimg.com/media/CT-NvwmW4AAugGZ.jpg | \n", "1 | \n", "black-and-tan_coonhound | \n", "0.529139 | \n", "True | \n", "bloodhound | \n", "0.244220 | \n", "True | \n", "flat-coated_retriever | \n", "0.173810 | \n", "True | \n", "
29 | \n", "666411507551481857 | \n", "https://pbs.twimg.com/media/CT-RugiWIAELEaq.jpg | \n", "1 | \n", "coho | \n", "0.404640 | \n", "False | \n", "barracouta | \n", "0.271485 | \n", "False | \n", "gar | \n", "0.189945 | \n", "False | \n", "
... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "
2045 | \n", "886366144734445568 | \n", "https://pbs.twimg.com/media/DE0BTnQUwAApKEH.jpg | \n", "1 | \n", "French_bulldog | \n", "0.999201 | \n", "True | \n", "Chihuahua | \n", "0.000361 | \n", "True | \n", "Boston_bull | \n", "0.000076 | \n", "True | \n", "
2046 | \n", "886680336477933568 | \n", "https://pbs.twimg.com/media/DE4fEDzWAAAyHMM.jpg | \n", "1 | \n", "convertible | \n", "0.738995 | \n", "False | \n", "sports_car | \n", "0.139952 | \n", "False | \n", "car_wheel | \n", "0.044173 | \n", "False | \n", "
2047 | \n", "886736880519319552 | \n", "https://pbs.twimg.com/media/DE5Se8FXcAAJFx4.jpg | \n", "1 | \n", "kuvasz | \n", "0.309706 | \n", "True | \n", "Great_Pyrenees | \n", "0.186136 | \n", "True | \n", "Dandie_Dinmont | \n", "0.086346 | \n", "True | \n", "
2048 | \n", "886983233522544640 | \n", "https://pbs.twimg.com/media/DE8yicJW0AAAvBJ.jpg | \n", "2 | \n", "Chihuahua | \n", "0.793469 | \n", "True | \n", "toy_terrier | \n", "0.143528 | \n", "True | \n", "can_opener | \n", "0.032253 | \n", "False | \n", "
2049 | \n", "887101392804085760 | \n", "https://pbs.twimg.com/media/DE-eAq6UwAA-jaE.jpg | \n", "1 | \n", "Samoyed | \n", "0.733942 | \n", "True | \n", "Eskimo_dog | \n", "0.035029 | \n", "True | \n", "Staffordshire_bullterrier | \n", "0.029705 | \n", "True | \n", "
2050 | \n", "887343217045368832 | \n", "https://pbs.twimg.com/ext_tw_video_thumb/88734... | \n", "1 | \n", "Mexican_hairless | \n", "0.330741 | \n", "True | \n", "sea_lion | \n", "0.275645 | \n", "False | \n", "Weimaraner | \n", "0.134203 | \n", "True | \n", "
2051 | \n", "887473957103951883 | \n", "https://pbs.twimg.com/media/DFDw2tyUQAAAFke.jpg | \n", "2 | \n", "Pembroke | \n", "0.809197 | \n", "True | \n", "Rhodesian_ridgeback | \n", "0.054950 | \n", "True | \n", "beagle | \n", "0.038915 | \n", "True | \n", "
2052 | \n", "887517139158093824 | \n", "https://pbs.twimg.com/ext_tw_video_thumb/88751... | \n", "1 | \n", "limousine | \n", "0.130432 | \n", "False | \n", "tow_truck | \n", "0.029175 | \n", "False | \n", "shopping_cart | \n", "0.026321 | \n", "False | \n", "
2053 | \n", "887705289381826560 | \n", "https://pbs.twimg.com/media/DFHDQBbXgAEqY7t.jpg | \n", "1 | \n", "basset | \n", "0.821664 | \n", "True | \n", "redbone | \n", "0.087582 | \n", "True | \n", "Weimaraner | \n", "0.026236 | \n", "True | \n", "
2054 | \n", "888078434458587136 | \n", "https://pbs.twimg.com/media/DFMWn56WsAAkA7B.jpg | \n", "1 | \n", "French_bulldog | \n", "0.995026 | \n", "True | \n", "pug | \n", "0.000932 | \n", "True | \n", "bull_mastiff | \n", "0.000903 | \n", "True | \n", "
2055 | \n", "888202515573088257 | \n", "https://pbs.twimg.com/media/DFDw2tyUQAAAFke.jpg | \n", "2 | \n", "Pembroke | \n", "0.809197 | \n", "True | \n", "Rhodesian_ridgeback | \n", "0.054950 | \n", "True | \n", "beagle | \n", "0.038915 | \n", "True | \n", "
2056 | \n", "888554962724278272 | \n", "https://pbs.twimg.com/media/DFTH_O-UQAACu20.jpg | \n", "3 | \n", "Siberian_husky | \n", "0.700377 | \n", "True | \n", "Eskimo_dog | \n", "0.166511 | \n", "True | \n", "malamute | \n", "0.111411 | \n", "True | \n", "
2057 | \n", "888804989199671297 | \n", "https://pbs.twimg.com/media/DFWra-3VYAA2piG.jpg | \n", "1 | \n", "golden_retriever | \n", "0.469760 | \n", "True | \n", "Labrador_retriever | \n", "0.184172 | \n", "True | \n", "English_setter | \n", "0.073482 | \n", "True | \n", "
2058 | \n", "888917238123831296 | \n", "https://pbs.twimg.com/media/DFYRgsOUQAARGhO.jpg | \n", "1 | \n", "golden_retriever | \n", "0.714719 | \n", "True | \n", "Tibetan_mastiff | \n", "0.120184 | \n", "True | \n", "Labrador_retriever | \n", "0.105506 | \n", "True | \n", "
2059 | \n", "889278841981685760 | \n", "https://pbs.twimg.com/ext_tw_video_thumb/88927... | \n", "1 | \n", "whippet | \n", "0.626152 | \n", "True | \n", "borzoi | \n", "0.194742 | \n", "True | \n", "Saluki | \n", "0.027351 | \n", "True | \n", "
2060 | \n", "889531135344209921 | \n", "https://pbs.twimg.com/media/DFg_2PVW0AEHN3p.jpg | \n", "1 | \n", "golden_retriever | \n", "0.953442 | \n", "True | \n", "Labrador_retriever | \n", "0.013834 | \n", "True | \n", "redbone | \n", "0.007958 | \n", "True | \n", "
2061 | \n", "889638837579907072 | \n", "https://pbs.twimg.com/media/DFihzFfXsAYGDPR.jpg | \n", "1 | \n", "French_bulldog | \n", "0.991650 | \n", "True | \n", "boxer | \n", "0.002129 | \n", "True | \n", "Staffordshire_bullterrier | \n", "0.001498 | \n", "True | \n", "
2062 | \n", "889665388333682689 | \n", "https://pbs.twimg.com/media/DFi579UWsAAatzw.jpg | \n", "1 | \n", "Pembroke | \n", "0.966327 | \n", "True | \n", "Cardigan | \n", "0.027356 | \n", "True | \n", "basenji | \n", "0.004633 | \n", "True | \n", "
2063 | \n", "889880896479866881 | \n", "https://pbs.twimg.com/media/DFl99B1WsAITKsg.jpg | \n", "1 | \n", "French_bulldog | \n", "0.377417 | \n", "True | \n", "Labrador_retriever | \n", "0.151317 | \n", "True | \n", "muzzle | \n", "0.082981 | \n", "False | \n", "
2064 | \n", "890006608113172480 | \n", "https://pbs.twimg.com/media/DFnwSY4WAAAMliS.jpg | \n", "1 | \n", "Samoyed | \n", "0.957979 | \n", "True | \n", "Pomeranian | \n", "0.013884 | \n", "True | \n", "chow | \n", "0.008167 | \n", "True | \n", "
2065 | \n", "890240255349198849 | \n", "https://pbs.twimg.com/media/DFrEyVuW0AAO3t9.jpg | \n", "1 | \n", "Pembroke | \n", "0.511319 | \n", "True | \n", "Cardigan | \n", "0.451038 | \n", "True | \n", "Chihuahua | \n", "0.029248 | \n", "True | \n", "
2066 | \n", "890609185150312448 | \n", "https://pbs.twimg.com/media/DFwUU__XcAEpyXI.jpg | \n", "1 | \n", "Irish_terrier | \n", "0.487574 | \n", "True | \n", "Irish_setter | \n", "0.193054 | \n", "True | \n", "Chesapeake_Bay_retriever | \n", "0.118184 | \n", "True | \n", "
2067 | \n", "890729181411237888 | \n", "https://pbs.twimg.com/media/DFyBahAVwAAhUTd.jpg | \n", "2 | \n", "Pomeranian | \n", "0.566142 | \n", "True | \n", "Eskimo_dog | \n", "0.178406 | \n", "True | \n", "Pembroke | \n", "0.076507 | \n", "True | \n", "
2068 | \n", "890971913173991426 | \n", "https://pbs.twimg.com/media/DF1eOmZXUAALUcq.jpg | \n", "1 | \n", "Appenzeller | \n", "0.341703 | \n", "True | \n", "Border_collie | \n", "0.199287 | \n", "True | \n", "ice_lolly | \n", "0.193548 | \n", "False | \n", "
2069 | \n", "891087950875897856 | \n", "https://pbs.twimg.com/media/DF3HwyEWsAABqE6.jpg | \n", "1 | \n", "Chesapeake_Bay_retriever | \n", "0.425595 | \n", "True | \n", "Irish_terrier | \n", "0.116317 | \n", "True | \n", "Indian_elephant | \n", "0.076902 | \n", "False | \n", "
2070 | \n", "891327558926688256 | \n", "https://pbs.twimg.com/media/DF6hr6BUMAAzZgT.jpg | \n", "2 | \n", "basset | \n", "0.555712 | \n", "True | \n", "English_springer | \n", "0.225770 | \n", "True | \n", "German_short-haired_pointer | \n", "0.175219 | \n", "True | \n", "
2071 | \n", "891689557279858688 | \n", "https://pbs.twimg.com/media/DF_q7IAWsAEuuN8.jpg | \n", "1 | \n", "paper_towel | \n", "0.170278 | \n", "False | \n", "Labrador_retriever | \n", "0.168086 | \n", "True | \n", "spatula | \n", "0.040836 | \n", "False | \n", "
2072 | \n", "891815181378084864 | \n", "https://pbs.twimg.com/media/DGBdLU1WsAANxJ9.jpg | \n", "1 | \n", "Chihuahua | \n", "0.716012 | \n", "True | \n", "malamute | \n", "0.078253 | \n", "True | \n", "kelpie | \n", "0.031379 | \n", "True | \n", "
2073 | \n", "892177421306343426 | \n", "https://pbs.twimg.com/media/DGGmoV4XsAAUL6n.jpg | \n", "1 | \n", "Chihuahua | \n", "0.323581 | \n", "True | \n", "Pekinese | \n", "0.090647 | \n", "True | \n", "papillon | \n", "0.068957 | \n", "True | \n", "
2074 | \n", "892420643555336193 | \n", "https://pbs.twimg.com/media/DGKD1-bXoAAIAUK.jpg | \n", "1 | \n", "orange | \n", "0.097049 | \n", "False | \n", "bagel | \n", "0.085851 | \n", "False | \n", "banana | \n", "0.076110 | \n", "False | \n", "
2075 rows × 12 columns
\n", "\n", " | tweet_id | \n", "jpg_url | \n", "img_num | \n", "p1 | \n", "p1_conf | \n", "p1_dog | \n", "p2 | \n", "p2_conf | \n", "p2_dog | \n", "p3 | \n", "p3_conf | \n", "p3_dog | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|
1881 | \n", "847116187444137987 | \n", "https://pbs.twimg.com/media/C8GPrNDW4AAkLde.jpg | \n", "1 | \n", "white_wolf | \n", "0.128935 | \n", "False | \n", "American_Staffordshire_terrier | \n", "0.113434 | \n", "True | \n", "dingo | \n", "0.081231 | \n", "False | \n", "
1837 | \n", "837366284874571778 | \n", "https://pbs.twimg.com/media/C57sMJwXMAASBSx.jpg | \n", "1 | \n", "American_Staffordshire_terrier | \n", "0.660085 | \n", "True | \n", "Staffordshire_bullterrier | \n", "0.334947 | \n", "True | \n", "dalmatian | \n", "0.002697 | \n", "True | \n", "
995 | \n", "708149363256774660 | \n", "https://pbs.twimg.com/media/CdPaEkHW8AA-Wom.jpg | \n", "1 | \n", "Cardigan | \n", "0.350993 | \n", "True | \n", "basset | \n", "0.164555 | \n", "True | \n", "toy_terrier | \n", "0.080484 | \n", "True | \n", "
481 | \n", "675362609739206656 | \n", "https://pbs.twimg.com/media/CV9etctWUAAl5Hp.jpg | \n", "1 | \n", "Labrador_retriever | \n", "0.479008 | \n", "True | \n", "ice_bear | \n", "0.218289 | \n", "False | \n", "kuvasz | \n", "0.139911 | \n", "True | \n", "
1937 | \n", "860276583193509888 | \n", "https://pbs.twimg.com/media/C_BQ_NlVwAAgYGD.jpg | \n", "1 | \n", "lakeside | \n", "0.312299 | \n", "False | \n", "dock | \n", "0.159842 | \n", "False | \n", "canoe | \n", "0.070795 | \n", "False | \n", "
\n", " | tweet_id | \n", "retweet_count | \n", "favorite_count | \n", "
---|---|---|---|
0 | \n", "892420643555336193 | \n", "6979 | \n", "33728 | \n", "
1 | \n", "892177421306343426 | \n", "5280 | \n", "29255 | \n", "
2 | \n", "891815181378084864 | \n", "3466 | \n", "21987 | \n", "
3 | \n", "891689557279858688 | \n", "7198 | \n", "36823 | \n", "
4 | \n", "891327558926688256 | \n", "7723 | \n", "35207 | \n", "
\n", " | tweet_id | \n", "retweet_count | \n", "favorite_count | \n", "
---|---|---|---|
count | \n", "2.326000e+03 | \n", "2326.000000 | \n", "2326.000000 | \n", "
mean | \n", "7.417480e+17 | \n", "2457.867154 | \n", "7018.926913 | \n", "
std | \n", "6.818802e+16 | \n", "4166.197661 | \n", "10908.789726 | \n", "
min | \n", "6.660209e+17 | \n", "1.000000 | \n", "0.000000 | \n", "
25% | \n", "6.780814e+17 | \n", "492.250000 | \n", "1219.500000 | \n", "
50% | \n", "7.178159e+17 | \n", "1145.500000 | \n", "3040.500000 | \n", "
75% | \n", "7.986402e+17 | \n", "2843.500000 | \n", "8562.750000 | \n", "
max | \n", "8.924206e+17 | \n", "70429.000000 | \n", "144312.000000 | \n", "
\n", " | tweet_id | \n", "in_reply_to_status_id | \n", "in_reply_to_user_id | \n", "timestamp | \n", "source | \n", "text | \n", "retweeted_status_id | \n", "retweeted_status_user_id | \n", "retweeted_status_timestamp | \n", "expanded_urls | \n", "rating_numerator | \n", "rating_denominator | \n", "name | \n", "doggo | \n", "floofer | \n", "pupper | \n", "puppo | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
623 | \n", "False | \n", "True | \n", "True | \n", "False | \n", "False | \n", "False | \n", "True | \n", "True | \n", "True | \n", "False | \n", "False | \n", "False | \n", "False | \n", "True | \n", "True | \n", "True | \n", "True | \n", "
889 | \n", "False | \n", "True | \n", "True | \n", "False | \n", "False | \n", "False | \n", "True | \n", "True | \n", "True | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "True | \n", "False | \n", "True | \n", "
976 | \n", "False | \n", "True | \n", "True | \n", "False | \n", "False | \n", "False | \n", "True | \n", "True | \n", "True | \n", "False | \n", "False | \n", "False | \n", "False | \n", "True | \n", "True | \n", "True | \n", "True | \n", "
113 | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "True | \n", "True | \n", "True | \n", "True | \n", "False | \n", "False | \n", "True | \n", "True | \n", "True | \n", "True | \n", "True | \n", "
639 | \n", "False | \n", "True | \n", "True | \n", "False | \n", "False | \n", "False | \n", "True | \n", "True | \n", "True | \n", "False | \n", "False | \n", "False | \n", "True | \n", "True | \n", "True | \n", "True | \n", "True | \n", "
2036 | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "True | \n", "True | \n", "True | \n", "False | \n", "False | \n", "False | \n", "True | \n", "True | \n", "True | \n", "True | \n", "True | \n", "
574 | \n", "False | \n", "True | \n", "True | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "False | \n", "True | \n", "True | \n", "True | \n", "
1412 | \n", "False | \n", "True | \n", "True | \n", "False | \n", "False | \n", "False | \n", "True | \n", "True | \n", "True | \n", "False | \n", "False | \n", "False | \n", "False | \n", "True | \n", "True | \n", "True | \n", "True | \n", "
1756 | \n", "False | \n", "True | \n", "True | \n", "False | \n", "False | \n", "False | \n", "True | \n", "True | \n", "True | \n", "False | \n", "False | \n", "False | \n", "False | \n", "True | \n", "True | \n", "True | \n", "True | \n", "
1707 | \n", "False | \n", "True | \n", "True | \n", "False | \n", "False | \n", "False | \n", "True | \n", "True | \n", "True | \n", "False | \n", "False | \n", "False | \n", "True | \n", "True | \n", "True | \n", "True | \n", "True | \n", "
\n", " | tweet_id | \n", "in_reply_to_status_id | \n", "in_reply_to_user_id | \n", "timestamp | \n", "source | \n", "text | \n", "retweeted_status_id | \n", "retweeted_status_user_id | \n", "retweeted_status_timestamp | \n", "expanded_urls | \n", "rating_numerator | \n", "rating_denominator | \n", "name | \n", "doggo | \n", "floofer | \n", "pupper | \n", "puppo | \n", "
---|
\n", " | tweet_id | \n", "jpg_url | \n", "dog_breed | \n", "timestamp | \n", "text | \n", "rating_numerator | \n", "rating_denominator | \n", "name | \n", "dog_stage | \n", "retweet_count | \n", "favorite_count | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|
0 | \n", "666020888022790149 | \n", "https://pbs.twimg.com/media/CT4udn0WwAA0aMy.jpg | \n", "Welsh_springer_spaniel | \n", "2015-11-15 22:32:08 +0000 | \n", "Here we have a Japanese Irish Setter. Lost eye... | \n", "8.0 | \n", "10.0 | \n", "NaN | \n", "NaN | \n", "421.0 | \n", "2285.0 | \n", "
1 | \n", "666029285002620928 | \n", "https://pbs.twimg.com/media/CT42GRgUYAA5iDo.jpg | \n", "redbone | \n", "2015-11-15 23:05:30 +0000 | \n", "This is a western brown Mitsubishi terrier. Up... | \n", "7.0 | \n", "10.0 | \n", "NaN | \n", "NaN | \n", "39.0 | \n", "112.0 | \n", "
2 | \n", "666033412701032449 | \n", "https://pbs.twimg.com/media/CT4521TWwAEvMyu.jpg | \n", "German_shepherd | \n", "2015-11-15 23:21:54 +0000 | \n", "Here is a very happy pup. Big fan of well-main... | \n", "9.0 | \n", "10.0 | \n", "NaN | \n", "NaN | \n", "36.0 | \n", "100.0 | \n", "
3 | \n", "666044226329800704 | \n", "https://pbs.twimg.com/media/CT5Dr8HUEAA-lEu.jpg | \n", "Rhodesian_ridgeback | \n", "2015-11-16 00:04:52 +0000 | \n", "This is a purebred Piers Morgan. Loves to Netf... | \n", "6.0 | \n", "10.0 | \n", "NaN | \n", "NaN | \n", "115.0 | \n", "245.0 | \n", "
4 | \n", "666049248165822465 | \n", "https://pbs.twimg.com/media/CT5IQmsXIAAKY4A.jpg | \n", "miniature_pinscher | \n", "2015-11-16 00:24:50 +0000 | \n", "Here we have a 1949 1st generation vulpix. Enj... | \n", "5.0 | \n", "10.0 | \n", "NaN | \n", "NaN | \n", "36.0 | \n", "88.0 | \n", "
5 | \n", "666050758794694657 | \n", "https://pbs.twimg.com/media/CT5Jof1WUAEuVxN.jpg | \n", "Bernese_mountain_dog | \n", "2015-11-16 00:30:50 +0000 | \n", "This is a truly beautiful English Wilson Staff... | \n", "10.0 | \n", "10.0 | \n", "NaN | \n", "NaN | \n", "50.0 | \n", "115.0 | \n", "
6 | \n", "666055525042405380 | \n", "https://pbs.twimg.com/media/CT5N9tpXIAAifs1.jpg | \n", "chow | \n", "2015-11-16 00:49:46 +0000 | \n", "Here is a Siberian heavily armored polar bear ... | \n", "10.0 | \n", "10.0 | \n", "NaN | \n", "NaN | \n", "196.0 | \n", "367.0 | \n", "
7 | \n", "666057090499244032 | \n", "https://pbs.twimg.com/media/CT5PY90WoAAQGLo.jpg | \n", "golden_retriever | \n", "2015-11-16 00:55:59 +0000 | \n", "My oh my. This is a rare blond Canadian terrie... | \n", "9.0 | \n", "10.0 | \n", "NaN | \n", "NaN | \n", "112.0 | \n", "247.0 | \n", "
8 | \n", "666058600524156928 | \n", "https://pbs.twimg.com/media/CT5Qw94XAAA_2dP.jpg | \n", "miniature_poodle | \n", "2015-11-16 01:01:59 +0000 | \n", "Here is the Rand Paul of retrievers folks! He'... | \n", "8.0 | \n", "10.0 | \n", "NaN | \n", "NaN | \n", "47.0 | \n", "99.0 | \n", "
9 | \n", "666063827256086533 | \n", "https://pbs.twimg.com/media/CT5Vg_wXIAAXfnj.jpg | \n", "golden_retriever | \n", "2015-11-16 01:22:45 +0000 | \n", "This is the happiest dog you will ever see. Ve... | \n", "10.0 | \n", "10.0 | \n", "NaN | \n", "NaN | \n", "180.0 | \n", "395.0 | \n", "
10 | \n", "666071193221509120 | \n", "https://pbs.twimg.com/media/CT5cN_3WEAAlOoZ.jpg | \n", "Gordon_setter | \n", "2015-11-16 01:52:02 +0000 | \n", "Here we have a northern speckled Rhododendron.... | \n", "9.0 | \n", "10.0 | \n", "NaN | \n", "NaN | \n", "51.0 | \n", "127.0 | \n", "
11 | \n", "666073100786774016 | \n", "https://pbs.twimg.com/media/CT5d9DZXAAALcwe.jpg | \n", "Walker_hound | \n", "2015-11-16 01:59:36 +0000 | \n", "Let's hope this flight isn't Malaysian (lol). ... | \n", "10.0 | \n", "10.0 | \n", "NaN | \n", "NaN | \n", "130.0 | \n", "274.0 | \n", "
12 | \n", "666082916733198337 | \n", "https://pbs.twimg.com/media/CT5m4VGWEAAtKc8.jpg | \n", "pug | \n", "2015-11-16 02:38:37 +0000 | \n", "Here we have a well-established sunblockerspan... | \n", "6.0 | \n", "10.0 | \n", "NaN | \n", "NaN | \n", "37.0 | \n", "92.0 | \n", "
13 | \n", "666094000022159362 | \n", "https://pbs.twimg.com/media/CT5w9gUW4AAsBNN.jpg | \n", "bloodhound | \n", "2015-11-16 03:22:39 +0000 | \n", "This appears to be a Mongolian Presbyterian mi... | \n", "9.0 | \n", "10.0 | \n", "NaN | \n", "NaN | \n", "63.0 | \n", "142.0 | \n", "
14 | \n", "666099513787052032 | \n", "https://pbs.twimg.com/media/CT51-JJUEAA6hV8.jpg | \n", "Lhasa | \n", "2015-11-16 03:44:34 +0000 | \n", "Can stand on stump for what seems like a while... | \n", "8.0 | \n", "10.0 | \n", "NaN | \n", "NaN | \n", "53.0 | \n", "133.0 | \n", "
15 | \n", "666102155909144576 | \n", "https://pbs.twimg.com/media/CT54YGiWUAEZnoK.jpg | \n", "English_setter | \n", "2015-11-16 03:55:04 +0000 | \n", "Oh my. Here you are seeing an Adobe Setter giv... | \n", "11.0 | \n", "10.0 | \n", "NaN | \n", "NaN | \n", "11.0 | \n", "66.0 | \n", "
16 | \n", "666273097616637952 | \n", "https://pbs.twimg.com/media/CT8T1mtUwAA3aqm.jpg | \n", "Italian_greyhound | \n", "2015-11-16 15:14:19 +0000 | \n", "Can take selfies 11/10 https://t.co/ws2AMaNwPW | \n", "11.0 | \n", "10.0 | \n", "NaN | \n", "NaN | \n", "66.0 | \n", "151.0 | \n", "
17 | \n", "666287406224695296 | \n", "https://pbs.twimg.com/media/CT8g3BpUEAAuFjg.jpg | \n", "Maltese_dog | \n", "2015-11-16 16:11:11 +0000 | \n", "This is an Albanian 3 1/2 legged Episcopalian... | \n", "1.0 | \n", "2.0 | \n", "NaN | \n", "NaN | \n", "56.0 | \n", "123.0 | \n", "
18 | \n", "666337882303524864 | \n", "https://pbs.twimg.com/media/CT9OwFIWEAMuRje.jpg | \n", "Newfoundland | \n", "2015-11-16 19:31:45 +0000 | \n", "This is an extremely rare horned Parthenon. No... | \n", "9.0 | \n", "10.0 | \n", "NaN | \n", "NaN | \n", "79.0 | \n", "168.0 | \n", "
19 | \n", "666345417576210432 | \n", "https://pbs.twimg.com/media/CT9Vn7PWoAA_ZCM.jpg | \n", "golden_retriever | \n", "2015-11-16 20:01:42 +0000 | \n", "Look at this jokester thinking seat belt laws ... | \n", "10.0 | \n", "10.0 | \n", "NaN | \n", "NaN | \n", "122.0 | \n", "241.0 | \n", "
20 | \n", "666353288456101888 | \n", "https://pbs.twimg.com/media/CT9cx0tUEAAhNN_.jpg | \n", "malamute | \n", "2015-11-16 20:32:58 +0000 | \n", "Here we have a mixed Asiago from the Galápagos... | \n", "8.0 | \n", "10.0 | \n", "NaN | \n", "NaN | \n", "56.0 | \n", "179.0 | \n", "
21 | \n", "666373753744588802 | \n", "https://pbs.twimg.com/media/CT9vZEYWUAAlZ05.jpg | \n", "soft-coated_wheaten_terrier | \n", "2015-11-16 21:54:18 +0000 | \n", "Those are sunglasses and a jean jacket. 11/10 ... | \n", "11.0 | \n", "10.0 | \n", "NaN | \n", "NaN | \n", "73.0 | \n", "162.0 | \n", "
22 | \n", "666396247373291520 | \n", "https://pbs.twimg.com/media/CT-D2ZHWIAA3gK1.jpg | \n", "Chihuahua | \n", "2015-11-16 23:23:41 +0000 | \n", "Oh goodness. A super rare northeast Qdoba kang... | \n", "9.0 | \n", "10.0 | \n", "NaN | \n", "NaN | \n", "68.0 | \n", "147.0 | \n", "
23 | \n", "666407126856765440 | \n", "https://pbs.twimg.com/media/CT-NvwmW4AAugGZ.jpg | \n", "black-and-tan_coonhound | \n", "2015-11-17 00:06:54 +0000 | \n", "This is a southern Vesuvius bumblegruff. Can d... | \n", "7.0 | \n", "10.0 | \n", "NaN | \n", "NaN | \n", "30.0 | \n", "93.0 | \n", "
24 | \n", "666418789513326592 | \n", "https://pbs.twimg.com/media/CT-YWb7U8AA7QnN.jpg | \n", "toy_terrier | \n", "2015-11-17 00:53:15 +0000 | \n", "This is Walter. He is an Alaskan Terrapin. Lov... | \n", "10.0 | \n", "10.0 | \n", "Walter | \n", "NaN | \n", "39.0 | \n", "107.0 | \n", "
25 | \n", "666421158376562688 | \n", "https://pbs.twimg.com/media/CT-aggCXAAIMfT3.jpg | \n", "Blenheim_spaniel | \n", "2015-11-17 01:02:40 +0000 | \n", "*internally screaming* 12/10 https://t.co/YMcr... | \n", "12.0 | \n", "10.0 | \n", "NaN | \n", "NaN | \n", "91.0 | \n", "272.0 | \n", "
26 | \n", "666428276349472768 | \n", "https://pbs.twimg.com/media/CT-g-0DUwAEQdSn.jpg | \n", "Pembroke | \n", "2015-11-17 01:30:57 +0000 | \n", "Here we have an Austrian Pulitzer. Collectors ... | \n", "7.0 | \n", "10.0 | \n", "NaN | \n", "NaN | \n", "67.0 | \n", "139.0 | \n", "
27 | \n", "666430724426358785 | \n", "https://pbs.twimg.com/media/CT-jNYqW4AAPi2M.jpg | \n", "Irish_terrier | \n", "2015-11-17 01:40:41 +0000 | \n", "Oh boy what a pup! Sunglasses take this one to... | \n", "6.0 | \n", "10.0 | \n", "NaN | \n", "NaN | \n", "160.0 | \n", "276.0 | \n", "
28 | \n", "666435652385423360 | \n", "https://pbs.twimg.com/media/CT-nsTQWEAEkyDn.jpg | \n", "Chesapeake_Bay_retriever | \n", "2015-11-17 02:00:15 +0000 | \n", "\"Can you behave? You're ruining my wedding day... | \n", "10.0 | \n", "10.0 | \n", "NaN | \n", "NaN | \n", "42.0 | \n", "137.0 | \n", "
29 | \n", "666437273139982337 | \n", "https://pbs.twimg.com/media/CT-pKmRWIAAxUWj.jpg | \n", "Chihuahua | \n", "2015-11-17 02:06:42 +0000 | \n", "Here we see a lone northeastern Cumberbatch. H... | \n", "7.0 | \n", "10.0 | \n", "NaN | \n", "NaN | \n", "40.0 | \n", "106.0 | \n", "
... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "
1721 | \n", "885528943205470208 | \n", "https://pbs.twimg.com/media/DEoH3yvXgAAzQtS.jpg | \n", "pug | \n", "2017-07-13 15:58:47 +0000 | \n", "This is Maisey. She fell asleep mid-excavation... | \n", "13.0 | \n", "10.0 | \n", "Maisey | \n", "NaN | \n", "5311.0 | \n", "31522.0 | \n", "
1722 | \n", "885984800019947520 | \n", "https://pbs.twimg.com/media/DEumeWWV0AA-Z61.jpg | \n", "Blenheim_spaniel | \n", "2017-07-14 22:10:11 +0000 | \n", "Viewer discretion advised. This is Jimbo. He w... | \n", "12.0 | \n", "10.0 | \n", "Jimbo | \n", "NaN | \n", "5592.0 | \n", "28526.0 | \n", "
1723 | \n", "886258384151887873 | \n", "https://pbs.twimg.com/media/DEyfTG4UMAE4aE9.jpg | \n", "pug | \n", "2017-07-15 16:17:19 +0000 | \n", "This is Waffles. His doggles are pupside down.... | \n", "13.0 | \n", "10.0 | \n", "Waffles | \n", "NaN | \n", "5262.0 | \n", "24459.0 | \n", "
1724 | \n", "886366144734445568 | \n", "https://pbs.twimg.com/media/DE0BTnQUwAApKEH.jpg | \n", "French_bulldog | \n", "2017-07-15 23:25:31 +0000 | \n", "This is Roscoe. Another pupper fallen victim t... | \n", "12.0 | \n", "10.0 | \n", "Roscoe | \n", "pupper | \n", "2614.0 | \n", "18501.0 | \n", "
1725 | \n", "886736880519319552 | \n", "https://pbs.twimg.com/media/DE5Se8FXcAAJFx4.jpg | \n", "kuvasz | \n", "2017-07-16 23:58:41 +0000 | \n", "This is Mingus. He's a wonderful father to his... | \n", "13.0 | \n", "10.0 | \n", "Mingus | \n", "NaN | \n", "2619.0 | \n", "10466.0 | \n", "
1726 | \n", "886983233522544640 | \n", "https://pbs.twimg.com/media/DE8yicJW0AAAvBJ.jpg | \n", "Chihuahua | \n", "2017-07-17 16:17:36 +0000 | \n", "This is Maya. She's very shy. Rarely leaves he... | \n", "13.0 | \n", "10.0 | \n", "Maya | \n", "NaN | \n", "6294.0 | \n", "30275.0 | \n", "
1727 | \n", "887101392804085760 | \n", "https://pbs.twimg.com/media/DE-eAq6UwAA-jaE.jpg | \n", "Samoyed | \n", "2017-07-18 00:07:08 +0000 | \n", "This... is a Jubilant Antarctic House Bear. We... | \n", "12.0 | \n", "10.0 | \n", "NaN | \n", "NaN | \n", "4975.0 | \n", "26916.0 | \n", "
1728 | \n", "887343217045368832 | \n", "https://pbs.twimg.com/ext_tw_video_thumb/88734... | \n", "Mexican_hairless | \n", "2017-07-18 16:08:03 +0000 | \n", "You may not have known you needed to see this ... | \n", "13.0 | \n", "10.0 | \n", "NaN | \n", "NaN | \n", "8788.0 | \n", "29515.0 | \n", "
1729 | \n", "887473957103951883 | \n", "https://pbs.twimg.com/media/DFDw2tyUQAAAFke.jpg | \n", "Pembroke | \n", "2017-07-19 00:47:34 +0000 | \n", "This is Canela. She attempted some fancy porch... | \n", "13.0 | \n", "10.0 | \n", "Canela | \n", "NaN | \n", "14973.0 | \n", "60028.0 | \n", "
1730 | \n", "887705289381826560 | \n", "https://pbs.twimg.com/media/DFHDQBbXgAEqY7t.jpg | \n", "basset | \n", "2017-07-19 16:06:48 +0000 | \n", "This is Jeffrey. He has a monopoly on the pool... | \n", "13.0 | \n", "10.0 | \n", "Jeffrey | \n", "NaN | \n", "4522.0 | \n", "26553.0 | \n", "
1731 | \n", "888078434458587136 | \n", "https://pbs.twimg.com/media/DFMWn56WsAAkA7B.jpg | \n", "French_bulldog | \n", "2017-07-20 16:49:33 +0000 | \n", "This is Gerald. He was just told he didn't get... | \n", "12.0 | \n", "10.0 | \n", "Gerald | \n", "NaN | \n", "2886.0 | \n", "19115.0 | \n", "
1732 | \n", "888202515573088257 | \n", "https://pbs.twimg.com/media/DFDw2tyUQAAAFke.jpg | \n", "Pembroke | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "
1733 | \n", "888554962724278272 | \n", "https://pbs.twimg.com/media/DFTH_O-UQAACu20.jpg | \n", "Siberian_husky | \n", "2017-07-22 00:23:06 +0000 | \n", "This is Ralphus. He's powering up. Attempting ... | \n", "13.0 | \n", "10.0 | \n", "Ralphus | \n", "NaN | \n", "2868.0 | \n", "17266.0 | \n", "
1734 | \n", "888804989199671297 | \n", "https://pbs.twimg.com/media/DFWra-3VYAA2piG.jpg | \n", "golden_retriever | \n", "2017-07-22 16:56:37 +0000 | \n", "This is Zeke. He has a new stick. Very proud o... | \n", "13.0 | \n", "10.0 | \n", "Zeke | \n", "NaN | \n", "3518.0 | \n", "22409.0 | \n", "
1735 | \n", "888917238123831296 | \n", "https://pbs.twimg.com/media/DFYRgsOUQAARGhO.jpg | \n", "golden_retriever | \n", "2017-07-23 00:22:39 +0000 | \n", "This is Jim. He found a fren. Taught him how t... | \n", "12.0 | \n", "10.0 | \n", "Jim | \n", "NaN | \n", "3747.0 | \n", "25551.0 | \n", "
1736 | \n", "889278841981685760 | \n", "https://pbs.twimg.com/ext_tw_video_thumb/88927... | \n", "whippet | \n", "2017-07-24 00:19:32 +0000 | \n", "This is Oliver. You're witnessing one of his m... | \n", "13.0 | \n", "10.0 | \n", "Oliver | \n", "NaN | \n", "4426.0 | \n", "22052.0 | \n", "
1737 | \n", "889531135344209921 | \n", "https://pbs.twimg.com/media/DFg_2PVW0AEHN3p.jpg | \n", "golden_retriever | \n", "2017-07-24 17:02:04 +0000 | \n", "This is Stuart. He's sporting his favorite fan... | \n", "13.0 | \n", "10.0 | \n", "Stuart | \n", "puppo | \n", "1874.0 | \n", "13321.0 | \n", "
1738 | \n", "889638837579907072 | \n", "https://pbs.twimg.com/media/DFihzFfXsAYGDPR.jpg | \n", "French_bulldog | \n", "2017-07-25 00:10:02 +0000 | \n", "This is Ted. He does his best. Sometimes that'... | \n", "12.0 | \n", "10.0 | \n", "Ted | \n", "NaN | \n", "3702.0 | \n", "23605.0 | \n", "
1739 | \n", "889665388333682689 | \n", "https://pbs.twimg.com/media/DFi579UWsAAatzw.jpg | \n", "Pembroke | \n", "2017-07-25 01:55:32 +0000 | \n", "Here's a puppo that seems to be on the fence a... | \n", "13.0 | \n", "10.0 | \n", "NaN | \n", "puppo | \n", "8312.0 | \n", "41910.0 | \n", "
1740 | \n", "889880896479866881 | \n", "https://pbs.twimg.com/media/DFl99B1WsAITKsg.jpg | \n", "French_bulldog | \n", "2017-07-25 16:11:53 +0000 | \n", "This is Bruno. He is a service shark. Only get... | \n", "13.0 | \n", "10.0 | \n", "Bruno | \n", "NaN | \n", "4145.0 | \n", "24506.0 | \n", "
1741 | \n", "890006608113172480 | \n", "https://pbs.twimg.com/media/DFnwSY4WAAAMliS.jpg | \n", "Samoyed | \n", "2017-07-26 00:31:25 +0000 | \n", "This is Koda. He is a South Australian decksha... | \n", "13.0 | \n", "10.0 | \n", "Koda | \n", "NaN | \n", "6120.0 | \n", "26973.0 | \n", "
1742 | \n", "890240255349198849 | \n", "https://pbs.twimg.com/media/DFrEyVuW0AAO3t9.jpg | \n", "Pembroke | \n", "2017-07-26 15:59:51 +0000 | \n", "This is Cassie. She is a college pup. Studying... | \n", "14.0 | \n", "10.0 | \n", "Cassie | \n", "doggo | \n", "6081.0 | \n", "27878.0 | \n", "
1743 | \n", "890609185150312448 | \n", "https://pbs.twimg.com/media/DFwUU__XcAEpyXI.jpg | \n", "Irish_terrier | \n", "2017-07-27 16:25:51 +0000 | \n", "This is Zoey. She doesn't want to be one of th... | \n", "13.0 | \n", "10.0 | \n", "Zoey | \n", "NaN | \n", "3605.0 | \n", "24455.0 | \n", "
1744 | \n", "890729181411237888 | \n", "https://pbs.twimg.com/media/DFyBahAVwAAhUTd.jpg | \n", "Pomeranian | \n", "2017-07-28 00:22:40 +0000 | \n", "When you watch your owner call another dog a g... | \n", "13.0 | \n", "10.0 | \n", "NaN | \n", "NaN | \n", "15695.0 | \n", "56701.0 | \n", "
1745 | \n", "890971913173991426 | \n", "https://pbs.twimg.com/media/DF1eOmZXUAALUcq.jpg | \n", "Appenzeller | \n", "2017-07-28 16:27:12 +0000 | \n", "Meet Jax. He enjoys ice cream so much he gets ... | \n", "13.0 | \n", "10.0 | \n", "Jax | \n", "NaN | \n", "1649.0 | \n", "10340.0 | \n", "
1746 | \n", "891087950875897856 | \n", "https://pbs.twimg.com/media/DF3HwyEWsAABqE6.jpg | \n", "Chesapeake_Bay_retriever | \n", "2017-07-29 00:08:17 +0000 | \n", "Here we have a majestic great white breaching ... | \n", "13.0 | \n", "10.0 | \n", "NaN | \n", "NaN | \n", "2590.0 | \n", "17757.0 | \n", "
1747 | \n", "891327558926688256 | \n", "https://pbs.twimg.com/media/DF6hr6BUMAAzZgT.jpg | \n", "basset | \n", "2017-07-29 16:00:24 +0000 | \n", "This is Franklin. He would like you to stop ca... | \n", "12.0 | \n", "10.0 | \n", "Franklin | \n", "NaN | \n", "7723.0 | \n", "35207.0 | \n", "
1748 | \n", "891689557279858688 | \n", "https://pbs.twimg.com/media/DF_q7IAWsAEuuN8.jpg | \n", "Labrador_retriever | \n", "2017-07-30 15:58:51 +0000 | \n", "This is Darla. She commenced a snooze mid meal... | \n", "13.0 | \n", "10.0 | \n", "Darla | \n", "NaN | \n", "7198.0 | \n", "36823.0 | \n", "
1749 | \n", "891815181378084864 | \n", "https://pbs.twimg.com/media/DGBdLU1WsAANxJ9.jpg | \n", "Chihuahua | \n", "2017-07-31 00:18:03 +0000 | \n", "This is Archie. He is a rare Norwegian Pouncin... | \n", "12.0 | \n", "10.0 | \n", "Archie | \n", "NaN | \n", "3466.0 | \n", "21987.0 | \n", "
1750 | \n", "892177421306343426 | \n", "https://pbs.twimg.com/media/DGGmoV4XsAAUL6n.jpg | \n", "Chihuahua | \n", "2017-08-01 00:17:27 +0000 | \n", "This is Tilly. She's just checking pup on you.... | \n", "13.0 | \n", "10.0 | \n", "Tilly | \n", "NaN | \n", "5280.0 | \n", "29255.0 | \n", "
1751 rows × 11 columns
\n", "\n", " | index | \n", "tweet_id | \n", "rating_numerator | \n", "rating_denominator | \n", "retweet_count | \n", "favorite_count | \n", "
---|---|---|---|---|---|---|
count | \n", "1658.000000 | \n", "1.658000e+03 | \n", "1658.000000 | \n", "1658.000000 | \n", "1657.000000 | \n", "1657.000000 | \n", "
mean | \n", "1048.162847 | \n", "7.392385e+17 | \n", "11.385404 | \n", "10.471049 | \n", "2283.746530 | \n", "8004.847314 | \n", "
std | \n", "594.020413 | \n", "6.794971e+16 | \n", "7.506534 | \n", "6.359152 | \n", "4158.936293 | \n", "11787.806358 | \n", "
min | \n", "0.000000 | \n", "6.660209e+17 | \n", "0.000000 | \n", "2.000000 | \n", "11.000000 | \n", "66.000000 | \n", "
25% | \n", "548.250000 | \n", "6.773835e+17 | \n", "10.000000 | \n", "10.000000 | \n", "514.000000 | \n", "1806.000000 | \n", "
50% | \n", "1049.500000 | \n", "7.138309e+17 | \n", "11.000000 | \n", "10.000000 | \n", "1131.000000 | \n", "3723.000000 | \n", "
75% | \n", "1552.750000 | \n", "7.931619e+17 | \n", "12.000000 | \n", "10.000000 | \n", "2587.000000 | \n", "9904.000000 | \n", "
max | \n", "2073.000000 | \n", "8.921774e+17 | \n", "165.000000 | \n", "150.000000 | \n", "70429.000000 | \n", "144312.000000 | \n", "
\n", " | index | \n", "tweet_id | \n", "jpg_url | \n", "dog_breed | \n", "text | \n", "rating_numerator | \n", "rating_denominator | \n", "name | \n", "dog_stage | \n", "retweet_count | \n", "favorite_count | \n", "rating | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|
1455 | \n", "1824 | \n", "835152434251116546 | \n", "https://pbs.twimg.com/media/C5cOtWVWMAEjO5p.jpg | \n", "American_Staffordshire_terrier | \n", "When you're so blinded by your systematic plag... | \n", "0 | \n", "10 | \n", "NaN | \n", "NaN | \n", "2755.0 | \n", "20923.0 | \n", "0.0 | \n", "
\n", " | index | \n", "tweet_id | \n", "jpg_url | \n", "dog_breed | \n", "text | \n", "rating_numerator | \n", "rating_denominator | \n", "name | \n", "dog_stage | \n", "retweet_count | \n", "favorite_count | \n", "rating | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|
978 | \n", "1221 | \n", "744234799360020481 | \n", "https://pbs.twimg.com/ext_tw_video_thumb/74423... | \n", "Labrador_retriever | \n", "Here's a doggo realizing you can stand in a po... | \n", "13 | \n", "10 | \n", "NaN | \n", "doggo | \n", "70429.0 | \n", "144312.0 | \n", "130.0 | \n", "