I just completed all the assignments for the "Using Databases with Python" online course offered by the University of Michigan and Coursera (at https://www.coursera.org/learn/python-databases/home/welcome). You can view my work at : https://github.com/jk34/DatabasesPython_SQL_Coursera
In the "HW1" folder is the work for the first assignment. I created a SQLite database and then created a new table and inserted some values into it. I then modified the given "email.py" Python script to read in the "mbox.txt" file containing email records to then count the number email messages per domain name of an email address In the "hw2" folder, I modified the given Python script "tracks.py" to read in an iTunes export file in XML ("Library.xml") and then utilize sqlite3 within Python and executescript to generate a database "trackdb.sqlite" to store the artist, genre, track, and album of songs from that iTunes file. In the "hw3" folder, I used the "roster.py" given file to read in a JSON file (roster_data.json) that contains the names of students, the courses they enrolled in, and a "role" value of 0 or 1. It read the values from the JSON file and stored it in the database "rosterdb.sqlite". I modified the "roster.py" file so that it could store the "role" value from the JSON file into the "role" column of the "Member" table Finally, my work in the "peer" folder is to complete the assignment where I use the "where.data", which stores the names of places (such as Northeastern University, University of London, etc) and then load it into"geoload.py" to use google to look up the addresses of those places and obtain data about them, and then store those in the database "geodata.sqlite". Then " geodump.py" reads that database and produces "where.js" which allows the user to open "where.html" to see a visualization of those places in a google map. I added the place "Westminster Mall" to "where.data" and then ran geoload.py and geodump.py and then opened where.html to see the Westminster Mall's location on the map. You can see this in "where.png"
2 Comments
|
AuthorHello world, my name is Jerry Kim. I have a Master's Degree in Physics and years of work experience in Image Processing, Machine Learning, and Deep Learning. I mostly have used C++, Matlab, and Python. I created this website to showcase a small sample of the things that I have worked on Archives
March 2017
Categories |