Link To The Files Needed Https Docs Google Com Document D 1oe Le2nlkb7 Mtzddo Brvvdzzrouuuogcxdohow1vu Edit Usp Shari 1 (104.16 KiB) Viewed 51 times
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 o 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"
Pick a Data Set Pick one of the following datasets: O • 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.
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!