twitter_timeline_trend.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Twitter Web Scraping Using Tweepy"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "from tweetkey import consumer_api_key, consumer_api_secret_key, access_token, access_secret_token"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "import tweepy\n",
    "import pandas as pd\n",
    "import time "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "auth = tweepy.OAuthHandler(consumer_api_key, consumer_api_secret_key)\n",
    "auth.set_access_token(access_token, access_secret_token)\n",
    "\n",
    "api = tweepy.API(auth, wait_on_rate_limit=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Tweet:\n",
      "Ageism Hurts All of Us, Even ’Young People’ https://t.co/rScu1WvNw3\n",
      "---------------\n",
      "Tweet:\n",
      "\"According to family lore, my grandmother made a dress that Jackie O liked so much, the first lady bought one in ev… https://t.co/8A2o1Nus75\n",
      "---------------\n",
      "Tweet:\n",
      "Check out YAWNICORN's Instagram for more amazing artwork, pleasing to the eyes and mind. 🌱✨\n",
      "https://t.co/kb1H9zOGkt… https://t.co/KQoYyfTSpo\n",
      "---------------\n",
      "Tweet:\n",
      "\"Take a step back, take a deep breath.\" - @ericnamofficial MINDSET Ep #4\n",
      "\n",
      "Feeling burned out? 💥 We partnered with w… https://t.co/LkQ2dxr4mX\n",
      "---------------\n",
      "Tweet:\n",
      "RT @transparentfeed: Fire listen all the way through. @AppleMusic featuring the @dumbfoundead: Represent Playlist #aapihm https://t.co/BfEH…\n",
      "---------------\n",
      "Tweet:\n",
      "The main takeaway of shadow work? It’s not you, it’s me. https://t.co/CBIKuFFxX8\n",
      "---------------\n",
      "Tweet:\n",
      "After a terrible year for women in the economy, these places are working toward a feminist recovery from COVID-19 https://t.co/fheeCJ5qHI\n",
      "---------------\n",
      "Tweet:\n",
      "Wait, this is so ridiculously cute though. 💕 https://t.co/18SbLEiHjZ\n",
      "---------------\n",
      "Tweet:\n",
      "\"I thought he killed it,\" Pete Davidson said of @KidCudi's Kurt Cobain-inspired dress, which he wore to perform on… https://t.co/GhxmqzntRB\n",
      "---------------\n",
      "Tweet:\n",
      "Shop all our pretty print faves, online now: https://t.co/fHZGSpgDvN? https://t.co/vJHedWcJkN\n",
      "---------------\n",
      "Tweet:\n",
      "Tag your homegirl below 😤💯\n",
      "\n",
      "👻 Get ready for Ep. #6 of HWAITING! Subscribe to the DIVE Studios Snapchat channel to b… https://t.co/1xbOB3XHj1\n",
      "---------------\n",
      "Tweet:\n",
      "No, you are almost certainly not going to be hit by a 10-story, 23-ton piece of a Chinese rocket hurtling back to E… https://t.co/N2vaY2mhd1\n",
      "---------------\n",
      "Tweet:\n",
      "Tomorrow! @STORYmiami https://t.co/53a3JxH33o\n",
      "---------------\n",
      "Tweet:\n",
      "Justin Wynn and Gary DeMercurio were paid to break into facilities to identify security vulnerabilities and to help… https://t.co/CNotBZ0bu4\n",
      "---------------\n",
      "Tweet:\n",
      "This pre-reopening euphoria feels like hope | Helen Ubiñas https://t.co/aFYXY3D4vu\n",
      "---------------\n",
      "Tweet:\n",
      "Russian rock musicians who have expressed support for imprisoned opposition leader Alexei Navalny say authorities a… https://t.co/9kOWdDxFWt\n",
      "---------------\n",
      "Tweet:\n",
      "RT @notpranto: Me in public:             My headphones: https://t.co/may2mRr7WJ\n",
      "---------------\n",
      "Tweet:\n",
      "You have heard Nicholas Britell’s music, even if you don’t know his name. (He scored the title for HBO’s “Successio… https://t.co/PHioIvMG8c\n",
      "---------------\n",
      "Tweet:\n",
      "Kendall Jenner opened up about her ongoing struggles with anxiety and hypochondria. https://t.co/cN2y6qYK1Q\n",
      "---------------\n",
      "Tweet:\n",
      "RT @Drathdir: Second vaccine down!  Thanks for taking care of us, Blizzard! https://t.co/Ti9iJdDXk8\n",
      "---------------\n",
      "Tweet:\n",
      "An algorithm has created tracks by Amy Winehouse and Kurt Cobain to promote better mental health in the music indus… https://t.co/Eb6boalSRq\n",
      "---------------\n",
      "Tweet:\n",
      "From @timeforkids: U.S. Secretary of Education Miguel Cardona (@SecCardona) speaks to Kid Reporter Bellen Woodard a… https://t.co/GfFWMy7XAR\n",
      "---------------\n",
      "Tweet:\n",
      "Absinthe, designed by Manh Nguyen, is a delicate font that's perfect for describing the most dainty things in life.… https://t.co/loNcEmrP9K\n",
      "---------------\n",
      "Tweet:\n",
      "kauppi &amp; kauppi designs oval meeting pods that favor acoustics for glimakra of sweden\n",
      "https://t.co/4dyJM4eJ2K https://t.co/sEYjxV7KJj\n",
      "---------------\n",
      "Tweet:\n",
      "Beyoncé told Posh Spice that the Spice Girls had inspired her to become a performer. 🙌 https://t.co/BSXomWL30h\n",
      "---------------\n",
      "Tweet:\n",
      "RT @RodFergusson: Congratulations to the House of Silk for ascending in #DiabloImmortal and for Zarchi becoming the first ever Immortal out…\n",
      "---------------\n",
      "Tweet:\n",
      "Rihanna proves there has never been a better time to define—and embrace—your own brand of individualized glamour https://t.co/mvItFav2DI\n",
      "---------------\n",
      "Tweet:\n",
      "Live Nation CFO Kathy Willard is retiring after nearly 25 years with the promoter. https://t.co/jTPQgFWAsM\n",
      "---------------\n",
      "Tweet:\n",
      "Whether you’re sporting canvas Chuck Taylors, leather Stan Smiths or pristine Jordans, @wirecutter has tips for kee… https://t.co/uXvhuqAOC8\n",
      "---------------\n",
      "Tweet:\n",
      "The 3 science-backed strategies that can help you achieve your post-pandemic goals https://t.co/kHDzqtdXAv\n",
      "---------------\n",
      "Tweet:\n",
      "It's been ten years since this iconic dance scene from #SomethingBorrowed graced our screens. https://t.co/yPOaJJ3obu\n",
      "---------------\n",
      "Tweet:\n",
      "#ThrowbackThursday: Stepping up. \n",
      "\n",
      "We're practicing our art photography game – Art Basel Hong Kong 2021 opens in ju… https://t.co/ikQU3eQbmf\n",
      "---------------\n",
      "Tweet:\n",
      "A 10-story, 23-ton piece of a Chinese rocket will crash into Earth sometime over the weekend — but no one knows whe… https://t.co/HSMxj5lvUG\n",
      "---------------\n",
      "Tweet:\n",
      "Grass pollen joining the trees to torment Philly allergy sufferers https://t.co/4RoNMTK89E\n",
      "---------------\n",
      "Tweet:\n",
      "The Australia 108 skyscraper in Melbourne by @AFK_studios is the tallest residential building in the southern hemis… https://t.co/WFqnnZB48R\n",
      "---------------\n",
      "Tweet:\n",
      "11 K-Beauty Sheet Masks for Every Skincare Issue You Can Think Of https://t.co/rcZMZOrdrq\n",
      "---------------\n",
      "Tweet:\n",
      "MGM Worldwide Television Group is partnering with Korea’s SM Entertainment to develop a competition series to scout… https://t.co/RibIva9wPD\n",
      "---------------\n",
      "Tweet:\n",
      "We know! It sounds mind-blowingly stupid! But somehow, this is real!\n",
      " https://t.co/lY5c3Illhn\n",
      "---------------\n",
      "Tweet:\n",
      "RT @da_pimenova: For all those who are tired and don't mind a little rest ☀️🏖️\n",
      "https://t.co/1A1kkwxG2r\n",
      "---------------\n",
      "Tweet:\n",
      "blank façade conceals minimalist all-white interior of 'chip &amp; chop' house in spain\n",
      "https://t.co/utQzcEBCIE https://t.co/kDcowHOzSP\n",
      "---------------\n",
      "Tweet:\n",
      "If you own one of the Peloton Tread+ treadmills voluntarily recalled this week over safety concerns, you have a few… https://t.co/YbOfIHpPIu\n",
      "---------------\n",
      "Tweet:\n",
      "diagonal glass façade slices a laboratory-like sweet shop in maebashi, japan\n",
      "https://t.co/rY7FMV7KGk https://t.co/mwDHlheHbA\n",
      "---------------\n",
      "Tweet:\n",
      "The pink hairdo debuted around the world Thursday morning is courtesy of BTS' RM, who showed off his new hair color… https://t.co/ujmTy88JFc\n",
      "---------------\n",
      "Tweet:\n",
      "Krysta Rodriguez nodded to her on-screen character for the premiere of Ryan Murphy’s new show, Halston… https://t.co/WevCeAzN2k\n",
      "---------------\n",
      "Tweet:\n",
      "Philly school buildings are reopened for most, but most families are staying home.\n",
      "\n",
      "District-wide, 73% of those inv… https://t.co/bg1org4jR5\n",
      "---------------\n",
      "Tweet:\n",
      "On their new albums, Miranda Lambert and Ashley Monroe find new ways to disrupt country music https://t.co/WQhL2LWJq6\n",
      "---------------\n",
      "Tweet:\n",
      "Stefanie &amp; Joan's Beauty Bar Ep. #12 | HOW TO: Skincare for Beginners! with #EdwardAvila\n",
      "\n",
      "🎧 Listen to Ep. #12 of '… https://t.co/Kf7RLuj0NZ\n",
      "---------------\n",
      "Tweet:\n",
      "Girlboss, gatekeep, gaslight! https://t.co/SV371WjXCl\n",
      "---------------\n",
      "Tweet:\n",
      "News Analysis: Vaccinated travel enthusiasts are ready to take the world by storm. Why you might not want to pack y… https://t.co/ntyRbKQOcE\n",
      "---------------\n",
      "Tweet:\n",
      "Introducing: @StefanieMichova &amp; @joankeem's Favorite @DrJartUS Products but make it ✨ASMR✨\n",
      "\n",
      "What's your favorite pr… https://t.co/BFFSNdgIef\n",
      "---------------\n",
      "Tweet:\n",
      "By May 2020, the CDC was saying surface transmission was not driving infections of COVID-19. But many libraries are… https://t.co/a6z37QBz8F\n",
      "---------------\n",
      "Tweet:\n",
      "To celebrate Archie's birthday, the Duke and Duchess of Sussex shared a new photo of the two-year-old. https://t.co/mJxwzX0POs\n",
      "---------------\n",
      "Tweet:\n",
      "For this #ThrowbackThursday: Feast Your Eyes on These Architectural Residential Drawings of the Past #Architecture… https://t.co/PNlYZZIogN\n",
      "---------------\n",
      "Tweet:\n",
      "Here's everything you need to know about the Apple's slew of new products: https://t.co/af7DbinwIv\n",
      "---------------\n",
      "Tweet:\n",
      "RT @SilverBrin: Blizzard's vaccine sticker game on point. Thanks for the jab, JAB. https://t.co/GxLOrVDY5M\n",
      "---------------\n",
      "Tweet:\n",
      "RT @GeorgeKrstic: Honored to have been allowed to craft story for the #Starcraft universe! Congrats team! “Starcraft headlines class of 4 i…\n",
      "---------------\n",
      "Tweet:\n",
      "The return of concerts is sweet music to Live Nation’s ears after the pandemic-caused live music shutdown dropped r… https://t.co/fTxGdDbz6D\n",
      "---------------\n",
      "Tweet:\n",
      "Oceana applauds @POTUS for the #AmericatheBeautiful plan, which will help fight climate change, protect our oceans,… https://t.co/llZa7xQNCu\n",
      "---------------\n",
      "Tweet:\n",
      "To do this week: Celebrate a mom https://t.co/tGOEEqt67J\n",
      "---------------\n",
      "Tweet:\n",
      "Nearly one million Americans have signed up for Obamacare coverage during the first 10 weeks of a special open enro… https://t.co/HDeVXFs8Gb\n",
      "---------------\n",
      "Tweet:\n",
      "Love Yoga? India's Covid Crisis Demands Your Attention https://t.co/vGI25Eklhi\n",
      "---------------\n",
      "Tweet:\n",
      "Boat Pose from Easy Yoga https://t.co/tEpOWU7Zgc\n",
      "---------------\n",
      "Tweet:\n",
      "These robots have very specific roles to play in industrial processes, working side by side with their human collea… https://t.co/acugYL3Ulr\n",
      "---------------\n",
      "Tweet:\n",
      "feeling creative? submit your drawings to @ieArchDesign 'spaces for creativity' competition now for a chance to win… https://t.co/Cs3ZbLLMsJ\n",
      "---------------\n",
      "Tweet:\n",
      "Six women embrace the joys of new motherhood, and share how having a child is always an act of faith, but perhaps n… https://t.co/kae1SGS6es\n",
      "---------------\n",
      "Tweet:\n",
      "Willie Mays ran more miles on the baseball field, and with greater speed and more style, than any player before or… https://t.co/8mamGq1PFF\n",
      "---------------\n",
      "Tweet:\n",
      "Spent all week on the post-lockdown piss up? Here’s your chance to catch up on five unmissable stories. https://t.co/RVZuDoupXS\n",
      "---------------\n",
      "Tweet:\n",
      "Born out of necessity and founded by musicians in the local circuit, @SingleLock's co-owners have built a label foc… https://t.co/nm85LGhbAc\n",
      "---------------\n",
      "Tweet:\n",
      "Who is The Kid Laroi? What to know about the 17-year-old's meteoric rise https://t.co/m8XVHlvZ0C\n",
      "---------------\n",
      "Tweet:\n",
      "I feel like a Kardashian when I wear these. https://t.co/qgLv586Zq6\n",
      "---------------\n",
      "Tweet:\n",
      "@mikemorhaime 💙💙💙\n",
      "---------------\n",
      "Tweet:\n",
      "RT @SpaceGoatVii: This sticker is amazing 😂 https://t.co/Y8p3Z47lAJ\n",
      "---------------\n",
      "Tweet:\n",
      "Injured Phillies reliever Archie Bradley hopes to return within two weeks https://t.co/YiKKBDaLVO\n",
      "---------------\n",
      "Tweet:\n",
      ".@almanac_arch has extended and added a second grey-brick skin to a 1950s property in south London.\n",
      "https://t.co/gGvoPcOHgG\n",
      "---------------\n",
      "Tweet:\n",
      "And here's a look at the Art Museum's new galleries, including an exhibition of works by local art-makers and how t… https://t.co/hoBMJY59p7\n",
      "---------------\n",
      "Tweet:\n",
      "An Indian-American physician assistant in Boston founded a telehealth program a few years ago to help India’s most… https://t.co/dscROJiRWB\n",
      "---------------\n",
      "Tweet:\n",
      "\"I come from a dangerous neighborhood that made it easy for my lyrics,\" #GeraMX tells us. https://t.co/vT2pmm50Lg\n",
      "---------------\n",
      "Tweet:\n",
      "Britney Spears has broken her silence, and revealed her true feelings on the documentaries about her legal battles… https://t.co/zD220KKPTJ\n",
      "---------------\n",
      "Tweet:\n",
      "*Goes on https://t.co/SW2HduU0L4*\n",
      "\n",
      "“I just want to see what they have.”\n",
      "Lies we tell ourselves\n",
      "---------------\n",
      "Tweet:\n",
      "Feeling burned out at work? Recent studies have shown that taking micro-breaks during the day can help you reset. F… https://t.co/YtKLY5O8ne\n",
      "---------------\n",
      "Tweet:\n",
      "RT @dimmak: so many broken rails…. S/O to everyone who pushed @riottenmusic &amp; @ricoactmusic’s “Rail Breaker” past 10,000,000 streams on @sp…\n",
      "---------------\n",
      "Tweet:\n",
      "Chris Robinson said Kate Hudson's favorite accessory was \"a platinum American Express credit card.\" https://t.co/LyPXB7slR2\n",
      "---------------\n",
      "Tweet:\n",
      "Willow Smith pulled off a top-secret Mother's Day surprise for Jada Pinkett Smith by getting her mom's metal band b… https://t.co/cQOgCXIGPb\n",
      "---------------\n",
      "Tweet:\n",
      "The foods we crave when we most need comfort tend to be the sugary and high fat foods that may be least likely to b… https://t.co/AAb6wBYgXf\n",
      "---------------\n",
      "Tweet:\n",
      "Colosseum, Rome https://t.co/gHrsu27E3A\n",
      "---------------\n",
      "Tweet:\n",
      "RT @michaelcrowley: My story from Kyiv, in which Ukraine’s Zelensky shakes off a question about Giuliani and the … unpleasantness:\n",
      "\n",
      "\"Let’s…\n",
      "---------------\n",
      "Tweet:\n",
      "CHYBIK + KRISTOF breathes new life into brutalist zvonařka bus terminal https://t.co/vvDy35hluu https://t.co/Rzts7xiU45\n",
      "---------------\n",
      "Tweet:\n",
      "From Jimi Somewhere to Slowthai, these are the records you need to hear right now. https://t.co/6btZF53QJW\n",
      "---------------\n",
      "Tweet:\n",
      "You want it? You got it. @ArianaGrande is now popping bubbly in Hollywood as a Madame Tussauds wax figure.\n",
      "\n",
      "https://t.co/MIgmzTrb9v\n",
      "---------------\n",
      "Tweet:\n",
      "Rihanna Kicks Off May by Debuting a Pixie Cut https://t.co/5ZfYdcFrx6\n",
      "---------------\n",
      "Tweet:\n",
      "Chic cut-out pieces to wear this summer https://t.co/LS8BMOYpLs https://t.co/dUjBTuWeOl\n",
      "---------------\n",
      "Tweet:\n",
      "Curtis composer David Serkin Ludwig is leaving for Juilliard https://t.co/zpeRT2DvGj\n",
      "---------------\n",
      "Tweet:\n",
      "Dominating the have-nots keys the Sixers’ drive to the East’s top seed https://t.co/31uylHZcbe\n",
      "---------------\n",
      "Tweet:\n",
      "COVID-19 conspiracy beliefs increased among conservative and social media users, Penn study finds https://t.co/oSHn4zaO5k\n",
      "---------------\n",
      "Tweet:\n",
      "NONSENSIBLE Ep. #50 | Being Famous While Driving Uber with #DavidMcInnis\n",
      "\n",
      "🎧 Listen to Ep. #50 of '#NONSENSIBLE w/… https://t.co/8QWmxKXQTL\n",
      "---------------\n",
      "Tweet:\n",
      "Did David Berkowitz act alone? \"The Sons of Sam,\" Netflix's latest true crime docuseries, follows one journalist wh… https://t.co/vAjKmTY9UP\n",
      "---------------\n",
      "Tweet:\n",
      ".@justinbieber announced the rescheduled dates for his #JusticeWorldTour that was originally set to kick off this s… https://t.co/JezHp9XJGU\n",
      "---------------\n",
      "Tweet:\n",
      "Manchester City and Chelsea sealed an all-Premier League final thanks in part to resources and rosters that no club… https://t.co/XQgYIBE8LH\n",
      "---------------\n",
      "Tweet:\n",
      "Do you remember Captain David Argus in '#DescendantsOfTheSun'? Who else misses this drama? 🥲✋ https://t.co/4l3qBDsVvf\n",
      "---------------\n",
      "Tweet:\n",
      "Waking up with perfect hair has never been easier. https://t.co/pTWN532p3y\n",
      "---------------\n",
      "Tweet:\n",
      "Here are 10 things we learned from @JBALVIN's new documentary 'The Boy From Medellín,' which will stream on Amazon… https://t.co/wQH7Tx0GoD\n",
      "---------------\n",
      "Tweet:\n",
      ".@porterrobinson rockets to the first No. 1 debut of 2021 on Billboard's Top Dance/Electronic Albums chart with 'Nu… https://t.co/o5dNWZ8aHW\n",
      "---------------\n",
      "Tweet:\n",
      "Sheldon Silver, the former New York State Assembly speaker, was ordered back to prison on Thursday to continue serv… https://t.co/Rjyu2D2Gtf\n",
      "---------------\n",
      "Tweet:\n",
      ".@cecewinans achieves her second leader on Billboard's Gospel Airplay chart as \"Never Lost\" climbs from No. 3 to No… https://t.co/GgbXAAiekr\n",
      "---------------\n",
      "Tweet:\n",
      "Under growing pressure, the European Union said it would consider the Biden administration’s decision to reverse co… https://t.co/ZoXuTFfVGU\n",
      "---------------\n",
      "Tweet:\n",
      "⚡️ “#MothersDay Gift Ideas” \n",
      "The WIRED Gear team put together several guides to help you find the perfect present t… https://t.co/bw3v3b2azq\n",
      "---------------\n",
      "Tweet:\n",
      ".@DJKhaled transforms an island he's stranded on to his private paradise in the \"We Going Crazy\" music video, featu… https://t.co/PvNeDbVL3P\n",
      "---------------\n",
      "Tweet:\n",
      "Super proud to have been part of the StarCraft development team and honored to see that very special game inducted… https://t.co/FdlEJZQiyN\n",
      "---------------\n",
      "Tweet:\n",
      "RT @NYTMetro: Will a skyscraper at the South Street Seaport set a precedent for development in historic districts? https://t.co/kU8CdoFaLe\n",
      "---------------\n",
      "Tweet:\n",
      "Jimmy Johnson, original member of the Flyers and part of blockbuster trade, dies at 78 https://t.co/AZBudXMjxR\n",
      "---------------\n",
      "Tweet:\n",
      "Thumbs up or down: Eagles writers weigh in on fourth-round pick Zech McPhearson https://t.co/LwY4Z3DWCQ\n",
      "---------------\n",
      "Tweet:\n",
      "RIP Nick Kamen 🕊 \n",
      "\n",
      "The Cult model and singer, known for working with Madonna on his hit song “Each Time You Break M… https://t.co/lP5RIocf0F\n",
      "---------------\n",
      "Tweet:\n",
      "RT @_RocketBryan: @LifeatBlizzard Omigosh, those turned out great! My wife @teatigercafe designed that lovely stickers and I'm so glad they…\n",
      "---------------\n",
      "Tweet:\n",
      "BTS’ J-Hope accidentally called Conan O’ Brien \"curtain.\" #BillboardNews https://t.co/qT9BjinAgB\n",
      "---------------\n",
      "Tweet:\n",
      ".@MykeTowerspr claims his second top 10 on the #TopLatinAlbums chart as his third studio album, 'Lyke Mike,' debuts… https://t.co/a6ODRfxWPm\n",
      "---------------\n",
      "Tweet:\n",
      "New York City is launching a new program to provide funding to artists for public works, an effort to lend financia… https://t.co/yqjzOMMEXH\n",
      "---------------\n",
      "Tweet:\n",
      "frank gehry's @philamuseum renovation is a 'reconstruction to the values of the original architect'… https://t.co/r0Ar4gPPDd\n",
      "---------------\n",
      "Tweet:\n",
      "\"In doing this project, I felt more Asian in that I felt a solidarity with all these women who felt the same way I… https://t.co/nTlELvSvSh\n",
      "---------------\n",
      "Tweet:\n",
      "Join Billboard for a Q&amp;A with @Imaginedragons frontman @DanReynolds, “Cutthroat” video star @oliviamunn and directo… https://t.co/MHGVPKtUg4\n",
      "---------------\n",
      "Tweet:\n",
      "\"You don't need anyone's permission to feel beautiful or worthy in life. Tell it to all your friends — you may be t… https://t.co/oP2P5Nmp5s\n",
      "---------------\n",
      "Tweet:\n",
      "Ahead of the release of 'Better Mistakes,' @BebeRexha described what the project represents to her personally and p… https://t.co/C1xcjISF1y\n",
      "---------------\n",
      "Tweet:\n",
      "Drexel and Temple seniors are grateful for a fifth year and another shot at the Jefferson Dad Vail Regatta https://t.co/znxSmuiNI5\n",
      "---------------\n",
      "Tweet:\n",
      "\"I believe people did not know how to 'categorize' me. 'Is she white? Is she Hispanic? Is she Hapa?' But looking ba… https://t.co/ifaMJqf6TQ\n",
      "---------------\n",
      "Tweet:\n",
      "Michelin has added a new designation to its American guide: The Green Star, given for excellence in sustainability.… https://t.co/HKm8jd12S8\n",
      "---------------\n",
      "Tweet:\n",
      "\"My insecurities were even more exacerbated because I was adopted and lived in a predominantly white community. I d… https://t.co/PM8nU2f1TV\n",
      "---------------\n",
      "Tweet:\n",
      "Hailey Bieber shares her morning routine https://t.co/aK9g3mhr5C\n",
      "---------------\n",
      "Tweet:\n",
      "\"It's awesome not to, you know, live in fear.\" Australia is nearly COVID-19 free. Toyko-bound Olympic surfers are r… https://t.co/J7k8tD4FWS\n",
      "---------------\n",
      "Tweet:\n",
      "RIP Nick Kamen 💔⁣⁠\n",
      "⁣⁠\n",
      "The model, singer and member of the influential Buffalo scene has sadly passed away, aged 59.… https://t.co/En9yMLn1EA\n",
      "---------------\n",
      "Tweet:\n",
      "RT @smbahr14: A new New York Foundation for the Arts program will provide $1,000 grants to New York City-based artists with disabilities wh…\n",
      "---------------\n",
      "Tweet:\n",
      "\"I never fit into the conventional definition of beauty in Asian or American culture.\" @dianawking's series \"Almost… https://t.co/gs80zy5gMV\n",
      "---------------\n",
      "Tweet:\n",
      "A state senator in Ohio might have fooled anyone who watched a state board meeting this week into thinking he was a… https://t.co/uyE7x7lwen\n",
      "---------------\n",
      "Tweet:\n",
      "Make humanity a multiplanet species!\n",
      "---------------\n",
      "Tweet:\n",
      "Public support for life on Mars is critical to making it happen\n",
      "---------------\n",
      "Tweet:\n",
      "This bottle of wine spent 14 months orbiting the Earth at a speed of 17,500 miles per hour aboard the International… https://t.co/UywnRFkygy\n",
      "---------------\n",
      "Tweet:\n",
      "RT @911access: 🤟 Thank you @MapBox for supporting Team Access in making https://t.co/H1fvPIW9Oq possible, we love you! \n",
      "P.s Can you spot th…\n",
      "---------------\n",
      "Tweet:\n",
      "G Herbo is in more legal trouble in connection with an alleged scheme to use stolen credit card info to pay for a l… https://t.co/u0DDogA03W\n",
      "---------------\n",
      "Tweet:\n",
      "The board told Facebook to take six months and get its own rules straight, and then make the Trump restoration deci… https://t.co/BAjxcSkusS\n",
      "---------------\n",
      "Tweet:\n",
      "#David Adjaye https://t.co/tNu9QmHkjI | posted by afasia | daily entries on contemporary art and architecture\n",
      "\n",
      "Four… https://t.co/lOMA5Lps0z\n",
      "---------------\n",
      "Tweet:\n",
      "#Frank Gehry https://t.co/KJcZ8We4Tk | posted by afasia | daily entries on contemporary art and architecture\n",
      "\n",
      "Museu… https://t.co/lzjEwiQSei\n",
      "---------------\n",
      "Tweet:\n",
      "Meghan Markle and Prince Harry Shared an Adorable New Photo of Archie for His 2nd Birthday https://t.co/X6kIgrZUUP\n",
      "---------------\n",
      "Tweet:\n",
      "The next round of Michelin stars for New York restaurants is out. The French producer of guides announced the award… https://t.co/YbfooEhyVh\n",
      "---------------\n",
      "Tweet:\n",
      "Tropical hardwood and sand-coloured plaster feature in this refurbished Miami beachside apartment.\n",
      "https://t.co/5Kl2rymrDr\n",
      "---------------\n",
      "Tweet:\n",
      "RT @robrousseau: the possibility of mass human misery &amp; death being alleviated ever so slightly has displeased The Line\n",
      "---------------\n",
      "Tweet:\n",
      "Get familiar with the most forward thinking minds in fashion, art and music!  https://t.co/Fy6AYPkG3q\n",
      "---------------\n",
      "Tweet:\n",
      "\"After everything my mom and I have been through,\" Ilan Bluestone writes after his mother's April triple bypass sur… https://t.co/9kumL18A4I\n",
      "---------------\n",
      "Tweet:\n",
      "HKB's latest newspaper has been released surrounding the theme of the almighty effects of the COVID pandemic. The n… https://t.co/F7wtK2q8Cn\n",
      "---------------\n",
      "Tweet:\n",
      "The U.S. and Iran could each come back into compliance with a 2015 nuclear deal within weeks, a senior State Depart… https://t.co/etPZ5atOou\n",
      "---------------\n",
      "Tweet:\n",
      "Peco improperly shut off nearly 50,000 customers because of computer glitches https://t.co/0fLmRkf41x\n",
      "---------------\n",
      "Tweet:\n",
      "Posture sequence from Yoga Reset https://t.co/gxCzajftw1\n",
      "---------------\n",
      "Tweet:\n",
      "The U.S. and Iran could return to a 2015 nuclear deal, a senior State Department official said. It was the most opt… https://t.co/jwMHgCcR0P\n",
      "---------------\n",
      "Tweet:\n",
      ".@theestallion is teaming up with Snapchat for a new pet series, 'Off Thee Leash.'\n",
      "\n",
      "https://t.co/UeUtaJUA0J\n",
      "---------------\n",
      "Tweet:\n",
      "For #BirthStories—a new limited audio series from @voguemagazine in celebration of #MothersDay—model Grace Elizabet… https://t.co/lYyBEceIxG\n",
      "---------------\n",
      "Tweet:\n",
      "Jennifer Randles: \"Too many moms can't afford diapers for their kids. On Mother's Day, we must remember their need\" https://t.co/Vg7Q0nMnOI\n",
      "---------------\n",
      "Tweet:\n",
      "There's no use spending $6 on a grilled cheese!\n",
      "\n",
      "Thank you to:\n",
      "https://t.co/H1JhTXp9EY\n",
      "https://t.co/1OCwR9k2HX https://t.co/HvYdCzfvda\n",
      "---------------\n",
      "Tweet:\n",
      "Jill Biden surprised 2021's Teacher of the Year. ❤️ https://t.co/BdFxpQjNHW\n",
      "---------------\n",
      "Tweet:\n",
      "A relatively obscure dispute over fishing rights between Britain and France has rapidly escalated into converging n… https://t.co/gBN8iFZFct\n",
      "---------------\n",
      "Tweet:\n",
      "Even as the global pandemic worsens in places like India and South America, the appetite for vaccination in the Uni… https://t.co/MAFtWCouh7\n",
      "---------------\n",
      "Tweet:\n",
      "3層仕立て♪ いちごとヨーグルトのふんわりムース #tastyjapan https://t.co/yJn6mHIrX5\n",
      "---------------\n",
      "Tweet:\n",
      "Regulators are now working to ensure that those doses are safe after the disclosure in March that workers at Emerge… https://t.co/3vXxjRRVSQ\n",
      "---------------\n",
      "Tweet:\n",
      "RT @_byeforever_: Designed these coins earlier this year for our team to commemorate the release of our new https://t.co/NsIS0nvm4V desktop…\n",
      "---------------\n",
      "Tweet:\n",
      "Breaking News: Europe, South Africa and Canada are holding back millions of J&amp;J vaccines as a precaution, as qualit… https://t.co/mw4Z9QgVsI\n",
      "---------------\n",
      "Tweet:\n",
      "RT @HSesports: Have what it takes to help shape the future of competitive Hearthstone? We're looking for a new Associate Product Manager to…\n",
      "---------------\n",
      "Tweet:\n",
      "City Council should fight Kenney’s cuts to eviction prevention budget | Editorial https://t.co/giYeo7KjPa\n",
      "---------------\n",
      "Tweet:\n",
      "Fatigued by all things digital, Gen Z transitioned to the tactile during lockdown, including crochet, DIY, quilting… https://t.co/4yDmvOYwQi\n",
      "---------------\n",
      "Tweet:\n",
      "The genre-blurring Bristol teen has the same team as Dua Lipa. Here are 10 things more things you should know about… https://t.co/jgzTdIJiA0\n",
      "---------------\n",
      "Tweet:\n",
      "Meghan Markle and Prince Harry Shared an Adorable New Photo of Archie For His 2nd Birthday \n",
      "https://t.co/O86Aq2lkmp\n",
      "---------------\n",
      "Tweet:\n",
      "Hilary Duff dishes on the ‘How I Met Your Father’ script and why the ‘Lizzie McGuire’ reboot fell apart https://t.co/IvQVyRhnZS\n",
      "---------------\n",
      "Tweet:\n",
      "RT @AdrienAustralia: I spoke to @mrMattSimon from @WIRED the other day about our latest @AguAdvances @theAGU research on #wildfire smoke mo…\n",
      "---------------\n",
      "Tweet:\n",
      "interview: designboom speaks with binke lenhardt and hao dong, founders of beijing-based firm crossboundaries… https://t.co/gOQKv6oPrr\n",
      "---------------\n",
      "Tweet:\n",
      "Pin Chun Kuo’s maximalist polaroids are inspired by doomsday🌎\n",
      "\n",
      "Since 2012, the artist has taken a self-portrait eac… https://t.co/qJasFu4Sao\n",
      "---------------\n",
      "Tweet:\n",
      ".@GlassAnimals' \"Heat Waves\" rises 2-1 on the list dated May 8, becoming the English band's first ruler on the rank… https://t.co/mtQeg3Bzao\n",
      "---------------\n",
      "Tweet:\n",
      "Myanmar's military has brought back the \"bad old days\" of fear, disappearances and killings. But the resistance isn… https://t.co/qLZgAPwfvC\n",
      "---------------\n",
      "Tweet:\n",
      "Zahrah’s story is a reminder that the Obama Presidential Center isn’t just about creating a place for people to vis… https://t.co/8B9AH2XAKe\n",
      "---------------\n",
      "Tweet:\n",
      "From an installation by @VanCleefArpels to @Prada’s organic denim collection, these new arrivals will not disappoint https://t.co/AUBj3F0MpL\n",
      "---------------\n",
      "Tweet:\n",
      "Everything We Know About Amanda Seyfried's New Show ‘The Dropout' https://t.co/YdHLPPyHpp\n",
      "---------------\n",
      "Tweet:\n",
      "\"But as I grew up, and dreams changed, the pursuit of being \"enough\" remained. It was there every time I wanted to… https://t.co/or7oiMYddX\n",
      "---------------\n",
      "Tweet:\n",
      "A Tennessee federal judge has sided with Don Everly in his long battle with his late brother Phil's family over who… https://t.co/ojO2QwRIXq\n",
      "---------------\n",
      "Tweet:\n",
      "Joe Jonas talking about his little girl and being a dad... 🥺 ❤️ https://t.co/uQNp5EhWun\n",
      "---------------\n",
      "Tweet:\n",
      "Tennis wins big at the 2021 @LaureusSport Awards!\n",
      "\n",
      "Olympic champ @RafaelNadal and Olympic hopeful @naomiosaka take… https://t.co/8i80qXbyxQ\n",
      "---------------\n",
      "Tweet:\n",
      "Novavax's COVID-19 vaccine was shown to be 51% efficacious in South Africa, where more infectious variants are spre… https://t.co/3uwTiV16Gu\n",
      "---------------\n",
      "Tweet:\n",
      "RT @GiladEdelman: Me: How about I do a big story telling readers what to think about Section 230? We could call it \"Everything you've heard…\n",
      "---------------\n",
      "Tweet:\n",
      "RT @KendallJenner: I have struggled with anxiety and panic attacks since i was a little girl. I wanted to dive deeper to better understand…\n",
      "---------------\n",
      "Tweet:\n",
      "Delaware County officials announce citizen board to help oversee troubled Juvenile Detention Center https://t.co/pOGb5yDwSD\n",
      "---------------\n",
      "Tweet:\n",
      "RT @LaurenGoode: And @GiladEdelman joins me and @snack on tomorrow's @gadgetlab podcast to unpack his excellent cover story — we promise it…\n",
      "---------------\n",
      "Tweet:\n",
      "Kenyan Beef Samosas https://t.co/1rQ4PnKl4X\n",
      "---------------\n",
      "Tweet:\n",
      "RT @nytopinion: We're wondering: What’s it like to have physical contact with friends and loved ones again post-vaccination? Follow the lin…\n",
      "---------------\n",
      "Tweet:\n",
      "RT @ScottThurm: IBM says it's devised a 2nm production process for chips, which would hold 50 billion transistors, and be 45% faster, or us…\n",
      "---------------\n",
      "Tweet:\n",
      "contemporary steel elements renovate the 19th century paris bourse du travail\n",
      "https://t.co/G0DuXpG1Ou https://t.co/tk6YQiD0zX\n",
      "---------------\n",
      "Tweet:\n",
      "RT @caitharr: If I had to fact-check one story by a lawyer with a bunch of other lawyers about the ins and outs of a controversial law, I’m…\n",
      "---------------\n",
      "Tweet:\n",
      "RT @ScottThurm: When @jetjocko asks you to \"nerd out\" with him, it's a good idea to go along. On vaccinations and hesitancy https://t.co/t2…\n",
      "---------------\n",
      "Tweet:\n",
      "Who could forget @SZA's angelic Met Gala gown? Or her glittering “Good Days” bikini?! https://t.co/7MQikXvAvq\n",
      "---------------\n",
      "Tweet:\n",
      "RT @kenandstuff: After some weeks, here we are again. Back in the waiting area and shot 2 is in the arm! \n",
      "\n",
      "Big shout outs to @LifeatBlizzar…\n",
      "---------------\n",
      "Tweet:\n",
      "Yes hang on, closer look. https://t.co/iMZ5WDG9ON\n",
      "---------------\n",
      "Tweet:\n",
      "In Vogue’s new four-part series, #OpenMinded, @KendallJenner pulls back the curtain on social anxiety and her exper… https://t.co/XZyNWIoE6P\n",
      "---------------\n",
      "Tweet:\n",
      "As @Calibre50’s “Vamos Bien” hits No. 1 on Billboard’s #RegionalMexicanAirplay chart, the band captures its 19th le… https://t.co/dH6IODcaYr\n",
      "---------------\n",
      "Tweet:\n",
      "Watch: John Cox, a Republican running for governor in California, has been criticized by animal welfare activists f… https://t.co/iNHwNHpuCC\n",
      "---------------\n"
     ]
    }
   ],
   "source": [
    "# Scrape my Twitter's timeline up to 200 tweets \n",
    "twitter_feed = api.home_timeline(200)\n",
    "\n",
    "for tweet in twitter_feed:\n",
    "    print(\"Tweet:\")\n",
    "    print(tweet.text)\n",
    "    print(\"---------------\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Get the User object for twitter...\n",
    "user = api.get_user('kiyokarina')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "User(_api=<tweepy.api.API object at 0x00000203F9330708>, _json={'id': 1328893583609487361, 'id_str': '1328893583609487361', 'name': 'Erika Yi', 'screen_name': 'kiyokarina', 'location': 'NJ, USA', 'profile_location': None, 'description': 'Designer | Data Scientist https://t.co/QdjbMzFOMM 🇰🇷 🇺🇲', 'url': 'https://t.co/r0FHP9gOqO', 'entities': {'url': {'urls': [{'url': 'https://t.co/r0FHP9gOqO', 'expanded_url': 'https://erikayidesign.com/', 'display_url': 'erikayidesign.com', 'indices': [0, 23]}]}, 'description': {'urls': [{'url': 'https://t.co/QdjbMzFOMM', 'expanded_url': 'http://erikayi.github.io', 'display_url': 'erikayi.github.io', 'indices': [26, 49]}]}}, 'protected': False, 'followers_count': 6, 'friends_count': 219, 'listed_count': 0, 'created_at': 'Wed Nov 18 02:51:48 +0000 2020', 'favourites_count': 73, 'utc_offset': None, 'time_zone': None, 'geo_enabled': False, 'verified': False, 'statuses_count': 58, 'lang': None, 'status': {'created_at': 'Wed May 05 23:19:22 +0000 2021', 'id': 1390083731331899393, 'id_str': '1390083731331899393', 'text': 'うわわわわわわわ\\nSpaceX Successfully Lands Prototype of Mars and Moon Rocket After Test Flight https://t.co/KhDBLdV5zE', 'truncated': False, 'entities': {'hashtags': [], 'symbols': [], 'user_mentions': [], 'urls': [{'url': 'https://t.co/KhDBLdV5zE', 'expanded_url': 'https://nyti.ms/3vDOX2G', 'display_url': 'nyti.ms/3vDOX2G', 'indices': [87, 110]}]}, 'source': '<a href=\"http://twitter.com/download/android\" rel=\"nofollow\">Twitter for Android</a>', 'in_reply_to_status_id': None, 'in_reply_to_status_id_str': None, 'in_reply_to_user_id': None, 'in_reply_to_user_id_str': None, 'in_reply_to_screen_name': None, 'geo': None, 'coordinates': None, 'place': None, 'contributors': None, 'is_quote_status': False, 'retweet_count': 0, 'favorite_count': 0, 'favorited': False, 'retweeted': False, 'possibly_sensitive': False, 'lang': 'en'}, 'contributors_enabled': False, 'is_translator': False, 'is_translation_enabled': False, 'profile_background_color': 'F5F8FA', 'profile_background_image_url': None, 'profile_background_image_url_https': None, 'profile_background_tile': False, 'profile_image_url': 'http://pbs.twimg.com/profile_images/1329608147804237824/WP-cmIUR_normal.jpg', 'profile_image_url_https': 'https://pbs.twimg.com/profile_images/1329608147804237824/WP-cmIUR_normal.jpg', 'profile_banner_url': 'https://pbs.twimg.com/profile_banners/1328893583609487361/1606180851', 'profile_link_color': '1DA1F2', 'profile_sidebar_border_color': 'C0DEED', 'profile_sidebar_fill_color': 'DDEEF6', 'profile_text_color': '333333', 'profile_use_background_image': True, 'has_extended_profile': True, 'default_profile': True, 'default_profile_image': False, 'following': False, 'follow_request_sent': False, 'notifications': False, 'translator_type': 'none', 'withheld_in_countries': [], 'suspended': False, 'needs_phone_verification': False}, id=1328893583609487361, id_str='1328893583609487361', name='Erika Yi', screen_name='kiyokarina', location='NJ, USA', profile_location=None, description='Designer | Data Scientist https://t.co/QdjbMzFOMM 🇰🇷 🇺🇲', url='https://t.co/r0FHP9gOqO', entities={'url': {'urls': [{'url': 'https://t.co/r0FHP9gOqO', 'expanded_url': 'https://erikayidesign.com/', 'display_url': 'erikayidesign.com', 'indices': [0, 23]}]}, 'description': {'urls': [{'url': 'https://t.co/QdjbMzFOMM', 'expanded_url': 'http://erikayi.github.io', 'display_url': 'erikayi.github.io', 'indices': [26, 49]}]}}, protected=False, followers_count=6, friends_count=219, listed_count=0, created_at=datetime.datetime(2020, 11, 18, 2, 51, 48), favourites_count=73, utc_offset=None, time_zone=None, geo_enabled=False, verified=False, statuses_count=58, lang=None, status=Status(_api=<tweepy.api.API object at 0x00000203F9330708>, _json={'created_at': 'Wed May 05 23:19:22 +0000 2021', 'id': 1390083731331899393, 'id_str': '1390083731331899393', 'text': 'うわわわわわわわ\\nSpaceX Successfully Lands Prototype of Mars and Moon Rocket After Test Flight https://t.co/KhDBLdV5zE', 'truncated': False, 'entities': {'hashtags': [], 'symbols': [], 'user_mentions': [], 'urls': [{'url': 'https://t.co/KhDBLdV5zE', 'expanded_url': 'https://nyti.ms/3vDOX2G', 'display_url': 'nyti.ms/3vDOX2G', 'indices': [87, 110]}]}, 'source': '<a href=\"http://twitter.com/download/android\" rel=\"nofollow\">Twitter for Android</a>', 'in_reply_to_status_id': None, 'in_reply_to_status_id_str': None, 'in_reply_to_user_id': None, 'in_reply_to_user_id_str': None, 'in_reply_to_screen_name': None, 'geo': None, 'coordinates': None, 'place': None, 'contributors': None, 'is_quote_status': False, 'retweet_count': 0, 'favorite_count': 0, 'favorited': False, 'retweeted': False, 'possibly_sensitive': False, 'lang': 'en'}, created_at=datetime.datetime(2021, 5, 5, 23, 19, 22), id=1390083731331899393, id_str='1390083731331899393', text='うわわわわわわわ\\nSpaceX Successfully Lands Prototype of Mars and Moon Rocket After Test Flight https://t.co/KhDBLdV5zE', truncated=False, entities={'hashtags': [], 'symbols': [], 'user_mentions': [], 'urls': [{'url': 'https://t.co/KhDBLdV5zE', 'expanded_url': 'https://nyti.ms/3vDOX2G', 'display_url': 'nyti.ms/3vDOX2G', 'indices': [87, 110]}]}, source='Twitter for Android', source_url='http://twitter.com/download/android', in_reply_to_status_id=None, in_reply_to_status_id_str=None, in_reply_to_user_id=None, in_reply_to_user_id_str=None, in_reply_to_screen_name=None, geo=None, coordinates=None, place=None, contributors=None, is_quote_status=False, retweet_count=0, favorite_count=0, favorited=False, retweeted=False, possibly_sensitive=False, lang='en'), contributors_enabled=False, is_translator=False, is_translation_enabled=False, profile_background_color='F5F8FA', profile_background_image_url=None, profile_background_image_url_https=None, profile_background_tile=False, profile_image_url='http://pbs.twimg.com/profile_images/1329608147804237824/WP-cmIUR_normal.jpg', profile_image_url_https='https://pbs.twimg.com/profile_images/1329608147804237824/WP-cmIUR_normal.jpg', profile_banner_url='https://pbs.twimg.com/profile_banners/1328893583609487361/1606180851', profile_link_color='1DA1F2', profile_sidebar_border_color='C0DEED', profile_sidebar_fill_color='DDEEF6', profile_text_color='333333', profile_use_background_image=True, has_extended_profile=True, default_profile=True, default_profile_image=False, following=False, follow_request_sent=False, notifications=False, translator_type='none', withheld_in_countries=[], suspended=False, needs_phone_verification=False)"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "user"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Twitter username:\n",
      "kiyokarina\n",
      "--------------------\n",
      "Followers Count:\n",
      "6\n",
      "--------------------\n",
      "Following Count:\n",
      "--------------------\n",
      "OldManYi\n",
      "Com2uS\n",
      "GAMEVIL\n",
      "heymichellelee\n",
      "iamcardib\n",
      "jiminpark07\n",
      "lilchoster\n",
      "official_ONEWE\n",
      "DKB_BRAVE\n",
      "_DPRREM\n",
      "dumbfoundead\n",
      "WM_ONOFF\n",
      "_DPRLIVE\n",
      "UP10TION\n",
      "H1GHRMUSIC\n",
      "OnlyOneOfmember\n",
      "official_ACE7\n",
      "DPRIAN_\n",
      "OnlyOneOf_twt\n",
      "VAV_official\n"
     ]
    }
   ],
   "source": [
    "print(\"Twitter username:\")\n",
    "print(user.screen_name)\n",
    "\n",
    "print(\"--------------------\")\n",
    "\n",
    "print(\"Followers Count:\")\n",
    "print(user.followers_count)\n",
    "\n",
    "print(\"--------------------\")\n",
    "print(\"Following Count:\")\n",
    "print(\"--------------------\")\n",
    "\n",
    "for friend in user.friends():\n",
    "    print(friend.screen_name)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Scraping from specific user's tweets"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [],
   "source": [
    "# username = \"jiminpark07\"\n",
    "# count = \"200\"\n",
    "\n",
    "try:     \n",
    " # Creation of query method using parameters\n",
    " tweets = tweepy.Cursor(api.user_timeline,id=\"jiminpark07\").items(200)\n",
    " \n",
    " # Pulling information from tweets iterable object\n",
    " tweets_list = [[tweet.created_at, tweet.id, tweet.text] for tweet in tweets]\n",
    " \n",
    " # Creation of dataframe from tweets list\n",
    " # Add or remove columns as you remove tweet information\n",
    " tweets_df = pd.DataFrame(tweets_list)\n",
    "\n",
    "except BaseException as e:\n",
    "      print('failed on_status,',str(e))\n",
    "      time.sleep(3)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[[datetime.datetime(2021, 4, 29, 9, 47, 19),\n",
       "  1387705044674523136,\n",
       "  '🖤😉 https://t.co/syp6WOzKBU'],\n",
       " [datetime.datetime(2021, 4, 22, 15, 17, 21),\n",
       "  1385251384413487107,\n",
       "  'RT @jamiestaffsays: 👭제이미, 찬미나가 참여한 Saweetie – Best Friend (feat. Doja Cat, JAMIE, CHANMINA)가 발매되었습니다!👭\\n\\n🔥Out Now🔥\\n🎵https://t.co/5gxm4q3ohh…'],\n",
       " [datetime.datetime(2021, 4, 19, 14, 40, 49),\n",
       "  1384155028131176448,\n",
       "  'RT @jamiestaffsays: 👭Saweetie – Best Friend (feat. Doja Cat, JAMIE, CHANMINA)👭\\n\\n🔥 제이미가 참여한 Saweetie – Best Friend (feat. Doja Cat, JAMIE, C…'],\n",
       " [datetime.datetime(2021, 4, 15, 22, 23, 25),\n",
       "  1382821893942611969,\n",
       "  '🔥 https://t.co/tennSQwtqX'],\n",
       " [datetime.datetime(2021, 4, 1, 8, 41, 13),\n",
       "  1377541548070477825,\n",
       "  'RT @jamiestaffsays: 👭Saweetie - Best Friend (feat. Doja Cat, Jamie, CHANMINA)👭\\n\\n🔥New release date coming soon🔥\\n\\n*음원 발매 일정이 변경되어 자세한 발매일은 추후…'],\n",
       " [datetime.datetime(2021, 3, 25, 15, 8, 18),\n",
       "  1375102246875144199,\n",
       "  'Yes..... I know🤯\\U0001f972🔥 https://t.co/Z2nb80Z9wa'],\n",
       " [datetime.datetime(2021, 3, 17, 21, 9, 33),\n",
       "  1372294056303194112,\n",
       "  '난 잘지내고 있어요! :) 잠이 아주 많아졌다는거! 잘온다는거! 잘 안듣던 노래도 요즘 많이 듣고, 예전에 봤던 영화도 다시 보면서 잘 지내구 있어요 , 건강해야해 다들! 사룽해🖤🖤 https://t.co/2tl5FcejUq'],\n",
       " [datetime.datetime(2021, 3, 6, 11, 59, 47),\n",
       "  1368169435870199814,\n",
       "  '@Jae_Day6 ^^'],\n",
       " [datetime.datetime(2021, 3, 3, 19, 26, 16), 1367194631872552960, 'Hehehe'],\n",
       " [datetime.datetime(2021, 3, 3, 5, 22, 8),\n",
       "  1366982199531110408,\n",
       "  '@thedivestudios Hey dive lets go on a date'],\n",
       " [datetime.datetime(2021, 3, 3, 5, 4, 15), 1366977701051920384, '♡´･ᴗ･`♡'],\n",
       " [datetime.datetime(2021, 2, 25, 14, 36, 58),\n",
       "  1364947502198185987,\n",
       "  'RT @jamiestaffsays: Joker (Feat. JAMIE) - BIG Naughty (서동현) - 들어보세요.\\n\\nhttps://t.co/2t9ySx1gwI\\n\\nby Melon https://t.co/GYyF6s2p22'],\n",
       " [datetime.datetime(2021, 2, 16, 14, 43, 48),\n",
       "  1361687731567398912,\n",
       "  '매주 화요일 키스! 팝스! https://t.co/QntlrjGgUJ'],\n",
       " [datetime.datetime(2021, 2, 16, 7, 44, 13),\n",
       "  1361582138823299078,\n",
       "  '왜저래.. https://t.co/9JvtYUyjBS'],\n",
       " [datetime.datetime(2021, 2, 8, 6, 38, 36),\n",
       "  1358666522634321921,\n",
       "  'Heiii👋🏻 https://t.co/sJ8jxnIBg9'],\n",
       " [datetime.datetime(2021, 2, 6, 12, 17, 51),\n",
       "  1358027120111284224,\n",
       "  '@jamiestaffsays Ur late ^_^'],\n",
       " [datetime.datetime(2021, 2, 2, 15, 47, 24),\n",
       "  1356630306317459459,\n",
       "  'RT @dntrunouttaS2: 이마탁탁때리는거ㅋㅋㅋㅋㅋ오늘도 제이미의 웃참으로 끝난 ASMR https://t.co/KCu0StqMqL'],\n",
       " [datetime.datetime(2021, 2, 2, 15, 42, 27), 1356629062018453504, '이마 아프네...'],\n",
       " [datetime.datetime(2021, 1, 29, 21, 44, 57),\n",
       "  1355270733656584196,\n",
       "  '🖤 https://t.co/IVeQtLrBoq'],\n",
       " [datetime.datetime(2021, 1, 27, 22, 10, 15),\n",
       "  1354552323943526400,\n",
       "  'RT @fifteenandxv: @jiminpark07 https://t.co/5CW0xWe6kt'],\n",
       " [datetime.datetime(2021, 1, 27, 22, 9, 52),\n",
       "  1354552227445137409,\n",
       "  'RT @arzu_twt: @jiminpark07 hey i did the edit for you too 🥺💚 please notice, you’re the loml  https://t.co/FxJvQIH156'],\n",
       " [datetime.datetime(2021, 1, 27, 22, 9, 30),\n",
       "  1354552137221464065,\n",
       "  \"RT @wonuies: @jiminpark07 heyy bubs i already told u but i thought id let u know again hhh ur name will fly on nasa's next mission to mars…\"],\n",
       " [datetime.datetime(2021, 1, 27, 22, 7, 53),\n",
       "  1354551729719631874,\n",
       "  'If you can’t stand a hate for yourself for hating others why hate? There’s an whole video about me talking about ha… https://t.co/aKhVyfIXUR'],\n",
       " [datetime.datetime(2021, 1, 27, 22, 7, 15),\n",
       "  1354551568817745921,\n",
       "  'RT @taemizlik: @jiminpark07 look what i did for you🥺🥺https://t.co/7UzQS6nMfy'],\n",
       " [datetime.datetime(2021, 1, 27, 22, 5, 49),\n",
       "  1354551211232432129,\n",
       "  '[제작비지원] 오마이걸아린x이사배x제이미 #악플 이런 말까지 들어봤다고? https://t.co/SZmn0KLXHZ'],\n",
       " [datetime.datetime(2021, 1, 27, 21, 58, 50),\n",
       "  1354549453802225665,\n",
       "  'If you make babyj’s get worried cause I might see a hate comment about myself and have to make them use their preci… https://t.co/gGtdfbTi0l'],\n",
       " [datetime.datetime(2021, 1, 19, 6, 18, 29),\n",
       "  1351413702549925897,\n",
       "  'RT @Airbnb: 💄 get ready with @jiminpark07\\n🔗 https://t.co/gj9GZKQK45\\n\\n#제이미 🧡 https://t.co/gklZaNM2p4'],\n",
       " [datetime.datetime(2021, 1, 19, 6, 17, 21),\n",
       "  1351413419216257025,\n",
       "  'Yes we’re doing makeup https://t.co/7XKNVWnijb'],\n",
       " [datetime.datetime(2021, 1, 4, 9, 34, 10),\n",
       "  1346027131550109696,\n",
       "  'Jemora💋 https://t.co/iYITO7AJdJ'],\n",
       " [datetime.datetime(2021, 1, 1, 8, 14, 19),\n",
       "  1344919870673096705,\n",
       "  'RT @jamiestaffsays: 1. Happy New Years Eve \\n#JAMIE #JAMIEPARK #제이미 https://t.co/h61jdOPnYH'],\n",
       " [datetime.datetime(2021, 1, 1, 8, 14, 11), 1344919838943186946, '2021/1/1'],\n",
       " [datetime.datetime(2020, 12, 28, 4, 25, 59),\n",
       "  1343412856335679488,\n",
       "  '❤️❤️ https://t.co/ErH6hkLTE3'],\n",
       " [datetime.datetime(2020, 12, 27, 8, 42, 58),\n",
       "  1343115144205717505,\n",
       "  'RT @kr_now: #크리스마스 파티 in #지오디 #점심어택 방송 내내 찐 친구케미로😹 서로를 향해 말을 아끼지 않았던 #제이미 #가호 집에 갈 땐 사이좋게 갔다고 합니다😉 앞으로도 멋진 음악작업 기대할게요👏🏻🎹 녹음하다 싸우지말구.. #NOW온…'],\n",
       " [datetime.datetime(2020, 12, 26, 15, 7, 53),\n",
       "  1342849623564554240,\n",
       "  '\\U0001f90d https://t.co/US5FZFoDXz'],\n",
       " [datetime.datetime(2020, 12, 24, 6, 47, 15),\n",
       "  1341998855995285505,\n",
       "  '@jamieloops_ Nooooo everyone’s just tall \\U0001f978'],\n",
       " [datetime.datetime(2020, 12, 24, 6, 45, 3),\n",
       "  1341998304083644416,\n",
       "  'RT @jamiestaffsays: 8. 오늘도 이쁜 @jiminpark07 보고 행복한 하루 되세요!\\n#JAMIE #JAMIEPARK #제이미 https://t.co/Cp4YNtXs6K'],\n",
       " [datetime.datetime(2020, 12, 24, 2, 57, 8),\n",
       "  1341940948704448512,\n",
       "  '🙏🏻❤️고마워요! Merry Christmas! https://t.co/ynm4O7HBLl'],\n",
       " [datetime.datetime(2020, 12, 24, 2, 56, 42),\n",
       "  1341940836993396736,\n",
       "  'RT @7OC_official: [#훈노래방]\\n\\n오늘 들려드릴 노래는 제가 요새 즐겨듣는 #JAMIE 선배님의 #5가지_Christmas 입니다! 너무 신나고 들으면 들을수록 행복해지더라구요☺️\\n로즈들 Merry Christmas🎁🎄🎅\\n\\n#세븐어클락…'],\n",
       " [datetime.datetime(2020, 12, 23, 4, 35, 27),\n",
       "  1341603299569516544,\n",
       "  '@jamiestaffsays 네\\U0001f978\\U0001f978'],\n",
       " [datetime.datetime(2020, 12, 23, 4, 34, 57),\n",
       "  1341603175929823232,\n",
       "  'RT @jamiestaffsays: 9. 놀랬죠?!\\n#JAMIE #JAMIEPARK #제이미 https://t.co/qw9lzTWqSI'],\n",
       " [datetime.datetime(2020, 12, 22, 13, 39, 26),\n",
       "  1341377810187751424,\n",
       "  'https://t.co/tZfR2GOfAa live collab with pete\\U0001f978'],\n",
       " [datetime.datetime(2020, 12, 22, 12, 39, 35),\n",
       "  1341362751742996482,\n",
       "  'RT @jamiestaffsays: 10. 진짜 이유 없어요! 그냥 이뻐서요!\\n#JAMIE #JAMIEPARK #제이미 https://t.co/tg82L6meND'],\n",
       " [datetime.datetime(2020, 12, 22, 11, 48, 18),\n",
       "  1341349844938473473,\n",
       "  'Now THIS was something https://t.co/OmL9bf53r7'],\n",
       " [datetime.datetime(2020, 12, 22, 10, 43, 13),\n",
       "  1341333465849946113,\n",
       "  '❤️🥰💋\\U0001f978 https://t.co/dhGfvun3xf'],\n",
       " [datetime.datetime(2020, 12, 19, 15, 26, 18),\n",
       "  1340317542343081984,\n",
       "  '@jamiestaffsays Why are we sorry'],\n",
       " [datetime.datetime(2020, 12, 19, 12, 8, 31),\n",
       "  1340267765882474496,\n",
       "  \"RT @KAVECON: D-DAY! \\n&lt;JAMIE'S COZY C❄NCERT&gt;\\nLIVE 2020.12.19 SAT 10PM KST\\n\\n#Jamie 's concert will start in about an hour!\\nIf you haven't got…\"],\n",
       " [datetime.datetime(2020, 12, 15, 9, 57, 56),\n",
       "  1338785355667947521,\n",
       "  '❤️❤️🙏🏻 https://t.co/p8y7yioWv2'],\n",
       " [datetime.datetime(2020, 12, 15, 9, 55, 5),\n",
       "  1338784638945267712,\n",
       "  '🦋🦋 whaaaaaaaaat thisss sattt🦋🦋 https://t.co/LRcfIwBZuf'],\n",
       " [datetime.datetime(2020, 12, 14, 13, 46, 21),\n",
       "  1338480448205246464,\n",
       "  '❤️❤️❤️ https://t.co/LhfucxKHFp'],\n",
       " [datetime.datetime(2020, 12, 13, 15, 2, 15),\n",
       "  1338137161757904899,\n",
       "  '내 인생에 안무 영상이라는게 올라오다니..... https://t.co/eGzjdB77lU'],\n",
       " [datetime.datetime(2020, 12, 13, 12, 17, 33),\n",
       "  1338095714061053952,\n",
       "  '19일에 보자궁🥺 https://t.co/3LxXMoA5cu'],\n",
       " [datetime.datetime(2020, 12, 10, 12, 16, 45),\n",
       "  1337008350442078208,\n",
       "  '🥰 https://t.co/1Yk9CC3cXk'],\n",
       " [datetime.datetime(2020, 12, 10, 7, 59, 7),\n",
       "  1336943513653530624,\n",
       "  'Concert???????🤭 YES CONCERTTT https://t.co/ljgazV4Rjs'],\n",
       " [datetime.datetime(2020, 12, 9, 15, 7, 27),\n",
       "  1336688918452826112,\n",
       "  '🧐 https://t.co/bDelWyH5ga'],\n",
       " [datetime.datetime(2020, 12, 9, 13, 34, 18),\n",
       "  1336665478308106240,\n",
       "  '💋💋💋 https://t.co/2Fx3jzdS0s'],\n",
       " [datetime.datetime(2020, 12, 9, 13, 34, 8),\n",
       "  1336665434913816577,\n",
       "  'https://t.co/qQJjUtc8Wd WHATS URS BABYJ🤓'],\n",
       " [datetime.datetime(2020, 12, 8, 15, 1, 1),\n",
       "  1336324912013721606,\n",
       "  'What am I looking at tho. https://t.co/km8rbngb4h'],\n",
       " [datetime.datetime(2020, 12, 8, 15, 0, 38),\n",
       "  1336324814630342657,\n",
       "  'SEE U TMMR❤️ https://t.co/cUvxmsQSJX'],\n",
       " [datetime.datetime(2020, 12, 7, 15, 23, 15),\n",
       "  1335968120423346176,\n",
       "  '🤭🤭❤️ https://t.co/TDouqQgGZa'],\n",
       " [datetime.datetime(2020, 12, 6, 7, 30, 29),\n",
       "  1335486754678173696,\n",
       "  'https://t.co/VRaJxcCfSy HURRYYY🙏🏻❤️'],\n",
       " [datetime.datetime(2020, 12, 4, 14, 7, 27), 1334861881329164289, '❄️❄️❄️'],\n",
       " [datetime.datetime(2020, 12, 3, 5, 12, 12),\n",
       "  1334364790932733952,\n",
       "  'Oh wow @justinohmusic OUR SONG IS THERE🙏🏻🥺!!! https://t.co/4mablZXjWg'],\n",
       " [datetime.datetime(2020, 12, 2, 14, 12, 33),\n",
       "  1334138386857164800,\n",
       "  '@crystalbell ❤️❤️'],\n",
       " [datetime.datetime(2020, 12, 2, 11, 21, 33),\n",
       "  1334095353524588549,\n",
       "  '@KianaLede I love your story and your voice 🙏🏻🙏🏻🙏🏻❤️❤️'],\n",
       " [datetime.datetime(2020, 12, 2, 11, 13, 27),\n",
       "  1334093314547597312,\n",
       "  '🙏🏻🥺 https://t.co/za5iozExz7'],\n",
       " [datetime.datetime(2020, 12, 2, 11, 2, 23),\n",
       "  1334090531043872771,\n",
       "  'But I’m going to dance if YOU DANCE WITH ME'],\n",
       " [datetime.datetime(2020, 12, 2, 11, 1, 53),\n",
       "  1334090407379013634,\n",
       "  'But at the same time it doesn’t mean I can dance 😗'],\n",
       " [datetime.datetime(2020, 12, 2, 11, 1, 9),\n",
       "  1334090220732485634,\n",
       "  'I’d love to see ur moves, cause I’m ready to show mine. https://t.co/Rtip7Q7chA'],\n",
       " [datetime.datetime(2020, 12, 2, 10, 46, 5),\n",
       "  1334086428595159041,\n",
       "  '2020 MASHUP🖤 Jamie ver. https://t.co/QhpoIQrFzE'],\n",
       " [datetime.datetime(2020, 11, 30, 4, 0, 54),\n",
       "  1333259687668551681,\n",
       "  '2020.12.19 https://t.co/WWzJXazjwm'],\n",
       " [datetime.datetime(2020, 11, 26, 10, 3, 36),\n",
       "  1331901409206312960,\n",
       "  'https://t.co/WJ8602xYj3 making film🙏🏻'],\n",
       " [datetime.datetime(2020, 11, 23, 9, 11, 58),\n",
       "  1330801251538223105,\n",
       "  'https://t.co/XVi3ZQrH7w @ArianaGrande  I love you\\U0001f90d🤧'],\n",
       " [datetime.datetime(2020, 11, 18, 9, 27, 27),\n",
       "  1328993209658220545,\n",
       "  'https://t.co/Z0RBoeAcZV BAND VERSION❤️'],\n",
       " [datetime.datetime(2020, 11, 16, 9, 27, 6),\n",
       "  1328268347142676480,\n",
       "  'https://t.co/xlQgAwJJku I wish'],\n",
       " [datetime.datetime(2020, 11, 16, 7, 24, 46),\n",
       "  1328237559781093376,\n",
       "  '🤧🥺 https://t.co/JR8nePqTdK'],\n",
       " [datetime.datetime(2020, 11, 13, 8, 7, 9),\n",
       "  1327161062395760641,\n",
       "  '🙏🏻😌 https://t.co/BCWysCKimL'],\n",
       " [datetime.datetime(2020, 11, 12, 5, 6, 34), 1326753228956987392, '고마워'],\n",
       " [datetime.datetime(2020, 11, 11, 10, 45, 19),\n",
       "  1326476092497039360,\n",
       "  'RT @gems_genie: [음악의 색을 플레이하다 #PLAYCOLOR🎨 ]\\n\\n플레이컬러 네번째 주자❗ 제이미가 펼치는 환상적인 캐시미어블루 빛 음악💙 11월 13일 밤 5시 지니 유튜브에서 만나요  #JAMIE #Apollo11 @jiminpar…'],\n",
       " [datetime.datetime(2020, 11, 11, 10, 44, 35),\n",
       "  1326475904449536004,\n",
       "  '🥺🥺🥺 https://t.co/LoGqDQvxa7'],\n",
       " [datetime.datetime(2020, 11, 10, 2, 8, 44),\n",
       "  1325983701335826432,\n",
       "  'https://t.co/QnltnDxE0J Apollo11 🛸\\U0001f90d teaser🚀'],\n",
       " [datetime.datetime(2020, 11, 9, 3, 50, 46),\n",
       "  1325646990399528968,\n",
       "  'With Jay🛸park\\U0001f90d https://t.co/pLl0L7CReA'],\n",
       " [datetime.datetime(2020, 11, 7, 0, 6, 3),\n",
       "  1324865663895134210,\n",
       "  'RT @jamiestaffsays: JAMIE - APOLLO 11\\n2020.11.11\\n18:00 KST\\n#JAMIE #JAMIEPARK #제이미 #APOLLO11 #1111 https://t.co/SDAhVFB9l2'],\n",
       " [datetime.datetime(2020, 11, 7, 0, 5, 50),\n",
       "  1324865607255252993,\n",
       "  '#apollo11 🛸🖤 https://t.co/dGn3dUh6zz'],\n",
       " [datetime.datetime(2020, 11, 5, 14, 57, 57),\n",
       "  1324365342550810625,\n",
       "  '\\U0001f90d🛸\\U0001f90d https://t.co/2ov5Ae9xNs'],\n",
       " [datetime.datetime(2020, 11, 4, 14, 9, 51),\n",
       "  1323990847814201344,\n",
       "  '#apollo11 #jamiecomeback1111 https://t.co/kG1TrhKc9H'],\n",
       " [datetime.datetime(2020, 11, 4, 14, 1, 58),\n",
       "  1323988864147488768,\n",
       "  '🚀🛸🚀 https://t.co/wktwkojAa7'],\n",
       " [datetime.datetime(2020, 10, 28, 11, 37, 29),\n",
       "  1321415789350588416,\n",
       "  '@kevinwoo91 https://t.co/Dl99eAlLLk'],\n",
       " [datetime.datetime(2020, 10, 28, 7, 5, 43),\n",
       "  1321347397197291520,\n",
       "  '👌🏻👤🙋🏻\\u200d♀️💪🏻'],\n",
       " [datetime.datetime(2020, 10, 27, 21, 32, 28), 1321203134861996034, '🛸🛸🛸'],\n",
       " [datetime.datetime(2020, 10, 8, 13, 7, 52),\n",
       "  1314190777908518913,\n",
       "  '@kevinwoo91 Oppar? https://t.co/bry212m8wG'],\n",
       " [datetime.datetime(2020, 10, 6, 8, 20, 7),\n",
       "  1313393587472662528,\n",
       "  '10000000 points https://t.co/nQtL9otg9d'],\n",
       " [datetime.datetime(2020, 10, 6, 5, 28, 1),\n",
       "  1313350277496365056,\n",
       "  '...🌺 https://t.co/OnSaxI2z10'],\n",
       " [datetime.datetime(2020, 10, 2, 14, 11, 55), 1312032568120729602, '11:11'],\n",
       " [datetime.datetime(2020, 10, 2, 9, 48, 1),\n",
       "  1311966158401101825,\n",
       "  'RT @MDRomeda_KPOP: #제이미 가 커버한 #레드벨벳 #몬스터 \\n진짜 웅장하고 치명적이고 하아,,, 다해라 \\n\\n#jamie covered #redvelvet #monster \\n🔽🔽🔽🔽🔽\\nhttps://t.co/KW8vCL7nyT\\n\\n@jim…'],\n",
       " [datetime.datetime(2020, 10, 2, 9, 47, 56),\n",
       "  1311966133369536512,\n",
       "  'RT @MDRomeda_KPOP: #제이미 신곡 \"Numbers\" 라이브!\\n브라스 밴드랑 하니까 진짜 도라따.....\\n\\n#jamie \\'s new song #numbers #live\\nfantastic live performance!!!!\\n🔽🔽🔽🔽🔽\\nh…'],\n",
       " [datetime.datetime(2020, 10, 2, 9, 47, 45),\n",
       "  1311966091401338880,\n",
       "  'https://t.co/DEjm05Tfw4 NUMBERS💓'],\n",
       " [datetime.datetime(2020, 10, 2, 9, 40, 55),\n",
       "  1311964369903742976,\n",
       "  'https://t.co/ZfQwcalD5c MONSTER💜🖤'],\n",
       " [datetime.datetime(2020, 10, 2, 5, 8, 7),\n",
       "  1311895717716217856,\n",
       "  '@MDRomeda_KPOP Jamie 에요 jamie!!!!'],\n",
       " [datetime.datetime(2020, 10, 1, 18, 31, 54),\n",
       "  1311735607069085696,\n",
       "  'RT @MDRomeda_KPOP: #제이미 의 성량 폭발 라이브!!!\\n#레드벨벳 #아이린, #슬기 의 \"monster\"커버까지!!!!\\n@jiminpark07 \\n\\n#JAIME sang her new song \"numbers\"\\nand covered #m…'],\n",
       " [datetime.datetime(2020, 9, 28, 3, 47, 25),\n",
       "  1310425856737603585,\n",
       "  'Everything I do, I do it with a passion.     If I gotta be a bad bitch Imma be a bad one.'],\n",
       " [datetime.datetime(2020, 9, 24, 11, 48, 16),\n",
       "  1309097315404308485,\n",
       "  '사랑해 현승희 https://t.co/1VckQoRn00'],\n",
       " [datetime.datetime(2020, 9, 24, 11, 47, 39),\n",
       "  1309097158986141699,\n",
       "  '@KOR_McDonalds 아진짜 너무 귀여운거 아니야....?;;;'],\n",
       " [datetime.datetime(2020, 9, 22, 13, 16, 45),\n",
       "  1308394807614738434,\n",
       "  '@JE0NSKRRT Then I’m sure u will like my next one too💜'],\n",
       " [datetime.datetime(2020, 9, 22, 13, 15, 3),\n",
       "  1308394379044765696,\n",
       "  '@jamie_i_loveyou 내가 더 사랑하는데 프사 무슨일이야! 아가!'],\n",
       " [datetime.datetime(2020, 9, 22, 13, 13, 21),\n",
       "  1308393951699722240,\n",
       "  '@babyJ_amie You can’t say that cause it can never be more than mine'],\n",
       " [datetime.datetime(2020, 9, 22, 13, 10, 57),\n",
       "  1308393346834952198,\n",
       "  '라뷰라뷰\\U0001f90d'],\n",
       " [datetime.datetime(2020, 9, 21, 7, 9, 19),\n",
       "  1307939953750364160,\n",
       "  'RT @40GlobalShow: ✌KPOP✌\\n\\nUsa el HT #40GlobalShow261 para pedir a tus artistas de la semana que viene. \\n\\n@TonyAguilarOfi hoy nos presenta a…'],\n",
       " [datetime.datetime(2020, 9, 17, 5, 47, 56),\n",
       "  1306469920251674624,\n",
       "  '@leehi_hi How to get away with murder , umbrella academy, revenge'],\n",
       " [datetime.datetime(2020, 9, 17, 4, 3, 14),\n",
       "  1306443571113857025,\n",
       "  '@Jae_Day6 Where’s mine Jae'],\n",
       " [datetime.datetime(2020, 9, 16, 12, 4, 58),\n",
       "  1306202414802849792,\n",
       "  '@jamiestaffsays 2020년 기준 브루클린 버거 입니다'],\n",
       " [datetime.datetime(2020, 9, 16, 12, 1, 40),\n",
       "  1306201583949021184,\n",
       "  'https://t.co/2Bjg1R8Sns BEHIND💗'],\n",
       " [datetime.datetime(2020, 9, 11, 11, 48, 51), 1304386419587076096, 'Heyy wyd'],\n",
       " [datetime.datetime(2020, 9, 9, 11, 3, 52),\n",
       "  1303650324603793409,\n",
       "  'https://t.co/NpEb5TUVTV 💗HELLOOKNOCKK✊🏻'],\n",
       " [datetime.datetime(2020, 9, 8, 14, 19, 39),\n",
       "  1303337205033660416,\n",
       "  '담에 또 불러주세요 아돌라! @idolradiokorea'],\n",
       " [datetime.datetime(2020, 9, 8, 11, 14, 13),\n",
       "  1303290538993487872,\n",
       "  '😝😝😝 https://t.co/v9L2gTeIoV'],\n",
       " [datetime.datetime(2020, 9, 4, 10, 16, 36),\n",
       "  1301826488379949056,\n",
       "  'https://t.co/wTSRzOnE1a DINGO💚 https://t.co/r0yADS1lUO'],\n",
       " [datetime.datetime(2020, 9, 4, 7, 33, 39),\n",
       "  1301785481374396418,\n",
       "  'Later ! With Dingo🤭 https://t.co/FfRvwflLMn'],\n",
       " [datetime.datetime(2020, 9, 4, 1, 41, 35),\n",
       "  1301696881437810688,\n",
       "  'https://t.co/A2KcFKpQFg 라비오빠랑🙏🏻🖤'],\n",
       " [datetime.datetime(2020, 9, 3, 11, 13, 59),\n",
       "  1301478542958452736,\n",
       "  'Nice🙏🏻 https://t.co/7bbAecA1CE'],\n",
       " [datetime.datetime(2020, 9, 3, 9, 15, 2),\n",
       "  1301448607745228803,\n",
       "  'https://t.co/1KDH6WYvxo 💜💜💜MV💜💜💜'],\n",
       " [datetime.datetime(2020, 9, 3, 9, 4, 8),\n",
       "  1301445866218123264,\n",
       "  'Out now! #numbers https://t.co/qVESd17FOw'],\n",
       " [datetime.datetime(2020, 9, 3, 2, 30, 11),\n",
       "  1301346722015096832,\n",
       "  '오늘 ❤️NUMBERS❤️ @sbscultwoshow  에서 발매전에 불러요! 이따가 봐요🥰 https://t.co/7lewTMoDzq 여기서 스케줄 올릴 예정💚'],\n",
       " [datetime.datetime(2020, 9, 3, 2, 29, 6),\n",
       "  1301346450517884928,\n",
       "  'https://t.co/7lewTMoDzq 🍒 Schedules will be uploaded here🍒'],\n",
       " [datetime.datetime(2020, 9, 3, 2, 26, 53),\n",
       "  1301345893770080256,\n",
       "  'Oh and do you guys know I’m going to sing ❤️NUMBERS❤️ before it releases today on “컬투쇼” @sbscultwoshow 🥰'],\n",
       " [datetime.datetime(2020, 9, 3, 2, 12, 53),\n",
       "  1301342372165349378,\n",
       "  'https://t.co/h6eHzlPlpu it hits me different every time I get to sing this song to you. You are beautiful today don’t forget to smile :)'],\n",
       " [datetime.datetime(2020, 9, 2, 0, 32, 6),\n",
       "  1300954618252288000,\n",
       "  \"RT @allkpop: Jamie (Park Ji Min) drops a party MV teaser for her upcoming single 'Numbers (feat. Changmo)'\\nhttps://t.co/YHTfI2lu4G https://…\"],\n",
       " [datetime.datetime(2020, 9, 2, 0, 31, 58),\n",
       "  1300954584353878016,\n",
       "  'RT @soompi: WATCH: #Jamie Gets The Party Started In MV Teaser For “Numbers” Featuring Changmo https://t.co/ncatCevfje https://t.co/pxKbFwYW…'],\n",
       " [datetime.datetime(2020, 9, 1, 19, 14, 16),\n",
       "  1300874633906855936,\n",
       "  '🤪🥺 https://t.co/S1eHY1L2U1'],\n",
       " [datetime.datetime(2020, 9, 1, 5, 34, 17),\n",
       "  1300668278709264384,\n",
       "  'Excuuuuuse me ? Numbers is commin out wen? https://t.co/NvJAcvtOXs'],\n",
       " [datetime.datetime(2020, 8, 31, 15, 5, 49),\n",
       "  1300449723606679554,\n",
       "  '@jamiestaffsays 똑같죠? 빼오앵오 빼오빼오앵오~'],\n",
       " [datetime.datetime(2020, 8, 31, 15, 1, 24),\n",
       "  1300448610115489793,\n",
       "  'https://t.co/f13jJz94VF NUMBERS teasing u with 16seconds'],\n",
       " [datetime.datetime(2020, 8, 31, 15, 0, 18),\n",
       "  1300448331433299969,\n",
       "  'https://t.co/o9MftQjxdm 🍒JAMIEYOUTUBE❤️'],\n",
       " [datetime.datetime(2020, 8, 30, 15, 11, 48),\n",
       "  1300088840036605952,\n",
       "  'RT @jamiestaffsays: Jamie – Numbers feat. Changmo\\n2020.09.03\\n18:00 KST\\n#JAMIE #JAMIEPARK #제이미 #NUMBERS #넘버스 https://t.co/Fp95AysNsi'],\n",
       " [datetime.datetime(2020, 8, 30, 15, 0, 24),\n",
       "  1300085972185436160,\n",
       "  '❤️❤️❤️❤️ https://t.co/LdQnp37w1C'],\n",
       " [datetime.datetime(2020, 8, 27, 15, 1, 43),\n",
       "  1298999140458704900,\n",
       "  'RT @jamiestaffsays: Jamie – Numbers\\n2020.09.03\\n18:00 KST\\n#JAMIE #JAMIEPARK #제이미 #NUMBERS #넘버스 https://t.co/DLnLIaeGQy'],\n",
       " [datetime.datetime(2020, 8, 26, 15, 10, 37),\n",
       "  1298638991512592385,\n",
       "  '❗️#numbers https://t.co/jPORsQJTG3'],\n",
       " [datetime.datetime(2020, 8, 25, 15, 2, 26),\n",
       "  1298274541194506247,\n",
       "  '🍒 #numbers https://t.co/bqgElQ5SqU'],\n",
       " [datetime.datetime(2020, 8, 25, 9, 6),\n",
       "  1298184844548087809,\n",
       "  '@jamiestaffsays 오빠 맛있게 드셨자나요...🥺'],\n",
       " [datetime.datetime(2020, 8, 24, 6, 38, 3),\n",
       "  1297785221564137472,\n",
       "  '🥰🥰 https://t.co/IyqFXdl82y'],\n",
       " [datetime.datetime(2020, 8, 24, 6, 37, 52),\n",
       "  1297785175003168768,\n",
       "  '👏🏻💗 https://t.co/Ek8aq4YKMi'],\n",
       " [datetime.datetime(2020, 8, 23, 15, 15),\n",
       "  1297552931449737216,\n",
       "  '@jamiestaffsays I saw that'],\n",
       " [datetime.datetime(2020, 8, 23, 15, 14, 49),\n",
       "  1297552884700086273,\n",
       "  'NUMBERS @jamiestaffsays 💗 https://t.co/XFNmwJ4iJ8'],\n",
       " [datetime.datetime(2020, 8, 19, 19, 55, 3),\n",
       "  1296173853383696384,\n",
       "  'So what’s ur guess'],\n",
       " [datetime.datetime(2020, 8, 19, 19, 47, 17),\n",
       "  1296171900486316032,\n",
       "  '🤔 https://t.co/e5OKkYBQCI'],\n",
       " [datetime.datetime(2020, 8, 19, 10, 9, 9),\n",
       "  1296026410666999808,\n",
       "  'https://t.co/SytVzkZX5Y 💙🥺'],\n",
       " [datetime.datetime(2020, 8, 1, 11, 48, 26),\n",
       "  1289528411833004034,\n",
       "  'This song is always BOP https://t.co/jRVqkJyVc2'],\n",
       " [datetime.datetime(2020, 7, 31, 18, 50, 7),\n",
       "  1289272145449648130,\n",
       "  '@jamiebabyj ❤️ https://t.co/YsDW7d0Sgr'],\n",
       " [datetime.datetime(2020, 7, 31, 18, 49, 30),\n",
       "  1289271988570054656,\n",
       "  '@wonuies 🥺 https://t.co/eE4alLzyLs'],\n",
       " [datetime.datetime(2020, 7, 31, 18, 42, 4),\n",
       "  1289270119881773056,\n",
       "  '💟💟💟 https://t.co/5REGcgviRL'],\n",
       " [datetime.datetime(2020, 7, 31, 15, 2, 51),\n",
       "  1289214951022710789,\n",
       "  '@jamie_babyJ @dingo_official 오타 난듯..;'],\n",
       " [datetime.datetime(2020, 7, 31, 11, 1, 10),\n",
       "  1289154129193885696,\n",
       "  '🥺🥺🥺🥺🥺🥺🥺🥺 https://t.co/Rl7okgoruj'],\n",
       " [datetime.datetime(2020, 7, 27, 9, 24, 19),\n",
       "  1287680205746667520,\n",
       "  'Had so much fun 🙏🏻🔥 https://t.co/UX4TFh7bxE'],\n",
       " [datetime.datetime(2020, 7, 25, 9, 7, 42),\n",
       "  1286951247275155456,\n",
       "  'My Last ep with 올때밐😭 https://t.co/QbApdcPwqT'],\n",
       " [datetime.datetime(2020, 7, 23, 12, 11, 58),\n",
       "  1286272844700119040,\n",
       "  'Hmmmmmm https://t.co/r4lzePvSPy'],\n",
       " [datetime.datetime(2020, 7, 17, 4, 2, 35),\n",
       "  1283975359784869894,\n",
       "  '@Jae_Day6 Are you talking about one of the Kpopstar days ? I mean me too'],\n",
       " [datetime.datetime(2020, 7, 14, 10, 2, 6),\n",
       "  1282978672492679168,\n",
       "  '@day6vz @lovejamiepark 에구...'],\n",
       " [datetime.datetime(2020, 7, 11, 11, 49, 2),\n",
       "  1281918420204662784,\n",
       "  'Hi https://t.co/tMShRjVwIU'],\n",
       " [datetime.datetime(2020, 7, 8, 15, 8, 39),\n",
       "  1280881489991761920,\n",
       "  '@mingkki21 헹헹! 언니이🥺❤️'],\n",
       " [datetime.datetime(2020, 7, 8, 15, 7, 17),\n",
       "  1280881146130083842,\n",
       "  'Busy? https://t.co/eoB9XR3Noa'],\n",
       " [datetime.datetime(2020, 7, 7, 11, 28, 50),\n",
       "  1280463784532836353,\n",
       "  'https://t.co/OtZnkXVdHo REAL FRIENDS COVER W/soovi'],\n",
       " [datetime.datetime(2020, 7, 7, 2, 22, 19),\n",
       "  1280326247147376641,\n",
       "  'https://t.co/hag6NfiwRm If u want to watch me for 15min straight 🤪'],\n",
       " [datetime.datetime(2020, 7, 6, 11, 9, 12),\n",
       "  1280096454212677634,\n",
       "  'I meann CAMPFIRE? https://t.co/6IlEI1RnE0'],\n",
       " [datetime.datetime(2020, 7, 5, 15, 20, 11),\n",
       "  1279797230543810560,\n",
       "  'RT @idolradiokorea: 7/6 ~ 7/12 #아이돌라디오 출연진\\n\\n6(월) AB6IX\\n7(화) 위클리\\n8(수) 써드아이\\n9(목) SF9 \\n10(금) 솔지,치타,제이미\\n11(토) GOT7 영재, DAY6 영케이\\n12(일) 솔지,제이미 ht…'],\n",
       " [datetime.datetime(2020, 7, 5, 14, 46, 45),\n",
       "  1279788816019013639,\n",
       "  '🖤LOVE YOU🖤 https://t.co/ZF9DYxZvr0'],\n",
       " [datetime.datetime(2020, 7, 5, 10, 28, 25),\n",
       "  1279723803564601349,\n",
       "  '@kevinwoo91 🥺🙏🏻😭'],\n",
       " [datetime.datetime(2020, 7, 4, 15, 19, 11),\n",
       "  1279434591112032257,\n",
       "  '😭🥺❤️❤️💙💙 https://t.co/bWzMz112Ja'],\n",
       " [datetime.datetime(2020, 7, 3, 4, 11, 32),\n",
       "  1278904180703289346,\n",
       "  'Wow seeing babyJ’s profile pic as me is literally so cute ... I feel blessed 🥰 Thankyou'],\n",
       " [datetime.datetime(2020, 7, 3, 4, 2, 23),\n",
       "  1278901879913582592,\n",
       "  'Did u like diss https://t.co/mi2m1Tjuhd'],\n",
       " [datetime.datetime(2020, 7, 2, 14, 53),\n",
       "  1278703225584017413,\n",
       "  'RT @mnet_hiphop: [8회] #제이미 X #치타 - Moonlight @슈퍼 퀘스트 1R \\n\\nGOOD GIRL vs Mnet\\n′센′ 여자 뮤지션들이 뭉쳐 펼치는 힙합 리얼리티 뮤직쇼\\n\\n＜GOOD GIRL : 누가 방송국을 털었나＞\\n그동안…'],\n",
       " [datetime.datetime(2020, 7, 2, 10, 16, 44),\n",
       "  1278633698728873984,\n",
       "  'https://t.co/3m1YI65EFO NEW EPISODE!!! 올때밐 W/ hilite records'],\n",
       " [datetime.datetime(2020, 7, 1, 14, 13, 46),\n",
       "  1278330964448432136,\n",
       "  '@leehi_hi Do you miss me🥺'],\n",
       " [datetime.datetime(2020, 7, 1, 14, 2, 15),\n",
       "  1278328063181242368,\n",
       "  'https://t.co/8zWMUDM8V3 haiR FLEX'],\n",
       " [datetime.datetime(2020, 6, 26, 5, 54),\n",
       "  1276393252237668352,\n",
       "  'No one :\\nLiterally no one :                                                       Baby J’s : EAT ME'],\n",
       " [datetime.datetime(2020, 6, 26, 5, 44, 34), 1276390881298313217, '배고파 뭐 먹지'],\n",
       " [datetime.datetime(2020, 6, 25, 10, 20, 47),\n",
       "  1276098005318299649,\n",
       "  '우리랑 같이 놀래? https://t.co/Q7P8VZwEeS'],\n",
       " [datetime.datetime(2020, 6, 23, 7, 9, 55),\n",
       "  1275325193171288065,\n",
       "  'https://t.co/iccJMP4ITw You are latee🔥🔥'],\n",
       " [datetime.datetime(2020, 6, 22, 3, 57, 23),\n",
       "  1274914353242796032,\n",
       "  'JUNE 23rd “ FOR A MINUTE”'],\n",
       " [datetime.datetime(2020, 6, 20, 10, 45, 55),\n",
       "  1274292390421921794,\n",
       "  '아니 이게 뭐야 ㅋㅋㅋㅋㅋㅋㅋㅋㅋ https://t.co/aQFfWqEsWw'],\n",
       " [datetime.datetime(2020, 6, 18, 16, 1, 52),\n",
       "  1273647125335691264,\n",
       "  'https://t.co/5a8yzyDfSE 👅👅👅👅👅👅👅👅👅'],\n",
       " [datetime.datetime(2020, 6, 18, 13, 8, 38),\n",
       "  1273603528095789057,\n",
       "  '굿걸 11시인거 알지~?'],\n",
       " [datetime.datetime(2020, 6, 17, 19, 15, 45),\n",
       "  1273333529502314496,\n",
       "  '@artchixkilogram This is so.. cute....'],\n",
       " [datetime.datetime(2020, 6, 16, 5, 33, 38),\n",
       "  1272764250746793985,\n",
       "  '😏 https://t.co/ELHputFyT1'],\n",
       " [datetime.datetime(2020, 6, 15, 13, 41, 56),\n",
       "  1272524745871949824,\n",
       "  \"RT @artchixkilogram: If I can keep this mood I'll make a whole chibi arts for Jamie gg's outfit 😂\\nNot promise tho 😂😂\\nLesee 😂😂\\n#Artchillustr…\"],\n",
       " [datetime.datetime(2020, 6, 13, 10, 36, 4),\n",
       "  1271753193639211010,\n",
       "  'I love sweet 🌽'],\n",
       " [datetime.datetime(2020, 6, 12, 22, 0, 4),\n",
       "  1271562940211015680,\n",
       "  'Feelin cute, might delete later https://t.co/vWXUGXEEy4'],\n",
       " [datetime.datetime(2020, 6, 8, 6, 43, 39),\n",
       "  1269882764846755842,\n",
       "  '레G나 죠지 같다는말 많이 들은 날 https://t.co/XAjfj6hGwA'],\n",
       " [datetime.datetime(2020, 6, 4, 14, 16, 18),\n",
       "  1268547128797868032,\n",
       "  'https://t.co/w0mdCaTHGJ ❤️NEW SONG TMMR❤️'],\n",
       " [datetime.datetime(2020, 6, 4, 13, 35, 46),\n",
       "  1268536927264923650,\n",
       "  'Colors🥰 https://t.co/uNFAgS4vgy'],\n",
       " [datetime.datetime(2020, 6, 3, 10, 35, 26),\n",
       "  1268129159395422208,\n",
       "  '기부와 주변인들에게 알려주는 것, 그 어떤 방법이든 여러분의 목소리로, 여러분의 행동으로 보여주셨으면 좋겠습니다. \\nhttps://t.co/h1Jg96ENml\\nhttps://t.co/Lh4kRCf7qz #BlackLivesMattter'],\n",
       " [datetime.datetime(2020, 6, 3, 10, 35, 3),\n",
       "  1268129060758204416,\n",
       "  'Black Lives Matter 운동은 전 세계 모든 사람들의 도움이 필요합니다. 제 팬분들과 동료 음악 산업 친구들, 동료들, 그리고 대한민국인으로써 왜 이 운동이 중요하고 필요한지 그리고 깊이 이해할… https://t.co/uat6tbN3ox'],\n",
       " [datetime.datetime(2020, 6, 3, 10, 34, 25),\n",
       "  1268128901777125376,\n",
       "  'Black Lives Matter는 단지 조지 플루이드를 잔인하게 살해한 것에 그치는 것이 아닌,미국 정부가 끊임없이 무시하고 단지 피부색 때문에 인간에 대한 조직적인 학대를 적극적으로 허용하는 것에 관한… https://t.co/GOI9PZbfnO'],\n",
       " [datetime.datetime(2020, 6, 3, 10, 33, 35),\n",
       "  1268128690627461120,\n",
       "  '누릴 수 있었던 즐거움과 다양한 경험을 토대로 음악인의 길을 걷게 되신 분들도 많습니다. 단지 피하거나 침묵을 통해 지나쳐서는 안됩니다. 이 것은 인간으로써의 권리를 지지하는 것이며, 전세계적으로 음악 산업… https://t.co/mTwh0YRV3s'],\n",
       " [datetime.datetime(2020, 6, 3, 10, 32, 23),\n",
       "  1268128389547741184,\n",
       "  '‘Black Lives Matter(흑인의 목숨도 소중하다)’ 운동이 얼마나 중요한지 그리고 왜 관심을 갖고 동참을 해야하는지에 대해 도움을 드리고 싶었습니다. 한국의 다양한 산업은  흑인 음악 뿐 만 아니… https://t.co/Vl6rgngB4b'],\n",
       " [datetime.datetime(2020, 6, 3, 10, 30, 16),\n",
       "  1268127858121039872,\n",
       "  '저는 K-Pop 음악산업에 관계자 분들이 이 일에 대해 전혀 마음을 쓰지 않고 있다고는 생각하지 않습니다.\\n온 신경을 쏟기엔 충분히 공감할 수 있을 만큼 잘 알고 있지 않을 뿐이라고 생각합니다.그래서 저는… https://t.co/jkdn4j3yYn'],\n",
       " [datetime.datetime(2020, 6, 3, 10, 28, 15),\n",
       "  1268127349914009600,\n",
       "  '안녕하세요 여러분, \\n지난 며칠 동안 저는 미국에서 일어나고 있는 일들로\\n많은 생각을 하게 되었습니다. 저는 사람들이 이 일에 대해 반드시 모두가 알아야 하는 일이라고 생각하기에, 더더욱 글을 올리기 전에… https://t.co/kkM2CjT5dd'],\n",
       " [datetime.datetime(2020, 6, 1, 9, 8, 34),\n",
       "  1267382519864778753,\n",
       "  \"RT @mnet_hiphop: [4회/예고] #더콰이엇의 프로듀싱! 굿걸의 첫 번째 퀘스트 결과는?! I 목요일 밤 9시 30분\\n\\nGOOD GIRL vs Mnet\\n'센' 여자 뮤지션들이 뭉쳐 펼치는 힙합 리얼리티 뮤직쇼\\n\\n＜#GOODGIRL : #누…\"],\n",
       " [datetime.datetime(2020, 5, 29, 2, 9, 44),\n",
       "  1266189953093890048,\n",
       "  '💜 anyways love you all 💜 https://t.co/ptoapB36AT'],\n",
       " [datetime.datetime(2020, 5, 29, 2, 4, 48),\n",
       "  1266188711026290694,\n",
       "  '* in Thailand I miss Thailand.. so much..'],\n",
       " [datetime.datetime(2020, 5, 29, 2, 2, 43),\n",
       "  1266188188906745856,\n",
       "  'Wow it’s happening again. I want Thai food .. sooo... bad... wow...'],\n",
       " [datetime.datetime(2020, 5, 29, 1, 37, 54),\n",
       "  1266181943604830208,\n",
       "  'I go with ENFP🤟🏻 https://t.co/L37y9tnUrz']]"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "tweets_list"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>0</th>\n",
       "      <th>1</th>\n",
       "      <th>2</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2021-04-29 09:47:19</td>\n",
       "      <td>1387705044674523136</td>\n",
       "      <td>🖤😉 https://t.co/syp6WOzKBU</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2021-04-22 15:17:21</td>\n",
       "      <td>1385251384413487107</td>\n",
       "      <td>RT @jamiestaffsays: 👭제이미, 찬미나가 참여한 Saweetie – ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2021-04-19 14:40:49</td>\n",
       "      <td>1384155028131176448</td>\n",
       "      <td>RT @jamiestaffsays: 👭Saweetie – Best Friend (f...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2021-04-15 22:23:25</td>\n",
       "      <td>1382821893942611969</td>\n",
       "      <td>🔥 https://t.co/tennSQwtqX</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2021-04-01 08:41:13</td>\n",
       "      <td>1377541548070477825</td>\n",
       "      <td>RT @jamiestaffsays: 👭Saweetie - Best Friend (f...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                    0                    1  \\\n",
       "0 2021-04-29 09:47:19  1387705044674523136   \n",
       "1 2021-04-22 15:17:21  1385251384413487107   \n",
       "2 2021-04-19 14:40:49  1384155028131176448   \n",
       "3 2021-04-15 22:23:25  1382821893942611969   \n",
       "4 2021-04-01 08:41:13  1377541548070477825   \n",
       "\n",
       "                                                   2  \n",
       "0                         🖤😉 https://t.co/syp6WOzKBU  \n",
       "1  RT @jamiestaffsays: 👭제이미, 찬미나가 참여한 Saweetie – ...  \n",
       "2  RT @jamiestaffsays: 👭Saweetie – Best Friend (f...  \n",
       "3                          🔥 https://t.co/tennSQwtqX  \n",
       "4  RT @jamiestaffsays: 👭Saweetie - Best Friend (f...  "
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "tweets_df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>0</th>\n",
       "      <th>1</th>\n",
       "      <th>2</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>195</th>\n",
       "      <td>2020-06-01 09:08:34</td>\n",
       "      <td>1267382519864778753</td>\n",
       "      <td>RT @mnet_hiphop: [4회/예고] #더콰이엇의 프로듀싱! 굿걸의 첫 번째...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>196</th>\n",
       "      <td>2020-05-29 02:09:44</td>\n",
       "      <td>1266189953093890048</td>\n",
       "      <td>💜 anyways love you all 💜 https://t.co/ptoapB36AT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>197</th>\n",
       "      <td>2020-05-29 02:04:48</td>\n",
       "      <td>1266188711026290694</td>\n",
       "      <td>* in Thailand I miss Thailand.. so much..</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>198</th>\n",
       "      <td>2020-05-29 02:02:43</td>\n",
       "      <td>1266188188906745856</td>\n",
       "      <td>Wow it’s happening again. I want Thai food .. ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>199</th>\n",
       "      <td>2020-05-29 01:37:54</td>\n",
       "      <td>1266181943604830208</td>\n",
       "      <td>I go with ENFP🤟🏻 https://t.co/L37y9tnUrz</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                      0                    1  \\\n",
       "195 2020-06-01 09:08:34  1267382519864778753   \n",
       "196 2020-05-29 02:09:44  1266189953093890048   \n",
       "197 2020-05-29 02:04:48  1266188711026290694   \n",
       "198 2020-05-29 02:02:43  1266188188906745856   \n",
       "199 2020-05-29 01:37:54  1266181943604830208   \n",
       "\n",
       "                                                     2  \n",
       "195  RT @mnet_hiphop: [4회/예고] #더콰이엇의 프로듀싱! 굿걸의 첫 번째...  \n",
       "196   💜 anyways love you all 💜 https://t.co/ptoapB36AT  \n",
       "197          * in Thailand I miss Thailand.. so much..  \n",
       "198  Wow it’s happening again. I want Thai food .. ...  \n",
       "199           I go with ENFP🤟🏻 https://t.co/L37y9tnUrz  "
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "tweets_df.tail()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {},
   "outputs": [],
   "source": [
    "tweets_df[0] = pd.to_datetime(tweets_df[0]).dt.date"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>0</th>\n",
       "      <th>1</th>\n",
       "      <th>2</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2021-04-29</td>\n",
       "      <td>1387705044674523136</td>\n",
       "      <td>🖤😉 https://t.co/syp6WOzKBU</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2021-04-22</td>\n",
       "      <td>1385251384413487107</td>\n",
       "      <td>RT @jamiestaffsays: 👭제이미, 찬미나가 참여한 Saweetie – ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2021-04-19</td>\n",
       "      <td>1384155028131176448</td>\n",
       "      <td>RT @jamiestaffsays: 👭Saweetie – Best Friend (f...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2021-04-15</td>\n",
       "      <td>1382821893942611969</td>\n",
       "      <td>🔥 https://t.co/tennSQwtqX</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2021-04-01</td>\n",
       "      <td>1377541548070477825</td>\n",
       "      <td>RT @jamiestaffsays: 👭Saweetie - Best Friend (f...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "            0                    1  \\\n",
       "0  2021-04-29  1387705044674523136   \n",
       "1  2021-04-22  1385251384413487107   \n",
       "2  2021-04-19  1384155028131176448   \n",
       "3  2021-04-15  1382821893942611969   \n",
       "4  2021-04-01  1377541548070477825   \n",
       "\n",
       "                                                   2  \n",
       "0                         🖤😉 https://t.co/syp6WOzKBU  \n",
       "1  RT @jamiestaffsays: 👭제이미, 찬미나가 참여한 Saweetie – ...  \n",
       "2  RT @jamiestaffsays: 👭Saweetie – Best Friend (f...  \n",
       "3                          🔥 https://t.co/tennSQwtqX  \n",
       "4  RT @jamiestaffsays: 👭Saweetie - Best Friend (f...  "
      ]
     },
     "execution_count": 18,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# tweets_df.head()\n",
    "tweets_df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Tweeted Date</th>\n",
       "      <th>1</th>\n",
       "      <th>Tweet Description</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2021-04-29</td>\n",
       "      <td>1387705044674523136</td>\n",
       "      <td>🖤😉 https://t.co/syp6WOzKBU</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2021-04-22</td>\n",
       "      <td>1385251384413487107</td>\n",
       "      <td>RT @jamiestaffsays: 👭제이미, 찬미나가 참여한 Saweetie – ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2021-04-19</td>\n",
       "      <td>1384155028131176448</td>\n",
       "      <td>RT @jamiestaffsays: 👭Saweetie – Best Friend (f...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2021-04-15</td>\n",
       "      <td>1382821893942611969</td>\n",
       "      <td>🔥 https://t.co/tennSQwtqX</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2021-04-01</td>\n",
       "      <td>1377541548070477825</td>\n",
       "      <td>RT @jamiestaffsays: 👭Saweetie - Best Friend (f...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  Tweeted Date                    1  \\\n",
       "0   2021-04-29  1387705044674523136   \n",
       "1   2021-04-22  1385251384413487107   \n",
       "2   2021-04-19  1384155028131176448   \n",
       "3   2021-04-15  1382821893942611969   \n",
       "4   2021-04-01  1377541548070477825   \n",
       "\n",
       "                                   Tweet Description  \n",
       "0                         🖤😉 https://t.co/syp6WOzKBU  \n",
       "1  RT @jamiestaffsays: 👭제이미, 찬미나가 참여한 Saweetie – ...  \n",
       "2  RT @jamiestaffsays: 👭Saweetie – Best Friend (f...  \n",
       "3                          🔥 https://t.co/tennSQwtqX  \n",
       "4  RT @jamiestaffsays: 👭Saweetie - Best Friend (f...  "
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "new_tweets_df = tweets_df.rename(columns={0: \"Tweeted Date\", 2: \"Tweet Description\"})\n",
    "new_tweets_df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {},
   "outputs": [],
   "source": [
    "cleaned_tweets = new_tweets_df.drop([1], axis = 1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Tweeted Date</th>\n",
       "      <th>Tweet Description</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2021-04-29</td>\n",
       "      <td>🖤😉 https://t.co/syp6WOzKBU</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2021-04-22</td>\n",
       "      <td>RT @jamiestaffsays: 👭제이미, 찬미나가 참여한 Saweetie – ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2021-04-19</td>\n",
       "      <td>RT @jamiestaffsays: 👭Saweetie – Best Friend (f...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2021-04-15</td>\n",
       "      <td>🔥 https://t.co/tennSQwtqX</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2021-04-01</td>\n",
       "      <td>RT @jamiestaffsays: 👭Saweetie - Best Friend (f...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>195</th>\n",
       "      <td>2020-06-01</td>\n",
       "      <td>RT @mnet_hiphop: [4회/예고] #더콰이엇의 프로듀싱! 굿걸의 첫 번째...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>196</th>\n",
       "      <td>2020-05-29</td>\n",
       "      <td>💜 anyways love you all 💜 https://t.co/ptoapB36AT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>197</th>\n",
       "      <td>2020-05-29</td>\n",
       "      <td>* in Thailand I miss Thailand.. so much..</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>198</th>\n",
       "      <td>2020-05-29</td>\n",
       "      <td>Wow it’s happening again. I want Thai food .. ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>199</th>\n",
       "      <td>2020-05-29</td>\n",
       "      <td>I go with ENFP🤟🏻 https://t.co/L37y9tnUrz</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>200 rows × 2 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "    Tweeted Date                                  Tweet Description\n",
       "0     2021-04-29                         🖤😉 https://t.co/syp6WOzKBU\n",
       "1     2021-04-22  RT @jamiestaffsays: 👭제이미, 찬미나가 참여한 Saweetie – ...\n",
       "2     2021-04-19  RT @jamiestaffsays: 👭Saweetie – Best Friend (f...\n",
       "3     2021-04-15                          🔥 https://t.co/tennSQwtqX\n",
       "4     2021-04-01  RT @jamiestaffsays: 👭Saweetie - Best Friend (f...\n",
       "..           ...                                                ...\n",
       "195   2020-06-01  RT @mnet_hiphop: [4회/예고] #더콰이엇의 프로듀싱! 굿걸의 첫 번째...\n",
       "196   2020-05-29   💜 anyways love you all 💜 https://t.co/ptoapB36AT\n",
       "197   2020-05-29          * in Thailand I miss Thailand.. so much..\n",
       "198   2020-05-29  Wow it’s happening again. I want Thai food .. ...\n",
       "199   2020-05-29           I go with ENFP🤟🏻 https://t.co/L37y9tnUrz\n",
       "\n",
       "[200 rows x 2 columns]"
      ]
     },
     "execution_count": 21,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "cleaned_tweets"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "metadata": {},
   "outputs": [],
   "source": [
    "cleaned_tweets.to_csv(\"sample_twitter_scraping.csv\")"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.7.6"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}