Answer Happy

Pick a Data Set Pick one of the following datasets: cereal.csv • lego sets.csv museums.csv • netflix_titles.csv • UFO sightings.csv • zoo.csv Prompt Download this Jupyter Notebooks file: Pandas Data Part 2.ipynb You may have to move this file to your root directory folder. Complete each of the prompts in the cells following the prompt in the Python file. There blocks say "your code here" in a comment. Make sure to run your cells to make sure that your code works. The prompts include: 1. Load Data into Pandas o Load your data into Pandas. Pick a useful and short variable to hold the data frame. 2. Save your Data o Save your data to a new .csv file and to a new Excel file.

Prompt Download this Jupyter Notebooks file: Pandas Data Part 2.ipynb You may have to move this file to your root directory folder. Complete each of the prompts in the cells following the prompt in the Python file. There blocks say "your code here" in a comment. Make sure to run your cells to make sure that your code works. The prompts include: 1. Load Data into Pandas o Load your data into Pandas. Pick a useful and short variable to hold the data frame. 2. Save your Data o Save your data to a new .csv file and to a new Excel file. 3. Filter Data • Filter your data by two conditions. An example would be: show me results where score is < 50% and type is equal to 'student' 4. Reset Index o Reset the index for your filtered data frame. 5. Filter by Text o Filter you data by condition that has to do with the text. An example would be: show me results where the name contains "ie"

Back lego_sets.csv -- S. 20 SUBGEGEBBIEBESEBS > prod_desc Catapult into action and take back the eggs from the Piggy Tre! Launch a flying attack and rescue the eggs from the Piggy Planet Chase the piggy with lightning-tast Chuck and rescue the eggs Explore the architecture of the United States Capital Building! Recreate the Solomon R. Guggenheim Museum with LEGO A Celebrate Shanghai with this LEGO® Architecture Skyline sett Celebrate New York City with this LEGO® Architecture Skyline me Recreate Buckingham Palace with LEGO Architecture Celebrate London with this LEGO Architecture Skyline modell Celebrate Chicago with this LEGO® Architecture Skyline modell Experience the grandeur of the Arc de Triomphe! Build your own LEGOs interpretation of the iconic Eiffel Tower Celebrate Sydney with this LEGO Architecture Skyline model! Bring your LEGO Creations to life! Build a LEGO BrickHeadz version of yourself! Train a raptor with LEGO BrickHeadem Owen and Blue Join Me, Incredible and Frozone for LEGO BrickHeade crime Growl like a Wookiee with a LEGO BrickHeadz construction ch Be a rogue with a LEGO BrickHeade construction character fer Save the universe with LEGO BrickHeadz Iron Man MKSO Feel the power of Infinity with LEGO BrickHeade Thanos! Be a legendary outlaw with LEGO® BrickHeade Star-Lord! Master the skills of a green-skinned assassin with LEGO® BrickH Join the Resistance with a LEGO BrickHeate construction charac Say "I love you with a LEGO BrickHeadz Valentine's Beet Stand tall with LEGO® BrickHeadz Wonder Woman Live Wife in the fast lane with LEGO® BrickHeade The Flash Summon the dark side with a LEGO BrickHeads construction ch Feel the Force with a LEGO BrickHeadz construction character a Dive in with LEGO® BrickHeadz Aquanian Get an upgrade with LEGO® BrickHeadr Cyborg Travel back to the future with LEGO BrickHeadz Marty McFly a Join the Justice League with LEGO BrickHead Tactical Batm Hop to it with a LEGO BrickHeadz Easter Bunny! Unleash your true ninja spirit with LEGO BrickHeadz Lloyd Learn the way of the ninja with LEGO BrickHeadz Master Wu! Lead a LEGO® BrickHeade ghost crew featuring Disney's Captain Lead the First Order with a LEGO BrickHeade construction chan Celebrate THE LEGO® BATMAN MOVIE with a LEGO BrickHeadz B Stand your ground with your own LEGO BrickHeadz Iron Mant Treasure your own LEGO BrickHeadz construction character fear Have a smashing time with LEGO Brick Meade The Hulk Add some Disney Fairytale romance with a LEGO BrickHeadz co Bring a classic Disney tale to life with a LEGO® BrickHeadz const Show off the evil trickster with LEGO® BrickHeade The Jok Recruit your own elite agent with LEGO BrickHeadz Black Showcase the Boy Wonder with LEGO BrickHeadz Robin Channel Batgirl with your own LEGO BrickHeadz versio Keep the crooks from escaping with the gold barsi Move heavy goods across LEGO City with the Cargo Train Get around LEGO® City fast in the High-speed Passenger Th BOB 0 12 » 23 -- 1 4

6) N 1 2 "cells": [ { 4 "cell_type":"markdown", 5 "metadata": 0, 6 "source": [ 7 ## Load Data Into Pandas\n", 8 "Load your data into Pandas. Pick a useful and short variable to hold the data frame." 9 10 } 11 { 12 "cell_type": "code" 13 "execution_count": 9, 14 "metadata": 0, 15 "outputs": 0, 16 "source": [ 17 "import pandas as pd\n", 18 #your code here" ] 20 }, 21 { 22 "cell_type": "markdown", 23 "metadata": 0) 24 "source": [ 25 *#* Save your data\n", "Save your data to a new .csv file and to a new Excel file. 27 3 3. 29 { 30 "cell_type": "code", 31 "execution_count": null, 32 "metadata": 0, 33 "outputs": 0, 34 "source": 35 #your code here" 36 37 19 CON 26 28

38 39 40 { "cell type": "markdown" "metadata": 0). "source": # Filter Datain" "Filter your data by two conditions. An example would be: show me results where score is < 50% and type is equal studenti 42 43 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 } { "cell type": "code", "execution_count": null, "metadata": O "outputs": 0, "source": "your code here! 1 62 03 64 65 66 67 ( "cell_type": "warkdown" metadata": 0, "source": # Reset Index\n" "Reset the index for your filtered data frane. 3 > { "cell type": "code" Pexecution_count": null "metadata": 0) "outputs": "source": #your code here" 68 69 70 3 71 72 73 74 "cell_type":"markdown" metadata

"metadata": 0, "source": # Filter by Text\n", "Filter your data by a condition that has to do with the text. An example would be show me results where the name contains } ( "cell_type": "code" "execution_count": null, "metadata": () "outputs": 01 "source": [ #your code here" ] "metadata":{ "kernelspec": "display_name": "Python 3, "language": "python", "name": "python3" Language_info": { "codemirror_mode" : { "name": "Apython", "version": 3 file_extension": ".py", mimetype": "text/x-python", "name": "python", "nbconvert_exporter": "python", "pygments lexer":"ipython3" "version": "3.8.3" "nbformat haram ננט