Answer Happy

Pick a Dataset 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 1.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.

Prompt Download this Jupyter Notebooks file: Pandas Data Part 1.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. Summary Statistic & Adding a Column o Create a new column in your data that totals some of the numerical statistics. (Pick the numbers that make sense for your data.) 3. Rearrange Your Columns o Put the new total column of your data in the second position of your data table. 4. Viewing Columns o Create a new variable and save a version of your data frame that is only 3 columns of your choice to that variable.

Back lego_sets.csv 22 com prod_desc Catapult into action and take back the eggs from the Piggy Tiket Launch a flying attack and rescue the eggs from the Pigey Planet Chase the piggy with lightning-fast Chuck and rescue the 99st Explore the architecture of the United States Capitol Building Recreate the Solomon R. Guggenheim Museum with LEGO® An Celebrate Shanghai with this LEGO Architecture Skyline sett Celebrate New York City with this LEGO® Architecture Skyline Recreate Buckingham Palace with LEGO Architecture Celebrate London with this LEGO Architecture Skyline modell Celebrate Chicago with this LEGO® Architecture Skyline model Experience the grandeur of the Arc de Triomphe! 33 Build your own LEGO Interpretation of the iconic Eiffel Tower Celebrate Sydney with this LEGO® Architecture Skyline modell Bring your LEGO creations to Wel Build a LEGO BrickHeadz version of yourself Train a raptor with LEGO BrickHeadz Owen and Bluet Join Mr. Incredible and Frozone for LEGO BrickHeadz crime-fis Gront like a Wookiee with a LEGO Bricode construction ch Be a rogue with a LEGO BrickHeadz construction character for RE Save the universe with LEGO BrickHeadz Iron Man MKSO Feel the power of Infinity with LEGO BrickHeadz Thanos! Be a legendary outlaw with LEGO BrickHeadz Star-Lord Master the skills of a green-skinned assassin with LEGO Brick Join the Resistance with a LEGO BrickHeadz construction Chara Say "I love you with a LEGO BrickHeadz Valentine's Beel Stand tall with LEGO BrickHeadz Wonder Woman 2 Live life in the fastlane with LEGO® BrickHeadz The Flash Summon the dark side with a LEGO Brickhead construction ch Feel the force with a LEGO BrickHeade construction character Dive in with LEGO BrickHeadz Aquaman Get an upgrade with LEGO BrickHeadz Cyborg Travel back to the future with LEGO BrickHeadz Marty McFly Join the Justice League with LEGO BrickHeade Tactical Batm Hop to it with a LEGO BrickHeadz Easter Bunny! . Unleash your true ninja spirit with LEGO BrickHeadz Uloyd! Learn the way of the ninja with LEGO BrickHeadz Master Wul Lead a LEGO BrickHeadz ghost crew featuring Disney's Captain 33 Lead the First Order with a LEGO BrickHeadz construction chana Celebrate THE LEGO BATMAN MOVIE with a LEGO BrickHeadz 3 Stand your ground with your own LEGO BrickHeadz Iron Man! Treasure your own LEGO BrickHeadir construction character fear Have a smashing time with LEGO BrickHeade The Hulk Add some Disney fairytale romance with a LEGO® BrickHeade.com Bring a classic Disney tale to life with a LEGO BrickHead const Show off the evil trickster with LEGO BrickHeadz The Joke Recruit your own elite agent with LEGO BrickHeadz Black Showcase the Boy Wonder with LEGO BrickHeadr Robin 13 Channel Batgirl with your own LEGO BrickHeadz versie Keep the crooks from escaping with the gold bars! Move heavy goods across LEGO City with the Cargo Train Get and LEGO City fast in the bed Passer 14

Pandas Data Part 1 (4) pynb 2 "cells cell type":"markdown metadata": 0) source Load Data Into Pandasın "Load your data into Pandas. Pick a useful and short variable to hold the data frame." 10 21 12 "cell_type": "code" 13 "execution_count":9, 14 "metadata": 0) 15 Woutputs":[] 10 "source": 17 "import pandas as pd\n", 18 your code here" 19 20 > 22 "cell_type":"markdown", 23 metadata": 24 "source": # Summary Statistic & Adding a Column", 20 "Create new column in your data that totals some of the numerical statistics (Pick the numbers that makes for your data.)" 20 29 30 "cell type""code" 31 execution count": null 22 metadata"). outputs "source 35 your code here

Pandas Data Part 1(4).jpynt "cell_type":"markdown", "metadata": 0) "source": " Rearrange Your Columns in "Put the new total column of your data in the second position of your data table." ) . 51 32 5 "cell_type": "code" "execution count": null, metadata: 0 "outputs: 1. "source" your code here" 1 50 57 5 5 "cell type": "sarkdown". etadata "source", * Viewing Columns "Create a new variable and save a version of your data fram that is only 3 columns of your choice to that variable 62 "cell typen "code", execution continul etadata outputs 11 wyour code here"

we nerer ] "metadata": "kernelspec" : { "display_name": "Python 3". "language": "python", "name": "python3" 1. "language_info": { "codemirror mode" : { "name":"ipython", "version": 3 3 1 -2 34 "file extension": ".py", "mimetype": "text/x-python" "name": "python", B7 "nbconvert_exporter": "python", Ba "pygments lexe": "apython3" 89 "version": "3.8.3" 90 1 93) 92 Wnbformat" 4 93"nformat_sinar4