data handling.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 63,
   "metadata": {},
   "outputs": [],
   "source": [
    "import xml.etree.ElementTree as ET\n",
    "import requests\n",
    "import json\n",
    "import csv"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "metadata": {},
   "outputs": [],
   "source": [
    "def save_xml(url):\n",
    "    response = requests.get(url)\n",
    "    with open(\"movies.xml\", \"wb\") as file:\n",
    "        file.write(response.content)\n",
    "save_xml(\"https://news.google.com/rss/search?q=sport\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "root:\n",
      "tags: rss \t attribte  {'version': '2.0'}\n",
      "elements:\n",
      "tag: generator \t\t attribute {}\n",
      "<Element 'generator' at 0x0000025B825EE318> : NFE/5.0\n",
      "tag: title \t\t attribute {}\n",
      "<Element 'title' at 0x0000025B80F8A278> : \"sport\" - Google News\n",
      "tag: link \t\t attribute {}\n",
      "<Element 'link' at 0x0000025B82657A48> : https://news.google.com/search?q=sport&hl=en-US&gl=US&ceid=US:en\n",
      "tag: language \t\t attribute {}\n",
      "<Element 'language' at 0x0000025B82657EA8> : en-US\n",
      "tag: webMaster \t\t attribute {}\n",
      "<Element 'webMaster' at 0x0000025B826573B8> : news-webmaster@google.com\n",
      "tag: copyright \t\t attribute {}\n",
      "<Element 'copyright' at 0x0000025B82657638> : 2020 Google Inc.\n",
      "tag: lastBuildDate \t\t attribute {}\n",
      "<Element 'lastBuildDate' at 0x0000025B82657B88> : Thu, 14 May 2020 12:35:05 GMT\n",
      "tag: description \t\t attribute {}\n",
      "<Element 'description' at 0x0000025B82657318> : Google News\n",
      "tag: item \t\t attribute {}\n",
      "<Element 'item' at 0x0000025B82657048> : None\n",
      "tag: item \t\t attribute {}\n",
      "<Element 'item' at 0x0000025B82638458> : None\n",
      "tag: item \t\t attribute {}\n",
      "<Element 'item' at 0x0000025B82638728> : None\n",
      "tag: item \t\t attribute {}\n",
      "<Element 'item' at 0x0000025B8265D4F8> : None\n",
      "tag: item \t\t attribute {}\n",
      "<Element 'item' at 0x0000025B8263C138> : None\n",
      "tag: item \t\t attribute {}\n",
      "<Element 'item' at 0x0000025B8263C278> : None\n",
      "tag: item \t\t attribute {}\n",
      "<Element 'item' at 0x0000025B8263CEA8> : None\n",
      "tag: item \t\t attribute {}\n",
      "<Element 'item' at 0x0000025B82640318> : None\n",
      "tag: item \t\t attribute {}\n",
      "<Element 'item' at 0x0000025B82640228> : None\n",
      "tag: item \t\t attribute {}\n",
      "<Element 'item' at 0x0000025B82640A48> : None\n",
      "tag: item \t\t attribute {}\n",
      "<Element 'item' at 0x0000025B82640958> : None\n",
      "tag: item \t\t attribute {}\n",
      "<Element 'item' at 0x0000025B826152C8> : None\n",
      "tag: item \t\t attribute {}\n",
      "<Element 'item' at 0x0000025B8264C188> : None\n",
      "tag: item \t\t attribute {}\n",
      "<Element 'item' at 0x0000025B8264C638> : None\n",
      "tag: item \t\t attribute {}\n",
      "<Element 'item' at 0x0000025B8264C4A8> : None\n",
      "tag: item \t\t attribute {}\n",
      "<Element 'item' at 0x0000025B8264CAE8> : None\n",
      "tag: item \t\t attribute {}\n",
      "<Element 'item' at 0x0000025B82650048> : None\n",
      "tag: item \t\t attribute {}\n",
      "<Element 'item' at 0x0000025B826508B8> : None\n",
      "tag: item \t\t attribute {}\n",
      "<Element 'item' at 0x0000025B82650E08> : None\n",
      "tag: item \t\t attribute {}\n",
      "<Element 'item' at 0x0000025B82654228> : None\n",
      "tag: item \t\t attribute {}\n",
      "<Element 'item' at 0x0000025B82654458> : None\n",
      "tag: item \t\t attribute {}\n",
      "<Element 'item' at 0x0000025B82654728> : None\n",
      "tag: item \t\t attribute {}\n",
      "<Element 'item' at 0x0000025B82654D18> : None\n",
      "tag: item \t\t attribute {}\n",
      "<Element 'item' at 0x0000025B825F09A8> : None\n",
      "tag: item \t\t attribute {}\n",
      "<Element 'item' at 0x0000025B825CAB38> : None\n",
      "tag: item \t\t attribute {}\n",
      "<Element 'item' at 0x0000025B8263F318> : None\n",
      "tag: item \t\t attribute {}\n",
      "<Element 'item' at 0x0000025B8263F778> : None\n",
      "tag: item \t\t attribute {}\n",
      "<Element 'item' at 0x0000025B8263FC28> : None\n",
      "tag: item \t\t attribute {}\n",
      "<Element 'item' at 0x0000025B8264B098> : None\n",
      "tag: item \t\t attribute {}\n",
      "<Element 'item' at 0x0000025B8264B458> : None\n",
      "tag: item \t\t attribute {}\n",
      "<Element 'item' at 0x0000025B8264B818> : None\n",
      "tag: item \t\t attribute {}\n",
      "<Element 'item' at 0x0000025B8264BBD8> : None\n",
      "tag: item \t\t attribute {}\n",
      "<Element 'item' at 0x0000025B82641098> : None\n",
      "tag: item \t\t attribute {}\n",
      "<Element 'item' at 0x0000025B826414F8> : None\n",
      "tag: item \t\t attribute {}\n",
      "<Element 'item' at 0x0000025B826418B8> : None\n",
      "tag: item \t\t attribute {}\n",
      "<Element 'item' at 0x0000025B82641D18> : None\n",
      "tag: item \t\t attribute {}\n",
      "<Element 'item' at 0x0000025B82644138> : None\n",
      "tag: item \t\t attribute {}\n",
      "<Element 'item' at 0x0000025B82644598> : None\n",
      "tag: item \t\t attribute {}\n",
      "<Element 'item' at 0x0000025B826449F8> : None\n",
      "tag: item \t\t attribute {}\n",
      "<Element 'item' at 0x0000025B82644DB8> : None\n",
      "tag: item \t\t attribute {}\n",
      "<Element 'item' at 0x0000025B8263E1D8> : None\n",
      "tag: item \t\t attribute {}\n",
      "<Element 'item' at 0x0000025B8263E598> : None\n",
      "tag: item \t\t attribute {}\n",
      "<Element 'item' at 0x0000025B8263EA48> : None\n",
      "tag: item \t\t attribute {}\n",
      "<Element 'item' at 0x0000025B8263EE08> : None\n",
      "tag: item \t\t attribute {}\n",
      "<Element 'item' at 0x0000025B82649228> : None\n",
      "tag: item \t\t attribute {}\n",
      "<Element 'item' at 0x0000025B826495E8> : None\n",
      "tag: item \t\t attribute {}\n",
      "<Element 'item' at 0x0000025B82649A48> : None\n",
      "tag: item \t\t attribute {}\n",
      "<Element 'item' at 0x0000025B82649E08> : None\n",
      "tag: item \t\t attribute {}\n",
      "<Element 'item' at 0x0000025B8263BDB8> : None\n",
      "tag: item \t\t attribute {}\n",
      "<Element 'item' at 0x0000025B8263B9F8> : None\n",
      "tag: item \t\t attribute {}\n",
      "<Element 'item' at 0x0000025B8263B638> : None\n",
      "tag: item \t\t attribute {}\n",
      "<Element 'item' at 0x0000025B8263B188> : None\n",
      "tag: item \t\t attribute {}\n",
      "<Element 'item' at 0x0000025B82659E08> : None\n",
      "tag: item \t\t attribute {}\n",
      "<Element 'item' at 0x0000025B82659958> : None\n",
      "tag: item \t\t attribute {}\n",
      "<Element 'item' at 0x0000025B82659688> : None\n",
      "tag: item \t\t attribute {}\n",
      "<Element 'item' at 0x0000025B82659318> : None\n",
      "tag: item \t\t attribute {}\n",
      "<Element 'item' at 0x0000025B8263DDB8> : None\n",
      "tag: item \t\t attribute {}\n",
      "<Element 'item' at 0x0000025B8263D9F8> : None\n",
      "tag: item \t\t attribute {}\n",
      "<Element 'item' at 0x0000025B8263D598> : None\n",
      "tag: item \t\t attribute {}\n",
      "<Element 'item' at 0x0000025B825EA278> : None\n",
      "tag: item \t\t attribute {}\n",
      "<Element 'item' at 0x0000025B8263D1D8> : None\n",
      "tag: item \t\t attribute {}\n",
      "<Element 'item' at 0x0000025B8268CA48> : None\n",
      "tag: item \t\t attribute {}\n",
      "<Element 'item' at 0x0000025B8268C728> : None\n",
      "tag: item \t\t attribute {}\n",
      "<Element 'item' at 0x0000025B8268C368> : None\n",
      "tag: item \t\t attribute {}\n",
      "<Element 'item' at 0x0000025B8268C0E8> : None\n",
      "tag: item \t\t attribute {}\n",
      "<Element 'item' at 0x0000025B82664048> : None\n",
      "tag: item \t\t attribute {}\n",
      "<Element 'item' at 0x0000025B82664368> : None\n",
      "tag: item \t\t attribute {}\n",
      "<Element 'item' at 0x0000025B82664728> : None\n",
      "tag: item \t\t attribute {}\n",
      "<Element 'item' at 0x0000025B82664AE8> : None\n",
      "tag: item \t\t attribute {}\n",
      "<Element 'item' at 0x0000025B82664E58> : None\n",
      "tag: item \t\t attribute {}\n",
      "<Element 'item' at 0x0000025B82676278> : None\n",
      "tag: item \t\t attribute {}\n",
      "<Element 'item' at 0x0000025B826766D8> : None\n",
      "tag: item \t\t attribute {}\n",
      "<Element 'item' at 0x0000025B82676AE8> : None\n",
      "tag: item \t\t attribute {}\n",
      "<Element 'item' at 0x0000025B82676EA8> : None\n",
      "tag: item \t\t attribute {}\n",
      "<Element 'item' at 0x0000025B82665D68> : None\n",
      "tag: item \t\t attribute {}\n",
      "<Element 'item' at 0x0000025B82665908> : None\n",
      "tag: item \t\t attribute {}\n",
      "<Element 'item' at 0x0000025B826654F8> : None\n",
      "tag: item \t\t attribute {}\n",
      "<Element 'item' at 0x0000025B826650E8> : None\n",
      "tag: item \t\t attribute {}\n",
      "<Element 'item' at 0x0000025B82668368> : None\n",
      "tag: item \t\t attribute {}\n",
      "<Element 'item' at 0x0000025B82668728> : None\n",
      "tag: item \t\t attribute {}\n",
      "<Element 'item' at 0x0000025B82668B88> : None\n",
      "tag: item \t\t attribute {}\n",
      "<Element 'item' at 0x0000025B82668F48> : None\n",
      "tag: item \t\t attribute {}\n",
      "<Element 'item' at 0x0000025B8266F3B8> : None\n",
      "tag: item \t\t attribute {}\n",
      "<Element 'item' at 0x0000025B8266F7C8> : None\n",
      "tag: item \t\t attribute {}\n",
      "<Element 'item' at 0x0000025B8266FB38> : None\n",
      "tag: item \t\t attribute {}\n",
      "<Element 'item' at 0x0000025B826784F8> : None\n",
      "tag: item \t\t attribute {}\n",
      "<Element 'item' at 0x0000025B82678458> : None\n",
      "tag: item \t\t attribute {}\n",
      "<Element 'item' at 0x0000025B826787C8> : None\n",
      "tag: item \t\t attribute {}\n",
      "<Element 'item' at 0x0000025B82678868> : None\n",
      "tag: item \t\t attribute {}\n",
      "<Element 'item' at 0x0000025B8267DD68> : None\n",
      "tag: item \t\t attribute {}\n",
      "<Element 'item' at 0x0000025B8267DB38> : None\n",
      "tag: item \t\t attribute {}\n",
      "<Element 'item' at 0x0000025B8267D778> : None\n",
      "tag: item \t\t attribute {}\n",
      "<Element 'item' at 0x0000025B8267D318> : None\n",
      "tag: item \t\t attribute {}\n",
      "<Element 'item' at 0x0000025B82672EF8> : None\n",
      "tag: item \t\t attribute {}\n",
      "<Element 'item' at 0x0000025B82672A48> : None\n",
      "tag: item \t\t attribute {}\n",
      "<Element 'item' at 0x0000025B82672688> : None\n",
      "tag: item \t\t attribute {}\n",
      "<Element 'item' at 0x0000025B82672228> : None\n",
      "tag: item \t\t attribute {}\n",
      "<Element 'item' at 0x0000025B82691278> : None\n",
      "tag: item \t\t attribute {}\n",
      "<Element 'item' at 0x0000025B82691638> : None\n",
      "tag: item \t\t attribute {}\n",
      "<Element 'item' at 0x0000025B826919F8> : None\n"
     ]
    }
   ],
   "source": [
    "tree = ET.parse(\"sports.xml\")\n",
    "root = tree.getroot()\n",
    "print(\"root:\")\n",
    "print(\"tags:\", root.tag, \"\\t attribte \", root.attrib )\n",
    "print(\"elements:\")\n",
    "for element in root:\n",
    "    for sub_element in element:\n",
    "        #print attributes\n",
    "        print(\"tag:\", sub_element.tag, \"\\t\\t\", \"attribute\", sub_element.attrib)\n",
    "        #print the text\n",
    "        print(sub_element, \":\", sub_element.text)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 37,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "News Title 0: How the coronavirus is affecting college sports - NCAA reopening plans, cancellations, recruiting, more - ESPN\n",
      "News Title 1: Ron DeSantis: ‘All professional sports are welcome’ in Florida - Tampa Bay Times\n",
      "News Title 2: Pro sports are coming back around the world. Does that mean there's a light at the end of the tunnel for the US? - CNN International\n",
      "News Title 3: Sports TV networks bracing for unprecedented broadcasts in coronavirus age - New York Post \n",
      "News Title 4: Can sport survive the covid-19 pandemic without spectators? - The Economist\n",
      "News Title 5: Major Calif. NCAA Division II League Cancels All Its Fall Sports - CBS Los Angeles\n",
      "News Title 6: High schools: More time to decide sports return - San Mateo Daily Journal\n",
      "News Title 7: Sporting directors are key in modern football – Michael Johnson - Yahoo Sports\n",
      "News Title 8: Sports is plotting a return. The country's road to recovery could be at stake - San Francisco Chronicle\n",
      "News Title 9: Arizona governor says pro sports can resume without fans May 16 - ESPN\n",
      "News Title 10: Mid-American Conference cancels postseason tournaments for eight sports, changes basketball format - CBS Sports\n",
      "News Title 11: One Size Won’t Fit All for the Return of Sports - The New York Times\n",
      "News Title 12: Fighters forum -- Other sports you'd like to play, that moment you knew you were good - ESPN\n",
      "News Title 13: Coronavirus and sport: the impact of Covid-19 on sporting events around the world - AS English\n",
      "News Title 14: Mamba Sports Academy changing its name due to respect for Kobe Bryant - CBS Sports\n",
      "News Title 15: 'They failed those athletes': CNN Sport correspondents on coronavirus' impact on sport - CNN\n",
      "News Title 16: MPA adding esports to fall, spring sports calendars - Press Herald\n",
      "News Title 17: Podcast: What would it take for sports to return? - NBCSports.com\n",
      "News Title 18: Pause on shooting sports impacting Lockport woman's dream - Buffalo News\n",
      "News Title 19: Youth Sports Proposing Adjustments In Hopes Of Being Able To Play This Summer - NBC Connecticut\n",
      "News Title 20: Fans of pro, prep sports await go-ahead - Grosse Pointe News (subscription)\n",
      "News Title 21: What do you remember about the first sporting event you went to in Syracuse? Tell us about it - syracuse.com\n",
      "News Title 22: How Mississippi State inched closer to playing sports amid coronavirus pandemic - Clarion Ledger\n",
      "News Title 23: Community colleges could see influx of athletes as coronavirus disrupts sports recruiting - CALmatters\n",
      "News Title 24: Arizona governor gives green light for pro sports to return, minus the fans - NBCNews.com\n",
      "News Title 25: Why UFC Is the First Sport to Return During the Coronavirus - The New York Times\n",
      "News Title 26: When Will Sports Come Back? Here Is What Has to Happen First - The New York Times\n",
      "News Title 27: Sports Are Restarting in a ‘New Normal’ - The New York Times\n",
      "News Title 28: Schroeder: Cherish it! Golden Age of Wisconsin sports - WBAY\n",
      "News Title 29: 'We're really upset': Bay Area sport fishing businesses sound off on lack of guidance for reopening - SFGate\n",
      "News Title 30: Rams legend Eric Dickerson says the team's new uniform is 'soft,' too close to Chargers' look - CBS Sports\n",
      "News Title 31: The Coronavirus Doesn’t Care When Sports Come Back - The New York Times\n",
      "News Title 32: Ray Brown: Downside of free agency in professional sports - The Union Leader\n",
      "News Title 33: ‘Bet Monarch’ App Lets Gamblers Bet On Sports - CBS Denver\n",
      "News Title 34: May: The Month That Sports, Kind of, Come Back - The New York Times\n",
      "News Title 35: Mr. Baseball: Warner Robins youth sports figure Claude Lewis dies at 93 - 13WMAZ.com\n",
      "News Title 36: Golf joins baseball, soccer in South Korea as sports resume - Tacoma News Tribune\n",
      "News Title 37: Wojo: In pandemic world, college football is the sport in real danger - The Detroit News\n",
      "News Title 38: The Arena Sports Acadamy adds new amenities to facility - KTIV\n",
      "News Title 39: Graduation Roundtable: The CD Sports Staff highlight the graduating athletes they'll miss most - University of Virginia The Cavalier Daily\n",
      "News Title 40: Area Sports Briefs: Ace at McCanless, drive-through sign-ups for NC3 baseball - Salisbury Post - Salisbury Post\n",
      "News Title 41: We need sports, now | Free - Bolivar Herald-Free Press\n",
      "News Title 42: Three Marshall Sports Recognized for APR Excellence - HerdZone.com\n",
      "News Title 43: Minnesota Governor: Summer day camps, possibly some youth sports allowed this summer - FOX 9\n",
      "News Title 44: Speaking Sports: Legendary Lynn Sportscaster John Hoffman Offers Insights - Lynn Journal\n",
      "News Title 45: Some Sports May Have to Skip This Year, Fauci Says - The New York Times\n",
      "News Title 46: Why MJ has boycotted SI since 1994 - NBCSports.com\n",
      "News Title 47: Dr. Wilbur H. Crago 1923-2020 | News, Sports, Jobs - Youngstown Vindicator\n",
      "News Title 48: Coronavirus threatens all women's sports. U.S. women's soccer is just the tip of the iceberg. - NBC News\n",
      "News Title 49: Sudden vanishing of sports due to coronavirus will cost at least $12 billion, analysis says - ESPN\n",
      "News Title 50: NCHSAA gives schools go-ahead conditionally to open sports - The Stanly News & Press - Stanly News & Press\n",
      "News Title 51: For the kids? Nation's largest youth volleyball event to proceed in June despite concerns - USA TODAY\n",
      "News Title 52: 'I don't want to die,' says UFC boss Dana White as sport gets back to business amid pandemic - CNN\n",
      "News Title 53: NCAA's top doctor says widespread testing crucial to having sports in fall - ESPN\n",
      "News Title 54: Dream 18, No. 6 | Sports | timesdaily.com - Times Daily\n",
      "News Title 55: Davis & Elkins students recognized | News, Sports, Jobs - The Inter-Mountain\n",
      "News Title 56: Elite sport training return is 'overdue' - Dai Greene - BBC News\n",
      "News Title 57: Red Stars make history as first professional sports team in Chicago to hire female public address announcer - Chicago Sun-Times\n",
      "News Title 58: In My View 5/13/2020: Big Ten fall sports - WILX-TV\n",
      "News Title 59: Comparison Test: 1993 Toyota Supra Turbo Takes On the Best Sports Cars of the Early 1990s - Car and Driver\n",
      "News Title 60: IMSA expands sim racing options with new iRacing Challenge Series - NBC Sports - Motorsports\n",
      "News Title 61: High school coaches prepare for post COVID-19 sports - FOX13 Memphis\n",
      "News Title 62: Difficult decision | News, Sports, Jobs - Parkersburg News\n",
      "News Title 63: NCAA Denies Request to Drop Division I Sport Minimum - U.S. News & World Report\n",
      "News Title 64: Agency - Coronavirus to cancel nearly half of scheduled sports events in 2020 - ESPN\n",
      "News Title 65: Half Sports Car, Half Off-Roader: The Era of the SUV Coupe Has Begun - BloombergQuint\n",
      "News Title 66: Youth Sports Worry About Weathering Pandemic, and Future Play - The New York Times\n",
      "News Title 67: Starved for Sports? Here Are 5 Options That Aren’t N.B.A. Classic - The New York Times\n",
      "News Title 68: Doctors on the return of sports: 'Fans may not be in stadiums until well into 2021' - The Guardian\n",
      "News Title 69: City of Port St Lucie offering e-sports leagues - WPEC\n",
      "News Title 70: How Sports-Starved Bettors Made a Nebraska Horse Track Must-See TV - The New York Times\n",
      "News Title 71: SPORTS BRIEFING | News, Sports, Jobs - Morning Journal News\n",
      "News Title 72: Sport into business - surveying the options for when final whistle blows - BBC Sport\n",
      "News Title 73: Fann: My 7 most haunting memories as a Seattle sports fan - NBCSports.com\n",
      "News Title 74: Conferences Petition N.C.A.A., Seeking to Cut Sports - The New York Times\n",
      "News Title 75: Six college football teams with championship-caliber rosters that can return them to greatness - CBS Sports\n",
      "News Title 76: Jalen Hurts get his jersey number with the Eagles - NBC Sports Philadelphia\n",
      "News Title 77: Louisiana Senate backs proposal to legalize sports betting - WBRZ\n",
      "News Title 78: Relief for Borussia Dortmund as the Bundesliga gets ready to return - BBC Sport\n",
      "News Title 79: ESPN’s Live Sport Savior: Korean Baseball - The New York Times\n",
      "News Title 80: Dr. Fauci: Sports could return this summer without fans in venues - CBS Sports\n",
      "News Title 81: Central Mountain baseball honors seniors with virtual senior day | News, Sports, Jobs - Lock Haven Express\n",
      "News Title 82: James W. Lowe | News, Sports, Jobs - The Review\n",
      "News Title 83: Jason Peters reiterates desire to play into his 40s and three teams are interested in signing him, per report - CBS Sports\n",
      "News Title 84: Wild Ideas to Bring Back Sports Might Say More About Cities Than Leagues - The New York Times\n",
      "News Title 85: PHOTOS: 2017-18 Wrestling Season - Ozarks Sports Zone\n",
      "News Title 86: Dele Alli: Tottenham midfielder held at knifepoint during burglary - BBC Sport\n",
      "News Title 87: Ospreys: Sports marketing group takes 75.1% stake in 'multi-million pound' takeover deal - BBC News\n",
      "News Title 88: What it's like to host ESPN's SportsCenter without sports - CNN\n",
      "News Title 89: High School Sports Pushed Out of Bounds by the Pandemic - The New York Times\n",
      "News Title 90: Joe Buck Says Fox Sports Will Pipe in Fake Crowd Noise and Put Virtual Fans in the Stands for Broadcasts - bleachernation.com\n",
      "News Title 91: What can fans expect when sports return? A strange and uncertain experience - San Francisco Chronicle\n",
      "News Title 92: Norwich against Premier League relegation if Championship season stops - BBC News\n",
      "News Title 93: Duke's Mike Krzyzewski Likely to Be Deposed in Zion Williamson Lawsuit - Sports Illustrated\n",
      "News Title 94: Coronavirus Sports: Philadelphia 76ers President Chris Heck Explains How Team Is Staying Connected To Fanbase During Pandemic - CBS Philly\n",
      "News Title 95: French tennis players return to training - NBC Sports - Misc.\n",
      "News Title 96: District 4 football all-star game is canceled | News, Sports, Jobs - Lock Haven Express\n",
      "News Title 97: Summer rules for Louisiana high school sports postponed until June 8 - WBRZ\n",
      "News Title 98: Sports 12 Rewind: Fred Douglass High School brings 1964 State Title to Sherman - KXII-TV\n",
      "News Title 99: McLaren 600LT sports car crash in California kills YouTube star; driver from ‘Ink Master’ arrested - The Mercury News\n"
     ]
    }
   ],
   "source": [
    "\n",
    "def parse_xml(file):\n",
    "    tree = ET.parse(file)\n",
    "    root = tree.getroot()\n",
    "    title_list = []\n",
    "    for element in root.findall(\"./channel/item\"):\n",
    "        for sub_element in element:\n",
    "            if sub_element.tag == \"title\":\n",
    "                title_list.append(sub_element.text)\n",
    "    return title_list\n",
    "\n",
    "title_list = parse_xml(\"sports.xml\")\n",
    "for i in range(len(title_list)):\n",
    "    print(f\"News Title {i}: {title_list[i]}\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 45,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "genre: Action\n",
      "genre: Thriller\n"
     ]
    }
   ],
   "source": [
    "save_xml(\"https://cutt.ly/movie-xml\")\n",
    "#function that finds the genres of a movie.xml file\n",
    "def parse_movie_xml(file):\n",
    "    tree = ET.parse(file)\n",
    "    root = tree.getroot()\n",
    "    title_list = []\n",
    "    for element in root.findall(\"./genre\"):\n",
    "        if element.tag == \"genre\":\n",
    "            print(f\"{element.tag}: {element.attrib['category']}\")\n",
    "\n",
    "parse_movie_xml(\"movie.xml\")\n",
    "    "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 48,
   "metadata": {},
   "outputs": [],
   "source": [
    "#function for loading json files\n",
    "def load_json(file_name):\n",
    "    with open(file_name) as file:\n",
    "        json_data = json.load(file)\n",
    "    return json_data\n",
    "\n",
    "#function for writing json data\n",
    "json_obj = {\n",
    "    \"name\":\"larry\",\n",
    "    \"age\":20,\n",
    "    \"friends\":(\"John\", \"Sarah\")\n",
    "}\n",
    "def write_json(json_obj, file_name):\n",
    "    with open(file_name, \"w\") as file:\n",
    "        json.dump(json_obj, file)\n",
    "write_json(json_obj, \"example.json\")  "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 60,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "number of tasks: 200\n",
      "task1\n",
      "userid: 1\n",
      "task id: 1\n",
      "title: 1\n",
      "completed: False\n",
      "{'userId': 1, 'id': 1, 'title': 'delectus aut autem', 'completed': False}\n",
      "{'userId': 1, 'id': 2, 'title': 'quis ut nam facilis et officia qui', 'completed': False}\n",
      "{'userId': 1, 'id': 3, 'title': 'fugiat veniam minus', 'completed': False}\n",
      "{'userId': 1, 'id': 4, 'title': 'et porro tempora', 'completed': True}\n",
      "{'userId': 1, 'id': 5, 'title': 'laboriosam mollitia et enim quasi adipisci quia provident illum', 'completed': False}\n",
      "{'userId': 1, 'id': 6, 'title': 'qui ullam ratione quibusdam voluptatem quia omnis', 'completed': False}\n",
      "{'userId': 1, 'id': 7, 'title': 'illo expedita consequatur quia in', 'completed': False}\n",
      "{'userId': 1, 'id': 8, 'title': 'quo adipisci enim quam ut ab', 'completed': True}\n",
      "{'userId': 1, 'id': 9, 'title': 'molestiae perspiciatis ipsa', 'completed': False}\n",
      "{'userId': 1, 'id': 10, 'title': 'illo est ratione doloremque quia maiores aut', 'completed': True}\n",
      "{'userId': 1, 'id': 11, 'title': 'vero rerum temporibus dolor', 'completed': True}\n",
      "{'userId': 1, 'id': 12, 'title': 'ipsa repellendus fugit nisi', 'completed': True}\n",
      "{'userId': 1, 'id': 13, 'title': 'et doloremque nulla', 'completed': False}\n",
      "{'userId': 1, 'id': 14, 'title': 'repellendus sunt dolores architecto voluptatum', 'completed': True}\n",
      "{'userId': 1, 'id': 15, 'title': 'ab voluptatum amet voluptas', 'completed': True}\n",
      "{'userId': 1, 'id': 16, 'title': 'accusamus eos facilis sint et aut voluptatem', 'completed': True}\n",
      "{'userId': 1, 'id': 17, 'title': 'quo laboriosam deleniti aut qui', 'completed': True}\n",
      "{'userId': 1, 'id': 18, 'title': 'dolorum est consequatur ea mollitia in culpa', 'completed': False}\n",
      "{'userId': 1, 'id': 19, 'title': 'molestiae ipsa aut voluptatibus pariatur dolor nihil', 'completed': True}\n",
      "{'userId': 1, 'id': 20, 'title': 'ullam nobis libero sapiente ad optio sint', 'completed': True}\n",
      "{'userId': 2, 'id': 21, 'title': 'suscipit repellat esse quibusdam voluptatem incidunt', 'completed': False}\n",
      "{'userId': 2, 'id': 22, 'title': 'distinctio vitae autem nihil ut molestias quo', 'completed': True}\n",
      "{'userId': 2, 'id': 23, 'title': 'et itaque necessitatibus maxime molestiae qui quas velit', 'completed': False}\n",
      "{'userId': 2, 'id': 24, 'title': 'adipisci non ad dicta qui amet quaerat doloribus ea', 'completed': False}\n",
      "{'userId': 2, 'id': 25, 'title': 'voluptas quo tenetur perspiciatis explicabo natus', 'completed': True}\n",
      "{'userId': 2, 'id': 26, 'title': 'aliquam aut quasi', 'completed': True}\n",
      "{'userId': 2, 'id': 27, 'title': 'veritatis pariatur delectus', 'completed': True}\n",
      "{'userId': 2, 'id': 28, 'title': 'nesciunt totam sit blanditiis sit', 'completed': False}\n",
      "{'userId': 2, 'id': 29, 'title': 'laborum aut in quam', 'completed': False}\n",
      "{'userId': 2, 'id': 30, 'title': 'nemo perspiciatis repellat ut dolor libero commodi blanditiis omnis', 'completed': True}\n",
      "{'userId': 2, 'id': 31, 'title': 'repudiandae totam in est sint facere fuga', 'completed': False}\n",
      "{'userId': 2, 'id': 32, 'title': 'earum doloribus ea doloremque quis', 'completed': False}\n",
      "{'userId': 2, 'id': 33, 'title': 'sint sit aut vero', 'completed': False}\n",
      "{'userId': 2, 'id': 34, 'title': 'porro aut necessitatibus eaque distinctio', 'completed': False}\n",
      "{'userId': 2, 'id': 35, 'title': 'repellendus veritatis molestias dicta incidunt', 'completed': True}\n",
      "{'userId': 2, 'id': 36, 'title': 'excepturi deleniti adipisci voluptatem et neque optio illum ad', 'completed': True}\n",
      "{'userId': 2, 'id': 37, 'title': 'sunt cum tempora', 'completed': False}\n",
      "{'userId': 2, 'id': 38, 'title': 'totam quia non', 'completed': False}\n",
      "{'userId': 2, 'id': 39, 'title': 'doloremque quibusdam asperiores libero corrupti illum qui omnis', 'completed': False}\n",
      "{'userId': 2, 'id': 40, 'title': 'totam atque quo nesciunt', 'completed': True}\n",
      "{'userId': 3, 'id': 41, 'title': 'aliquid amet impedit consequatur aspernatur placeat eaque fugiat suscipit', 'completed': False}\n",
      "{'userId': 3, 'id': 42, 'title': 'rerum perferendis error quia ut eveniet', 'completed': False}\n",
      "{'userId': 3, 'id': 43, 'title': 'tempore ut sint quis recusandae', 'completed': True}\n",
      "{'userId': 3, 'id': 44, 'title': 'cum debitis quis accusamus doloremque ipsa natus sapiente omnis', 'completed': True}\n",
      "{'userId': 3, 'id': 45, 'title': 'velit soluta adipisci molestias reiciendis harum', 'completed': False}\n",
      "{'userId': 3, 'id': 46, 'title': 'vel voluptatem repellat nihil placeat corporis', 'completed': False}\n",
      "{'userId': 3, 'id': 47, 'title': 'nam qui rerum fugiat accusamus', 'completed': False}\n",
      "{'userId': 3, 'id': 48, 'title': 'sit reprehenderit omnis quia', 'completed': False}\n",
      "{'userId': 3, 'id': 49, 'title': 'ut necessitatibus aut maiores debitis officia blanditiis velit et', 'completed': False}\n",
      "{'userId': 3, 'id': 50, 'title': 'cupiditate necessitatibus ullam aut quis dolor voluptate', 'completed': True}\n",
      "{'userId': 3, 'id': 51, 'title': 'distinctio exercitationem ab doloribus', 'completed': False}\n",
      "{'userId': 3, 'id': 52, 'title': 'nesciunt dolorum quis recusandae ad pariatur ratione', 'completed': False}\n",
      "{'userId': 3, 'id': 53, 'title': 'qui labore est occaecati recusandae aliquid quam', 'completed': False}\n",
      "{'userId': 3, 'id': 54, 'title': 'quis et est ut voluptate quam dolor', 'completed': True}\n",
      "{'userId': 3, 'id': 55, 'title': 'voluptatum omnis minima qui occaecati provident nulla voluptatem ratione', 'completed': True}\n",
      "{'userId': 3, 'id': 56, 'title': 'deleniti ea temporibus enim', 'completed': True}\n",
      "{'userId': 3, 'id': 57, 'title': 'pariatur et magnam ea doloribus similique voluptatem rerum quia', 'completed': False}\n",
      "{'userId': 3, 'id': 58, 'title': 'est dicta totam qui explicabo doloribus qui dignissimos', 'completed': False}\n",
      "{'userId': 3, 'id': 59, 'title': 'perspiciatis velit id laborum placeat iusto et aliquam odio', 'completed': False}\n",
      "{'userId': 3, 'id': 60, 'title': 'et sequi qui architecto ut adipisci', 'completed': True}\n",
      "{'userId': 4, 'id': 61, 'title': 'odit optio omnis qui sunt', 'completed': True}\n",
      "{'userId': 4, 'id': 62, 'title': 'et placeat et tempore aspernatur sint numquam', 'completed': False}\n",
      "{'userId': 4, 'id': 63, 'title': 'doloremque aut dolores quidem fuga qui nulla', 'completed': True}\n",
      "{'userId': 4, 'id': 64, 'title': 'voluptas consequatur qui ut quia magnam nemo esse', 'completed': False}\n",
      "{'userId': 4, 'id': 65, 'title': 'fugiat pariatur ratione ut asperiores necessitatibus magni', 'completed': False}\n",
      "{'userId': 4, 'id': 66, 'title': 'rerum eum molestias autem voluptatum sit optio', 'completed': False}\n",
      "{'userId': 4, 'id': 67, 'title': 'quia voluptatibus voluptatem quos similique maiores repellat', 'completed': False}\n",
      "{'userId': 4, 'id': 68, 'title': 'aut id perspiciatis voluptatem iusto', 'completed': False}\n",
      "{'userId': 4, 'id': 69, 'title': 'doloribus sint dolorum ab adipisci itaque dignissimos aliquam suscipit', 'completed': False}\n",
      "{'userId': 4, 'id': 70, 'title': 'ut sequi accusantium et mollitia delectus sunt', 'completed': False}\n",
      "{'userId': 4, 'id': 71, 'title': 'aut velit saepe ullam', 'completed': False}\n",
      "{'userId': 4, 'id': 72, 'title': 'praesentium facilis facere quis harum voluptatibus voluptatem eum', 'completed': False}\n",
      "{'userId': 4, 'id': 73, 'title': 'sint amet quia totam corporis qui exercitationem commodi', 'completed': True}\n",
      "{'userId': 4, 'id': 74, 'title': 'expedita tempore nobis eveniet laborum maiores', 'completed': False}\n",
      "{'userId': 4, 'id': 75, 'title': 'occaecati adipisci est possimus totam', 'completed': False}\n",
      "{'userId': 4, 'id': 76, 'title': 'sequi dolorem sed', 'completed': True}\n",
      "{'userId': 4, 'id': 77, 'title': 'maiores aut nesciunt delectus exercitationem vel assumenda eligendi at', 'completed': False}\n",
      "{'userId': 4, 'id': 78, 'title': 'reiciendis est magnam amet nemo iste recusandae impedit quaerat', 'completed': False}\n",
      "{'userId': 4, 'id': 79, 'title': 'eum ipsa maxime ut', 'completed': True}\n",
      "{'userId': 4, 'id': 80, 'title': 'tempore molestias dolores rerum sequi voluptates ipsum consequatur', 'completed': True}\n",
      "{'userId': 5, 'id': 81, 'title': 'suscipit qui totam', 'completed': True}\n",
      "{'userId': 5, 'id': 82, 'title': 'voluptates eum voluptas et dicta', 'completed': False}\n",
      "{'userId': 5, 'id': 83, 'title': 'quidem at rerum quis ex aut sit quam', 'completed': True}\n",
      "{'userId': 5, 'id': 84, 'title': 'sunt veritatis ut voluptate', 'completed': False}\n",
      "{'userId': 5, 'id': 85, 'title': 'et quia ad iste a', 'completed': True}\n",
      "{'userId': 5, 'id': 86, 'title': 'incidunt ut saepe autem', 'completed': True}\n",
      "{'userId': 5, 'id': 87, 'title': 'laudantium quae eligendi consequatur quia et vero autem', 'completed': True}\n",
      "{'userId': 5, 'id': 88, 'title': 'vitae aut excepturi laboriosam sint aliquam et et accusantium', 'completed': False}\n",
      "{'userId': 5, 'id': 89, 'title': 'sequi ut omnis et', 'completed': True}\n",
      "{'userId': 5, 'id': 90, 'title': 'molestiae nisi accusantium tenetur dolorem et', 'completed': True}\n",
      "{'userId': 5, 'id': 91, 'title': 'nulla quis consequatur saepe qui id expedita', 'completed': True}\n",
      "{'userId': 5, 'id': 92, 'title': 'in omnis laboriosam', 'completed': True}\n",
      "{'userId': 5, 'id': 93, 'title': 'odio iure consequatur molestiae quibusdam necessitatibus quia sint', 'completed': True}\n",
      "{'userId': 5, 'id': 94, 'title': 'facilis modi saepe mollitia', 'completed': False}\n",
      "{'userId': 5, 'id': 95, 'title': 'vel nihil et molestiae iusto assumenda nemo quo ut', 'completed': True}\n",
      "{'userId': 5, 'id': 96, 'title': 'nobis suscipit ducimus enim asperiores voluptas', 'completed': False}\n",
      "{'userId': 5, 'id': 97, 'title': 'dolorum laboriosam eos qui iure aliquam', 'completed': False}\n",
      "{'userId': 5, 'id': 98, 'title': 'debitis accusantium ut quo facilis nihil quis sapiente necessitatibus', 'completed': True}\n",
      "{'userId': 5, 'id': 99, 'title': 'neque voluptates ratione', 'completed': False}\n",
      "{'userId': 5, 'id': 100, 'title': 'excepturi a et neque qui expedita vel voluptate', 'completed': False}\n",
      "{'userId': 6, 'id': 101, 'title': 'explicabo enim cumque porro aperiam occaecati minima', 'completed': False}\n",
      "{'userId': 6, 'id': 102, 'title': 'sed ab consequatur', 'completed': False}\n",
      "{'userId': 6, 'id': 103, 'title': 'non sunt delectus illo nulla tenetur enim omnis', 'completed': False}\n",
      "{'userId': 6, 'id': 104, 'title': 'excepturi non laudantium quo', 'completed': False}\n",
      "{'userId': 6, 'id': 105, 'title': 'totam quia dolorem et illum repellat voluptas optio', 'completed': True}\n",
      "{'userId': 6, 'id': 106, 'title': 'ad illo quis voluptatem temporibus', 'completed': True}\n",
      "{'userId': 6, 'id': 107, 'title': 'praesentium facilis omnis laudantium fugit ad iusto nihil nesciunt', 'completed': False}\n",
      "{'userId': 6, 'id': 108, 'title': 'a eos eaque nihil et exercitationem incidunt delectus', 'completed': True}\n",
      "{'userId': 6, 'id': 109, 'title': 'autem temporibus harum quisquam in culpa', 'completed': True}\n",
      "{'userId': 6, 'id': 110, 'title': 'aut aut ea corporis', 'completed': True}\n",
      "{'userId': 6, 'id': 111, 'title': 'magni accusantium labore et id quis provident', 'completed': False}\n",
      "{'userId': 6, 'id': 112, 'title': 'consectetur impedit quisquam qui deserunt non rerum consequuntur eius', 'completed': False}\n",
      "{'userId': 6, 'id': 113, 'title': 'quia atque aliquam sunt impedit voluptatum rerum assumenda nisi', 'completed': False}\n",
      "{'userId': 6, 'id': 114, 'title': 'cupiditate quos possimus corporis quisquam exercitationem beatae', 'completed': False}\n",
      "{'userId': 6, 'id': 115, 'title': 'sed et ea eum', 'completed': False}\n",
      "{'userId': 6, 'id': 116, 'title': 'ipsa dolores vel facilis ut', 'completed': True}\n",
      "{'userId': 6, 'id': 117, 'title': 'sequi quae est et qui qui eveniet asperiores', 'completed': False}\n",
      "{'userId': 6, 'id': 118, 'title': 'quia modi consequatur vero fugiat', 'completed': False}\n",
      "{'userId': 6, 'id': 119, 'title': 'corporis ducimus ea perspiciatis iste', 'completed': False}\n",
      "{'userId': 6, 'id': 120, 'title': 'dolorem laboriosam vel voluptas et aliquam quasi', 'completed': False}\n",
      "{'userId': 7, 'id': 121, 'title': 'inventore aut nihil minima laudantium hic qui omnis', 'completed': True}\n",
      "{'userId': 7, 'id': 122, 'title': 'provident aut nobis culpa', 'completed': True}\n",
      "{'userId': 7, 'id': 123, 'title': 'esse et quis iste est earum aut impedit', 'completed': False}\n",
      "{'userId': 7, 'id': 124, 'title': 'qui consectetur id', 'completed': False}\n",
      "{'userId': 7, 'id': 125, 'title': 'aut quasi autem iste tempore illum possimus', 'completed': False}\n",
      "{'userId': 7, 'id': 126, 'title': 'ut asperiores perspiciatis veniam ipsum rerum saepe', 'completed': True}\n",
      "{'userId': 7, 'id': 127, 'title': 'voluptatem libero consectetur rerum ut', 'completed': True}\n",
      "{'userId': 7, 'id': 128, 'title': 'eius omnis est qui voluptatem autem', 'completed': False}\n",
      "{'userId': 7, 'id': 129, 'title': 'rerum culpa quis harum', 'completed': False}\n",
      "{'userId': 7, 'id': 130, 'title': 'nulla aliquid eveniet harum laborum libero alias ut unde', 'completed': True}\n",
      "{'userId': 7, 'id': 131, 'title': 'qui ea incidunt quis', 'completed': False}\n",
      "{'userId': 7, 'id': 132, 'title': 'qui molestiae voluptatibus velit iure harum quisquam', 'completed': True}\n",
      "{'userId': 7, 'id': 133, 'title': 'et labore eos enim rerum consequatur sunt', 'completed': True}\n",
      "{'userId': 7, 'id': 134, 'title': 'molestiae doloribus et laborum quod ea', 'completed': False}\n",
      "{'userId': 7, 'id': 135, 'title': 'facere ipsa nam eum voluptates reiciendis vero qui', 'completed': False}\n",
      "{'userId': 7, 'id': 136, 'title': 'asperiores illo tempora fuga sed ut quasi adipisci', 'completed': False}\n",
      "{'userId': 7, 'id': 137, 'title': 'qui sit non', 'completed': False}\n",
      "{'userId': 7, 'id': 138, 'title': 'placeat minima consequatur rem qui ut', 'completed': True}\n",
      "{'userId': 7, 'id': 139, 'title': 'consequatur doloribus id possimus voluptas a voluptatem', 'completed': False}\n",
      "{'userId': 7, 'id': 140, 'title': 'aut consectetur in blanditiis deserunt quia sed laboriosam', 'completed': True}\n",
      "{'userId': 8, 'id': 141, 'title': 'explicabo consectetur debitis voluptates quas quae culpa rerum non', 'completed': True}\n",
      "{'userId': 8, 'id': 142, 'title': 'maiores accusantium architecto necessitatibus reiciendis ea aut', 'completed': True}\n",
      "{'userId': 8, 'id': 143, 'title': 'eum non recusandae cupiditate animi', 'completed': False}\n",
      "{'userId': 8, 'id': 144, 'title': 'ut eum exercitationem sint', 'completed': False}\n",
      "{'userId': 8, 'id': 145, 'title': 'beatae qui ullam incidunt voluptatem non nisi aliquam', 'completed': False}\n",
      "{'userId': 8, 'id': 146, 'title': 'molestiae suscipit ratione nihil odio libero impedit vero totam', 'completed': True}\n",
      "{'userId': 8, 'id': 147, 'title': 'eum itaque quod reprehenderit et facilis dolor autem ut', 'completed': True}\n",
      "{'userId': 8, 'id': 148, 'title': 'esse quas et quo quasi exercitationem', 'completed': False}\n",
      "{'userId': 8, 'id': 149, 'title': 'animi voluptas quod perferendis est', 'completed': False}\n",
      "{'userId': 8, 'id': 150, 'title': 'eos amet tempore laudantium fugit a', 'completed': False}\n",
      "{'userId': 8, 'id': 151, 'title': 'accusamus adipisci dicta qui quo ea explicabo sed vero', 'completed': True}\n",
      "{'userId': 8, 'id': 152, 'title': 'odit eligendi recusandae doloremque cumque non', 'completed': False}\n",
      "{'userId': 8, 'id': 153, 'title': 'ea aperiam consequatur qui repellat eos', 'completed': False}\n",
      "{'userId': 8, 'id': 154, 'title': 'rerum non ex sapiente', 'completed': True}\n",
      "{'userId': 8, 'id': 155, 'title': 'voluptatem nobis consequatur et assumenda magnam', 'completed': True}\n",
      "{'userId': 8, 'id': 156, 'title': 'nam quia quia nulla repellat assumenda quibusdam sit nobis', 'completed': True}\n",
      "{'userId': 8, 'id': 157, 'title': 'dolorem veniam quisquam deserunt repellendus', 'completed': True}\n",
      "{'userId': 8, 'id': 158, 'title': 'debitis vitae delectus et harum accusamus aut deleniti a', 'completed': True}\n",
      "{'userId': 8, 'id': 159, 'title': 'debitis adipisci quibusdam aliquam sed dolore ea praesentium nobis', 'completed': True}\n",
      "{'userId': 8, 'id': 160, 'title': 'et praesentium aliquam est', 'completed': False}\n",
      "{'userId': 9, 'id': 161, 'title': 'ex hic consequuntur earum omnis alias ut occaecati culpa', 'completed': True}\n",
      "{'userId': 9, 'id': 162, 'title': 'omnis laboriosam molestias animi sunt dolore', 'completed': True}\n",
      "{'userId': 9, 'id': 163, 'title': 'natus corrupti maxime laudantium et voluptatem laboriosam odit', 'completed': False}\n",
      "{'userId': 9, 'id': 164, 'title': 'reprehenderit quos aut aut consequatur est sed', 'completed': False}\n",
      "{'userId': 9, 'id': 165, 'title': 'fugiat perferendis sed aut quidem', 'completed': False}\n",
      "{'userId': 9, 'id': 166, 'title': 'quos quo possimus suscipit minima ut', 'completed': False}\n",
      "{'userId': 9, 'id': 167, 'title': 'et quis minus quo a asperiores molestiae', 'completed': False}\n",
      "{'userId': 9, 'id': 168, 'title': 'recusandae quia qui sunt libero', 'completed': False}\n",
      "{'userId': 9, 'id': 169, 'title': 'ea odio perferendis officiis', 'completed': True}\n",
      "{'userId': 9, 'id': 170, 'title': 'quisquam aliquam quia doloribus aut', 'completed': False}\n",
      "{'userId': 9, 'id': 171, 'title': 'fugiat aut voluptatibus corrupti deleniti velit iste odio', 'completed': True}\n",
      "{'userId': 9, 'id': 172, 'title': 'et provident amet rerum consectetur et voluptatum', 'completed': False}\n",
      "{'userId': 9, 'id': 173, 'title': 'harum ad aperiam quis', 'completed': False}\n",
      "{'userId': 9, 'id': 174, 'title': 'similique aut quo', 'completed': False}\n",
      "{'userId': 9, 'id': 175, 'title': 'laudantium eius officia perferendis provident perspiciatis asperiores', 'completed': True}\n",
      "{'userId': 9, 'id': 176, 'title': 'magni soluta corrupti ut maiores rem quidem', 'completed': False}\n",
      "{'userId': 9, 'id': 177, 'title': 'et placeat temporibus voluptas est tempora quos quibusdam', 'completed': False}\n",
      "{'userId': 9, 'id': 178, 'title': 'nesciunt itaque commodi tempore', 'completed': True}\n",
      "{'userId': 9, 'id': 179, 'title': 'omnis consequuntur cupiditate impedit itaque ipsam quo', 'completed': True}\n",
      "{'userId': 9, 'id': 180, 'title': 'debitis nisi et dolorem repellat et', 'completed': True}\n",
      "{'userId': 10, 'id': 181, 'title': 'ut cupiditate sequi aliquam fuga maiores', 'completed': False}\n",
      "{'userId': 10, 'id': 182, 'title': 'inventore saepe cumque et aut illum enim', 'completed': True}\n",
      "{'userId': 10, 'id': 183, 'title': 'omnis nulla eum aliquam distinctio', 'completed': True}\n",
      "{'userId': 10, 'id': 184, 'title': 'molestias modi perferendis perspiciatis', 'completed': False}\n",
      "{'userId': 10, 'id': 185, 'title': 'voluptates dignissimos sed doloribus animi quaerat aut', 'completed': False}\n",
      "{'userId': 10, 'id': 186, 'title': 'explicabo odio est et', 'completed': False}\n",
      "{'userId': 10, 'id': 187, 'title': 'consequuntur animi possimus', 'completed': False}\n",
      "{'userId': 10, 'id': 188, 'title': 'vel non beatae est', 'completed': True}\n",
      "{'userId': 10, 'id': 189, 'title': 'culpa eius et voluptatem et', 'completed': True}\n",
      "{'userId': 10, 'id': 190, 'title': 'accusamus sint iusto et voluptatem exercitationem', 'completed': True}\n",
      "{'userId': 10, 'id': 191, 'title': 'temporibus atque distinctio omnis eius impedit tempore molestias pariatur', 'completed': True}\n",
      "{'userId': 10, 'id': 192, 'title': 'ut quas possimus exercitationem sint voluptates', 'completed': False}\n",
      "{'userId': 10, 'id': 193, 'title': 'rerum debitis voluptatem qui eveniet tempora distinctio a', 'completed': True}\n",
      "{'userId': 10, 'id': 194, 'title': 'sed ut vero sit molestiae', 'completed': False}\n",
      "{'userId': 10, 'id': 195, 'title': 'rerum ex veniam mollitia voluptatibus pariatur', 'completed': True}\n",
      "{'userId': 10, 'id': 196, 'title': 'consequuntur aut ut fugit similique', 'completed': True}\n",
      "{'userId': 10, 'id': 197, 'title': 'dignissimos quo nobis earum saepe', 'completed': True}\n",
      "{'userId': 10, 'id': 198, 'title': 'quis eius est sint explicabo', 'completed': True}\n",
      "{'userId': 10, 'id': 199, 'title': 'numquam repellendus a magnam', 'completed': True}\n",
      "{'userId': 10, 'id': 200, 'title': 'ipsam aperiam voluptates qui', 'completed': False}\n"
     ]
    }
   ],
   "source": [
    "#downloading json files\n",
    "response = requests.get(\"https://cutt.ly/json\")\n",
    "input_list = json.loads(response.text)\n",
    "task1 = input_list[0]\n",
    "print(f\"number of tasks: {len(input_list)}\")\n",
    "print(f\"task1\\nuserid: {task1['userId']}\\ntask id: {task1['id']}\\ntitle: {task1['userId']}\\ncompleted: {task1['completed']}\")\n",
    "\n",
    "for i in input_list:\n",
    "    print(i)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 62,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "[{\"userId\": 1, \"id\": 4, \"title\": \"et porro tempora\", \"completed\": true}, {\"userId\": 1, \"id\": 8, \"title\": \"quo adipisci enim quam ut ab\", \"completed\": true}, {\"userId\": 1, \"id\": 10, \"title\": \"illo est ratione doloremque quia maiores aut\", \"completed\": true}, {\"userId\": 1, \"id\": 11, \"title\": \"vero rerum temporibus dolor\", \"completed\": true}, {\"userId\": 1, \"id\": 12, \"title\": \"ipsa repellendus fugit nisi\", \"completed\": true}, {\"userId\": 1, \"id\": 14, \"title\": \"repellendus sunt dolores architecto voluptatum\", \"completed\": true}, {\"userId\": 1, \"id\": 15, \"title\": \"ab voluptatum amet voluptas\", \"completed\": true}, {\"userId\": 1, \"id\": 16, \"title\": \"accusamus eos facilis sint et aut voluptatem\", \"completed\": true}, {\"userId\": 1, \"id\": 17, \"title\": \"quo laboriosam deleniti aut qui\", \"completed\": true}, {\"userId\": 1, \"id\": 19, \"title\": \"molestiae ipsa aut voluptatibus pariatur dolor nihil\", \"completed\": true}, {\"userId\": 1, \"id\": 20, \"title\": \"ullam nobis libero sapiente ad optio sint\", \"completed\": true}, {\"userId\": 2, \"id\": 22, \"title\": \"distinctio vitae autem nihil ut molestias quo\", \"completed\": true}, {\"userId\": 2, \"id\": 25, \"title\": \"voluptas quo tenetur perspiciatis explicabo natus\", \"completed\": true}, {\"userId\": 2, \"id\": 26, \"title\": \"aliquam aut quasi\", \"completed\": true}, {\"userId\": 2, \"id\": 27, \"title\": \"veritatis pariatur delectus\", \"completed\": true}, {\"userId\": 2, \"id\": 30, \"title\": \"nemo perspiciatis repellat ut dolor libero commodi blanditiis omnis\", \"completed\": true}, {\"userId\": 2, \"id\": 35, \"title\": \"repellendus veritatis molestias dicta incidunt\", \"completed\": true}, {\"userId\": 2, \"id\": 36, \"title\": \"excepturi deleniti adipisci voluptatem et neque optio illum ad\", \"completed\": true}, {\"userId\": 2, \"id\": 40, \"title\": \"totam atque quo nesciunt\", \"completed\": true}, {\"userId\": 3, \"id\": 43, \"title\": \"tempore ut sint quis recusandae\", \"completed\": true}, {\"userId\": 3, \"id\": 44, \"title\": \"cum debitis quis accusamus doloremque ipsa natus sapiente omnis\", \"completed\": true}, {\"userId\": 3, \"id\": 50, \"title\": \"cupiditate necessitatibus ullam aut quis dolor voluptate\", \"completed\": true}, {\"userId\": 3, \"id\": 54, \"title\": \"quis et est ut voluptate quam dolor\", \"completed\": true}, {\"userId\": 3, \"id\": 55, \"title\": \"voluptatum omnis minima qui occaecati provident nulla voluptatem ratione\", \"completed\": true}, {\"userId\": 3, \"id\": 56, \"title\": \"deleniti ea temporibus enim\", \"completed\": true}, {\"userId\": 3, \"id\": 60, \"title\": \"et sequi qui architecto ut adipisci\", \"completed\": true}, {\"userId\": 4, \"id\": 61, \"title\": \"odit optio omnis qui sunt\", \"completed\": true}, {\"userId\": 4, \"id\": 63, \"title\": \"doloremque aut dolores quidem fuga qui nulla\", \"completed\": true}, {\"userId\": 4, \"id\": 73, \"title\": \"sint amet quia totam corporis qui exercitationem commodi\", \"completed\": true}, {\"userId\": 4, \"id\": 76, \"title\": \"sequi dolorem sed\", \"completed\": true}, {\"userId\": 4, \"id\": 79, \"title\": \"eum ipsa maxime ut\", \"completed\": true}, {\"userId\": 4, \"id\": 80, \"title\": \"tempore molestias dolores rerum sequi voluptates ipsum consequatur\", \"completed\": true}, {\"userId\": 5, \"id\": 81, \"title\": \"suscipit qui totam\", \"completed\": true}, {\"userId\": 5, \"id\": 83, \"title\": \"quidem at rerum quis ex aut sit quam\", \"completed\": true}, {\"userId\": 5, \"id\": 85, \"title\": \"et quia ad iste a\", \"completed\": true}, {\"userId\": 5, \"id\": 86, \"title\": \"incidunt ut saepe autem\", \"completed\": true}, {\"userId\": 5, \"id\": 87, \"title\": \"laudantium quae eligendi consequatur quia et vero autem\", \"completed\": true}, {\"userId\": 5, \"id\": 89, \"title\": \"sequi ut omnis et\", \"completed\": true}, {\"userId\": 5, \"id\": 90, \"title\": \"molestiae nisi accusantium tenetur dolorem et\", \"completed\": true}, {\"userId\": 5, \"id\": 91, \"title\": \"nulla quis consequatur saepe qui id expedita\", \"completed\": true}, {\"userId\": 5, \"id\": 92, \"title\": \"in omnis laboriosam\", \"completed\": true}, {\"userId\": 5, \"id\": 93, \"title\": \"odio iure consequatur molestiae quibusdam necessitatibus quia sint\", \"completed\": true}, {\"userId\": 5, \"id\": 95, \"title\": \"vel nihil et molestiae iusto assumenda nemo quo ut\", \"completed\": true}, {\"userId\": 5, \"id\": 98, \"title\": \"debitis accusantium ut quo facilis nihil quis sapiente necessitatibus\", \"completed\": true}, {\"userId\": 6, \"id\": 105, \"title\": \"totam quia dolorem et illum repellat voluptas optio\", \"completed\": true}, {\"userId\": 6, \"id\": 106, \"title\": \"ad illo quis voluptatem temporibus\", \"completed\": true}, {\"userId\": 6, \"id\": 108, \"title\": \"a eos eaque nihil et exercitationem incidunt delectus\", \"completed\": true}, {\"userId\": 6, \"id\": 109, \"title\": \"autem temporibus harum quisquam in culpa\", \"completed\": true}, {\"userId\": 6, \"id\": 110, \"title\": \"aut aut ea corporis\", \"completed\": true}, {\"userId\": 6, \"id\": 116, \"title\": \"ipsa dolores vel facilis ut\", \"completed\": true}, {\"userId\": 7, \"id\": 121, \"title\": \"inventore aut nihil minima laudantium hic qui omnis\", \"completed\": true}, {\"userId\": 7, \"id\": 122, \"title\": \"provident aut nobis culpa\", \"completed\": true}, {\"userId\": 7, \"id\": 126, \"title\": \"ut asperiores perspiciatis veniam ipsum rerum saepe\", \"completed\": true}, {\"userId\": 7, \"id\": 127, \"title\": \"voluptatem libero consectetur rerum ut\", \"completed\": true}, {\"userId\": 7, \"id\": 130, \"title\": \"nulla aliquid eveniet harum laborum libero alias ut unde\", \"completed\": true}, {\"userId\": 7, \"id\": 132, \"title\": \"qui molestiae voluptatibus velit iure harum quisquam\", \"completed\": true}, {\"userId\": 7, \"id\": 133, \"title\": \"et labore eos enim rerum consequatur sunt\", \"completed\": true}, {\"userId\": 7, \"id\": 138, \"title\": \"placeat minima consequatur rem qui ut\", \"completed\": true}, {\"userId\": 7, \"id\": 140, \"title\": \"aut consectetur in blanditiis deserunt quia sed laboriosam\", \"completed\": true}, {\"userId\": 8, \"id\": 141, \"title\": \"explicabo consectetur debitis voluptates quas quae culpa rerum non\", \"completed\": true}, {\"userId\": 8, \"id\": 142, \"title\": \"maiores accusantium architecto necessitatibus reiciendis ea aut\", \"completed\": true}, {\"userId\": 8, \"id\": 146, \"title\": \"molestiae suscipit ratione nihil odio libero impedit vero totam\", \"completed\": true}, {\"userId\": 8, \"id\": 147, \"title\": \"eum itaque quod reprehenderit et facilis dolor autem ut\", \"completed\": true}, {\"userId\": 8, \"id\": 151, \"title\": \"accusamus adipisci dicta qui quo ea explicabo sed vero\", \"completed\": true}, {\"userId\": 8, \"id\": 154, \"title\": \"rerum non ex sapiente\", \"completed\": true}, {\"userId\": 8, \"id\": 155, \"title\": \"voluptatem nobis consequatur et assumenda magnam\", \"completed\": true}, {\"userId\": 8, \"id\": 156, \"title\": \"nam quia quia nulla repellat assumenda quibusdam sit nobis\", \"completed\": true}, {\"userId\": 8, \"id\": 157, \"title\": \"dolorem veniam quisquam deserunt repellendus\", \"completed\": true}, {\"userId\": 8, \"id\": 158, \"title\": \"debitis vitae delectus et harum accusamus aut deleniti a\", \"completed\": true}, {\"userId\": 8, \"id\": 159, \"title\": \"debitis adipisci quibusdam aliquam sed dolore ea praesentium nobis\", \"completed\": true}, {\"userId\": 9, \"id\": 161, \"title\": \"ex hic consequuntur earum omnis alias ut occaecati culpa\", \"completed\": true}, {\"userId\": 9, \"id\": 162, \"title\": \"omnis laboriosam molestias animi sunt dolore\", \"completed\": true}, {\"userId\": 9, \"id\": 169, \"title\": \"ea odio perferendis officiis\", \"completed\": true}, {\"userId\": 9, \"id\": 171, \"title\": \"fugiat aut voluptatibus corrupti deleniti velit iste odio\", \"completed\": true}, {\"userId\": 9, \"id\": 175, \"title\": \"laudantium eius officia perferendis provident perspiciatis asperiores\", \"completed\": true}, {\"userId\": 9, \"id\": 178, \"title\": \"nesciunt itaque commodi tempore\", \"completed\": true}, {\"userId\": 9, \"id\": 179, \"title\": \"omnis consequuntur cupiditate impedit itaque ipsam quo\", \"completed\": true}, {\"userId\": 9, \"id\": 180, \"title\": \"debitis nisi et dolorem repellat et\", \"completed\": true}, {\"userId\": 10, \"id\": 182, \"title\": \"inventore saepe cumque et aut illum enim\", \"completed\": true}, {\"userId\": 10, \"id\": 183, \"title\": \"omnis nulla eum aliquam distinctio\", \"completed\": true}, {\"userId\": 10, \"id\": 188, \"title\": \"vel non beatae est\", \"completed\": true}, {\"userId\": 10, \"id\": 189, \"title\": \"culpa eius et voluptatem et\", \"completed\": true}, {\"userId\": 10, \"id\": 190, \"title\": \"accusamus sint iusto et voluptatem exercitationem\", \"completed\": true}, {\"userId\": 10, \"id\": 191, \"title\": \"temporibus atque distinctio omnis eius impedit tempore molestias pariatur\", \"completed\": true}, {\"userId\": 10, \"id\": 193, \"title\": \"rerum debitis voluptatem qui eveniet tempora distinctio a\", \"completed\": true}, {\"userId\": 10, \"id\": 195, \"title\": \"rerum ex veniam mollitia voluptatibus pariatur\", \"completed\": true}, {\"userId\": 10, \"id\": 196, \"title\": \"consequuntur aut ut fugit similique\", \"completed\": true}, {\"userId\": 10, \"id\": 197, \"title\": \"dignissimos quo nobis earum saepe\", \"completed\": true}, {\"userId\": 10, \"id\": 198, \"title\": \"quis eius est sint explicabo\", \"completed\": true}, {\"userId\": 10, \"id\": 199, \"title\": \"numquam repellendus a magnam\", \"completed\": true}]\n"
     ]
    }
   ],
   "source": [
    "#only save completed tasks\n",
    "def save_completed_tasks(url):\n",
    "    response = requests.get(url)\n",
    "    input_list = json.loads(response.text)\n",
    "    completed_list = []\n",
    "    for i in input_list:\n",
    "        if i[\"completed\"] == True:\n",
    "            completed_list.append(i)\n",
    "    return json.dumps(completed_list)\n",
    "\n",
    "print(save_completed_tasks(\"https://cutt.ly/json\"))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 72,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "row 1:  COP Police forces\n",
      "row 2:  GOV Government\n",
      "row 3:  INS Insurgents\n",
      "row 4:  JUD Judiciary\n",
      "row 5:  MIL Military\n",
      "row 6:  OPP Opposition (politics)\n",
      "row 7:  REB Rebels\n",
      "row 8:  SEP Separatism\n",
      "row 9:  SPY State Intelligence Service\n",
      "row 10:  UAF Violent non-state actor\n",
      "row 11:  AGR Agriculture\n",
      "row 12:  BUS Business\n",
      "row 13:  CRM Criminal\n",
      "row 14:  CVL Civilian\n",
      "row 15:  DEV Development\n",
      "row 16:  EDU Education\n",
      "row 17:  ELI Elites\n",
      "row 18:  ENV Environmental\n",
      "row 19:  HLH Health\n",
      "row 20:  HRI Human Rights\n",
      "row 21:  LAB Labor\n",
      "row 22:  LEG Legislature\n",
      "row 23:  MED Media\n",
      "row 24:  REF Refugees\n",
      "row 25:  MOD Moderate\n",
      "row 26:  RAD Radical\n",
      "row 27:  AMN Amnesty International\n",
      "row 28:  IRC Red Cross\n",
      "row 29:  GRP Greenpeace\n",
      "row 30:  UNO United Nations\n",
      "row 31:  PKO Peacekeepers\n",
      "row 32:  IGO Inter-Governmental Organization\n",
      "row 33:  IMG Irregular military\n",
      "row 34:  INT International/Transnational Generic\n",
      "row 35:  MNC Multinational Corporation\n",
      "row 36:  NGM Social movement\n",
      "row 37:  NGO Non-Governmental Organization\n",
      "row 38:  UIS State actor\n",
      "row 39:  SET Settler\n"
     ]
    }
   ],
   "source": [
    "#open csv files\n",
    "with open(\"actors.csv\") as csv_file:\n",
    "    csv_reader = csv.reader(csv_file, delimiter=\",\")\n",
    "    row_count = 1\n",
    "    for row in csv_reader:\n",
    "        row_list = row[0].split(\"\\t\")\n",
    "        print(\"row\", str(row_count) + \": \", row_list[0], row_list[1])\n",
    "        row_count += 1"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "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.4"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}