pandas-challenge

Homework Repo for Challenge 4

Author: Laura Bishop

Overview

I received help and support from my fellow Data Vis classmates via our Discord Server (both through voice chat and text), as well as our class-provided Slack Channel. I regularly attend both before- and after-class Office Hours to engage the materials with the Instructor and TAs.

I rewatched several of the classes from Module 4 using the Zoom recordings found at BSC > Zoom > Cloud Recordings. In conjunction with that, I re-reviewed the Module 3 and 4 Instructor Demos provided through GitLab.

I used the Python code as per the module and utilized Pandas as a functions library. I debugged using Jupyter Notebooks and made sure to convert the files back over to Python to ensure total compliance with the homework assignment. I included both Jupyter Notebooks and Python Files for review, along with any README documentation.

What are:
# Test for Success These are milestone tests I use to make sure the functions I am building preform as desired before incorporating into the whole of the code.

# DEBUGGING When something would break, I would go back and run alternative methods of a section until I found a solution that matched the example.

I utilized the following resources:

Web Sites Used

• Class Zoom Recordings

  • https://courses.bootcampspot.com/courses/3876/external_tools/249

• GitLab: UofM-VIRT-DATA-PT-06-2023-U-LOLC

  • https://git.bootcampcontent.com/University-of-Minnesota/UofM-VIRT-DATA-PT-06-2023-U-LOLC

• Pandas Documentation:

  • https://pandas.pydata.org/docs/reference/api/pandas.unique.html
  • https://pandas.pydata.org/docs/reference/api/pandas.DataFrame.nunique.html
  • https://pandas.pydata.org/docs/reference/api/pandas.Series.value_counts.html
  • https://pandas.pydata.org/docs/reference/api/pandas.DataFrame.groupby.html
  • https://pandas.pydata.org/docs/reference/api/pandas.cut.html
  • https://pandas.pydata.org/docs/reference/api/pandas.Series.str.replace.html
  • https://pandas.pydata.org/docs/reference/api/pandas.DataFrame.drop.html
  • https://pandas.pydata.org/docs/reference/api/pandas.DataFrame.isin.html

• General Reference:

  • https://www.geeksforgeeks.org/python-map-function/
  • https://realpython.com/python-dicts/
  • https://www.w3resource.com/pandas/series/series-value_counts.php
  • https://www.geeksforgeeks.org/write-regular-expressions/
  • https://www3.ntu.edu.sg/home/ehchua/programming/howto/Regexe.html

• Troubleshooting Errors

  • pandas-dev/pandas#46072
  • https://stackoverflow.com/questions/72223610/dropping-invalid-columns-futurewarning
  • https://stackoverflow.com/questions/41950021/typeerror-not-supported-between-instances-of-str-and-int
  • https://bobbyhadz.com/blog/python-typeerror-not-supported-between-instances-of-str-and-int
  • https://www.w3schools.com/python/pandas/ref_df_drop.asp
  • https://stackoverflow.com/questions/27065133/pandas-merge-giving-error-buffer-has-wrong-number-of-dimensions-expected-1-go