{ "cells": [ { "cell_type": "markdown", "metadata": {}, "source": [ "# Project 02 - Wrangle and Analyze Data\n", "\n", "##### Student Tags\n", "\n", "Author: Anderson Hitoshi Uyekita \n", "Project: Wrangle and Analyze Data \n", "Course: Data Science - Foundations II \n", "COD: ND111 \n", "Date: 02/01/2019 \n", "Version: 2.0\n", "\n", "***\n", "\n", "## Table of Contents\n", "
| \n", " | contributors | \n", "coordinates | \n", "created_at | \n", "display_text_range | \n", "entities | \n", "extended_entities | \n", "favorite_count | \n", "favorited | \n", "full_text | \n", "geo | \n", "... | \n", "quoted_status | \n", "quoted_status_id | \n", "quoted_status_id_str | \n", "quoted_status_permalink | \n", "retweet_count | \n", "retweeted | \n", "retweeted_status | \n", "source | \n", "truncated | \n", "user | \n", "
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1998-04-12 22:37:23.555336193 | \n", "NaN | \n", "NaN | \n", "2017-08-01 16:23:56 | \n", "[0, 85] | \n", "{'hashtags': [], 'symbols': [], 'user_mentions... | \n", "{'media': [{'id': 892420639486877696, 'id_str'... | \n", "38075 | \n", "0 | \n", "This is Phineas. He's a mystical boy. Only eve... | \n", "NaN | \n", "... | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "8328 | \n", "0 | \n", "NaN | \n", "<a href=\"http://twitter.com/download/iphone\" r... | \n", "0 | \n", "{'id': 4196983835, 'id_str': '4196983835', 'na... | \n", "
| 1998-04-10 03:03:41.306343426 | \n", "NaN | \n", "NaN | \n", "2017-08-01 00:17:27 | \n", "[0, 138] | \n", "{'hashtags': [], 'symbols': [], 'user_mentions... | \n", "{'media': [{'id': 892177413194625024, 'id_str'... | \n", "32680 | \n", "0 | \n", "This is Tilly. She's just checking pup on you.... | \n", "NaN | \n", "... | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "6151 | \n", "0 | \n", "NaN | \n", "<a href=\"http://twitter.com/download/iphone\" r... | \n", "0 | \n", "{'id': 4196983835, 'id_str': '4196983835', 'na... | \n", "
2 rows × 32 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", "
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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", "
| \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", "
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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", "
| \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", "
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 97 | \n", "873337748698140672 | \n", "NaN | \n", "NaN | \n", "2017-06-10 00:35:19 +0000 | \n", "<a href=\"http://twitter.com/download/iphone\" r... | \n", "RT @dog_rates: This is Sierra. She's one preci... | \n", "8.732138e+17 | \n", "4.196984e+09 | \n", "2017-06-09 16:22:42 +0000 | \n", "https://www.gofundme.com/help-my-baby-sierra-g... | \n", "12 | \n", "10 | \n", "Sierra | \n", "None | \n", "None | \n", "pupper | \n", "None | \n", "
| 98 | \n", "873213775632977920 | \n", "NaN | \n", "NaN | \n", "2017-06-09 16:22:42 +0000 | \n", "<a href=\"http://twitter.com/download/iphone\" r... | \n", "This is Sierra. She's one precious pupper. Abs... | \n", "NaN | \n", "NaN | \n", "NaN | \n", "https://www.gofundme.com/help-my-baby-sierra-g... | \n", "12 | \n", "10 | \n", "Sierra | \n", "None | \n", "None | \n", "pupper | \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", "
| 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", "
| \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", "
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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", "
| \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", "... | \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", "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", "... | \n", "1 | \n", "orange | \n", "0.097049 | \n", "False | \n", "bagel | \n", "0.085851 | \n", "False | \n", "banana | \n", "0.076110 | \n", "False | \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", "... | \n", "1 | \n", "Chihuahua | \n", "0.323581 | \n", "True | \n", "Pekinese | \n", "0.090647 | \n", "True | \n", "papillon | \n", "0.068957 | \n", "True | \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", "... | \n", "1 | \n", "Chihuahua | \n", "0.716012 | \n", "True | \n", "malamute | \n", "0.078253 | \n", "True | \n", "kelpie | \n", "0.031379 | \n", "True | \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", "... | \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", "
| 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", "... | \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", "
5 rows × 28 columns
\n", "| \n", " | tweet_id | \n", "source | \n", "source_url | \n", "
|---|---|---|---|
| 0 | \n", "892420643555336193 | \n", "Twitter for iPhone | \n", "http://twitter.com/download/iphone | \n", "
| 1 | \n", "892177421306343426 | \n", "Twitter for iPhone | \n", "http://twitter.com/download/iphone | \n", "
| 2 | \n", "891815181378084864 | \n", "Twitter for iPhone | \n", "http://twitter.com/download/iphone | \n", "
| 3 | \n", "891689557279858688 | \n", "Twitter for iPhone | \n", "http://twitter.com/download/iphone | \n", "
| 4 | \n", "891327558926688256 | \n", "Twitter for iPhone | \n", "http://twitter.com/download/iphone | \n", "
| \n", " | tweet_id | \n", "text | \n", "text_url | \n", "
|---|---|---|---|
| 0 | \n", "892420643555336193 | \n", "This is Phineas. He's a mystical boy. Only eve... | \n", "https://t.co/MgUWQ76dJU | \n", "
| 1 | \n", "892177421306343426 | \n", "This is Tilly. She's just checking pup on you.... | \n", "https://t.co/0Xxu71qeIV | \n", "
| 2 | \n", "891815181378084864 | \n", "This is Archie. He is a rare Norwegian Pouncin... | \n", "https://t.co/wUnZnhtVJB | \n", "
| 3 | \n", "891689557279858688 | \n", "This is Darla. She commenced a snooze mid meal... | \n", "https://t.co/tD36da7qLQ | \n", "
| 4 | \n", "891327558926688256 | \n", "This is Franklin. He would like you to stop ca... | \n", "https://t.co/AtUZn91f7f | \n", "
| \n", " | tweet_id | \n", "text | \n", "
|---|---|---|
| 320 | \n", "820690176645140481 | \n", "The floofs have been released I repeat the flo... | \n", "
| 382 | \n", "810984652412424192 | \n", "Meet Sam. She smiles 24/7 & secretly aspir... | \n", "
| 499 | \n", "786709082849828864 | \n", "This is Logan, the Chow who lived. He solemnly... | \n", "
| 549 | \n", "778027034220126208 | \n", "This is Sophie. She's a Jubilant Bush Pupper. ... | \n", "
| 658 | \n", "758467244762497024 | \n", "Why does this never happen at my front door...... | \n", "
| 722 | \n", "749981277374128128 | \n", "This is Atticus. He's quite simply America af.... | \n", "
| 842 | \n", "731156023742988288 | \n", "Say hello to this unbelievably well behaved sq... | \n", "
| 918 | \n", "716439118184652801 | \n", "This is Bluebert. He just saw that both #Final... | \n", "
| 939 | \n", "713900603437621249 | \n", "Happy Saturday here's 9 puppers on a bench. 99... | \n", "
| 963 | \n", "710658690886586372 | \n", "Here's a brigade of puppers. All look very pre... | \n", "
| 981 | \n", "709198395643068416 | \n", "From left to right:\\nCletus, Jerome, Alejandro... | \n", "
| 1045 | \n", "704054845121142784 | \n", "Here is a whole flock of puppers. 60/50 I'll ... | \n", "
| 1120 | \n", "697463031882764288 | \n", "Happy Wednesday here's a bucket of pups. 44/40... | \n", "
| 1288 | \n", "684222868335505415 | \n", "Someone help the girl is being mugged. Several... | \n", "
| 1359 | \n", "680494726643068929 | \n", "Here we have uncovered an entire battalion of ... | \n", "
| 1420 | \n", "677716515794329600 | \n", "IT'S PUPPERGEDDON. Total of 144/120 ...I think | \n", "
| 1478 | \n", "675853064436391936 | \n", "Here we have an entire platoon of puppers. Tot... | \n", "
| 1696 | \n", "670842764863651840 | \n", "After so many requests... here you go.\\n\\nGood... | \n", "
| \n", " | tweet_id | \n", "p1 | \n", "p2 | \n", "p3 | \n", "
|---|---|---|---|---|
| 0 | \n", "892420643555336193 | \n", "orange | \n", "bagel | \n", "banana | \n", "
| 1 | \n", "892177421306343426 | \n", "chihuahua | \n", "pekinese | \n", "papillon | \n", "
| 2 | \n", "891815181378084864 | \n", "chihuahua | \n", "malamute | \n", "kelpie | \n", "
| 3 | \n", "891689557279858688 | \n", "paper_towel | \n", "labrador_retriever | \n", "spatula | \n", "
| 4 | \n", "891327558926688256 | \n", "basset | \n", "english_springer | \n", "german_short_haired_pointer | \n", "
| 5 | \n", "891087950875897856 | \n", "chesapeake_bay_retriever | \n", "irish_terrier | \n", "indian_elephant | \n", "
| 6 | \n", "890971913173991426 | \n", "appenzeller | \n", "border_collie | \n", "ice_lolly | \n", "
| 7 | \n", "890729181411237888 | \n", "pomeranian | \n", "eskimo_dog | \n", "pembroke | \n", "
| 8 | \n", "890609185150312448 | \n", "irish_terrier | \n", "irish_setter | \n", "chesapeake_bay_retriever | \n", "
| 9 | \n", "890240255349198849 | \n", "pembroke | \n", "cardigan | \n", "chihuahua | \n", "
| \n", " | tweet_id | \n", "favorite_count | \n", "
|---|---|---|
| 0 | \n", "892420643555336193 | \n", "NaN | \n", "
| 1 | \n", "892177421306343426 | \n", "NaN | \n", "
| 2 | \n", "891815181378084864 | \n", "24593.0 | \n", "
| 3 | \n", "891689557279858688 | \n", "41433.0 | \n", "
| 4 | \n", "891327558926688256 | \n", "39613.0 | \n", "
| \n", " | tweet_id | \n", "retweet_count | \n", "
|---|---|---|
| 0 | \n", "892420643555336193 | \n", "NaN | \n", "
| 1 | \n", "892177421306343426 | \n", "NaN | \n", "
| 2 | \n", "891815181378084864 | \n", "4070.0 | \n", "
| 3 | \n", "891689557279858688 | \n", "8471.0 | \n", "
| 4 | \n", "891327558926688256 | \n", "9166.0 | \n", "
| \n", " | tweet_id | \n", "timestamp | \n", "source | \n", "text | \n", "expanded_urls | \n", "rating_numerator | \n", "rating_denominator | \n", "name | \n", "jpg_url | \n", "img_num | \n", "... | \n", "p2_conf | \n", "p2_dog | \n", "p3 | \n", "p3_conf | \n", "p3_dog | \n", "source_url | \n", "text_url | \n", "dogtionary | \n", "favorite_count | \n", "retweet_count | \n", "
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | \n", "892420643555336193 | \n", "2017-08-01 16:23:56 | \n", "Twitter for iPhone | \n", "This is Phineas. He's a mystical boy. Only eve... | \n", "https://twitter.com/dog_rates/status/892420643... | \n", "13.0 | \n", "10.0 | \n", "Phineas | \n", "https://pbs.twimg.com/media/DGKD1-bXoAAIAUK.jpg | \n", "1 | \n", "... | \n", "0.085851 | \n", "False | \n", "banana | \n", "0.076110 | \n", "False | \n", "http://twitter.com/download/iphone | \n", "https://t.co/MgUWQ76dJU | \n", "\n", " | NaN | \n", "NaN | \n", "
| 1 | \n", "892177421306343426 | \n", "2017-08-01 00:17:27 | \n", "Twitter for iPhone | \n", "This is Tilly. She's just checking pup on you.... | \n", "https://twitter.com/dog_rates/status/892177421... | \n", "13.0 | \n", "10.0 | \n", "Tilly | \n", "https://pbs.twimg.com/media/DGGmoV4XsAAUL6n.jpg | \n", "1 | \n", "... | \n", "0.090647 | \n", "True | \n", "papillon | \n", "0.068957 | \n", "True | \n", "http://twitter.com/download/iphone | \n", "https://t.co/0Xxu71qeIV | \n", "\n", " | NaN | \n", "NaN | \n", "
| 2 | \n", "891815181378084864 | \n", "2017-07-31 00:18:03 | \n", "Twitter for iPhone | \n", "This is Archie. He is a rare Norwegian Pouncin... | \n", "https://twitter.com/dog_rates/status/891815181... | \n", "12.0 | \n", "10.0 | \n", "Archie | \n", "https://pbs.twimg.com/media/DGBdLU1WsAANxJ9.jpg | \n", "1 | \n", "... | \n", "0.078253 | \n", "True | \n", "kelpie | \n", "0.031379 | \n", "True | \n", "http://twitter.com/download/iphone | \n", "https://t.co/wUnZnhtVJB | \n", "\n", " | 24593.0 | \n", "4070.0 | \n", "
| 3 | \n", "891689557279858688 | \n", "2017-07-30 15:58:51 | \n", "Twitter for iPhone | \n", "This is Darla. She commenced a snooze mid meal... | \n", "https://twitter.com/dog_rates/status/891689557... | \n", "13.0 | \n", "10.0 | \n", "Darla | \n", "https://pbs.twimg.com/media/DF_q7IAWsAEuuN8.jpg | \n", "1 | \n", "... | \n", "0.168086 | \n", "True | \n", "spatula | \n", "0.040836 | \n", "False | \n", "http://twitter.com/download/iphone | \n", "https://t.co/tD36da7qLQ | \n", "\n", " | 41433.0 | \n", "8471.0 | \n", "
| 4 | \n", "891327558926688256 | \n", "2017-07-29 16:00:24 | \n", "Twitter for iPhone | \n", "This is Franklin. He would like you to stop ca... | \n", "https://twitter.com/dog_rates/status/891327558... | \n", "12.0 | \n", "10.0 | \n", "Franklin | \n", "https://pbs.twimg.com/media/DF6hr6BUMAAzZgT.jpg | \n", "2 | \n", "... | \n", "0.225770 | \n", "True | \n", "german_short_haired_pointer | \n", "0.175219 | \n", "True | \n", "http://twitter.com/download/iphone | \n", "https://t.co/AtUZn91f7f | \n", "\n", " | 39613.0 | \n", "9166.0 | \n", "
5 rows × 24 columns
\n", "| \n", " | favorite_count | \n", "retweet_count | \n", "rate | \n", "count | \n", "
|---|---|---|---|---|
| dogtionary | \n", "\n", " | \n", " | \n", " | \n", " |
| None | \n", "8062.129870 | \n", "2393.982375 | \n", "3.367665 | \n", "1665 | \n", "
| doggo | \n", "14410.558824 | \n", "4851.058824 | \n", "2.970601 | \n", "63 | \n", "
| floofer | \n", "5643.000000 | \n", "2172.000000 | \n", "2.598066 | \n", "7 | \n", "
| multiclass | \n", "19020.250000 | \n", "6341.375000 | \n", "2.999389 | \n", "10 | \n", "
| pupper | \n", "6529.219858 | \n", "2122.219858 | \n", "3.076599 | \n", "201 | \n", "
| puppo | \n", "14684.933333 | \n", "4292.266667 | \n", "3.421254 | \n", "22 | \n", "
| \n", " | Avg Rating | \n", "Tweets Number | \n", "
|---|---|---|
| Monday | \n", "10.342593 | \n", "324 | \n", "
| Tuesday | \n", "10.602302 | \n", "291 | \n", "
| Wednesday | \n", "10.453925 | \n", "293 | \n", "
| Thurday | \n", "10.706250 | \n", "280 | \n", "
| Friday | \n", "10.692688 | \n", "279 | \n", "
| Saturday | \n", "10.586694 | \n", "248 | \n", "
| Sunday | \n", "10.454545 | \n", "253 | \n", "
| \n", " | Avg Rating | \n", "Tweets Number | \n", "
|---|---|---|
| Jan | \n", "10.711207 | \n", "232 | \n", "
| Feb | \n", "10.889535 | \n", "172 | \n", "
| Mar | \n", "10.939394 | \n", "165 | \n", "
| Apr | \n", "11.287234 | \n", "94 | \n", "
| May | \n", "11.683673 | \n", "98 | \n", "
| Jun | \n", "11.073171 | \n", "123 | \n", "
| Jul | \n", "11.533088 | \n", "136 | \n", "
| Aug | \n", "11.000000 | \n", "61 | \n", "
| Sep | \n", "11.194762 | \n", "63 | \n", "
| Oct | \n", "11.673077 | \n", "65 | \n", "
| Nov | \n", "9.355491 | \n", "346 | \n", "
| Dec | \n", "9.877143 | \n", "413 | \n", "
| \n", " | favorite_count | \n", "retweet_count | \n", "rate | \n", "
|---|---|---|---|
| p1 | \n", "\n", " | \n", " | \n", " |
| german_short_haired_pointer | \n", "27523.0 | \n", "4455.0 | \n", "6.178002 | \n", "
| basset | \n", "122353.0 | \n", "23171.0 | \n", "5.280437 | \n", "
| irish_terrier | \n", "34710.0 | \n", "6583.0 | \n", "5.272672 | \n", "
| rhodesian_ridgeback | \n", "12956.0 | \n", "2479.0 | \n", "5.226301 | \n", "
| bloodhound | \n", "25891.0 | \n", "5080.0 | \n", "5.096654 | \n", "
| \n", " | rate_p1 | \n", "rate_p2 | \n", "rate_p3 | \n", "
|---|---|---|---|
| newfoundland | \n", "3.700781 | \n", "5.211597 | \n", "5.745550 | \n", "
| yorkshire_terrier | \n", "4.204334 | \n", "3.784307 | \n", "3.932011 | \n", "
| kuvasz | \n", "3.675678 | \n", "4.255575 | \n", "3.885262 | \n", "
| staffordshire_bullterrier | \n", "4.082564 | \n", "4.182275 | \n", "3.841623 | \n", "