Pinned

1. SQL_Murder_Mystery_Solution SQL_Murder_Mystery_Solution Public

   Prompt: A crime has taken place and the detective needs your help. Use SQL to research clues from the police database and find out whodunit! SQL Murder Mystery was created by Joon Park and Cathy He…

2. Multi_Table_Database_SQL_Music_Tracks Multi_Table_Database_SQL_Music_Tracks Public

   Assignment: Parse an iTunes export file in XML with a list of albums, artists, genres, and tracks and produce a properly normalized SQLite database using a Python program. Use this code as a starti…

3. Counting_Emails_in_a_Database_SQL Counting_Emails_in_a_Database_SQL Public

   Assignment: This application will read the mailbox data (http://www.py4e.com/code3/mbox.txt) and count the number of email messages per organization (i.e. domain name of the email address) using a …

4. Scraping_HTML_Data_with_BeautifulSoup Scraping_HTML_Data_with_BeautifulSoup Public

   Assignment: Use urllib to read the HTML from the data files, and parse the data, extracting numbers and compute the sum of the numbers in the file.The file is a table of names and comment counts. Y…

5. Calculate-Hotel-Occupancy-from-Text-File Calculate-Hotel-Occupancy-from-Text-File Public

   This Python code reads and pulls data from a text file, calculates ‘Available [Hotel] Rooms’, ‘Gross Occupancy’, and ‘Net Occupancy’ and exports the original and newly calculated data as a formatte…

6. Extracting_Data_With_Regular_Expressions Extracting_Data_With_Regular_Expressions Public

   Assignment: Read through and parse a file with text and numbers. Extract all the numbers in the file, look for integers using the re.findall(), looking for a regular expression of '[0-9]+' and then…

   1