Otto_von_Louis的博客

原创 Coursera-Python for Everybody Specialization-Capstone, Ass. 16-4, Finale

Assignment 16-4: Visualizing Email DataIn this assignment, you can directly manipulate the existing database 'content.sqlite' from Ass. 16-3. Whereas, for a better display effect, I strongly suggest youdownload a lot more messages (e.g. 3000) by running.

原创 Coursera-Python for Everybody Specialization-Capstone, Ass. 16-3

Assignment 16-3: Spidering and Modeling Email Data - IntroductionThis assignment, as well as the previous one, does not need you to write new code, but just run the given 3 .py files.1. Run 'gmane.py' to generate or update 'content.sqlite'.N.B. For .

原创 Coursera-Python for Everybody Specialization-Capstone, Ass. 16-2

Assignment 16-2: Building a Search Engine - IntroductionThis assignment does not require you to write new code, but to successively run the given 4 .py files.1. Run 'spider.py' to generate the database 'spider.sqlite'.Note: selectat least 100 pages..

原创 Coursera-Python for Everybody Specialization-Capstone, Quiz: Python for Everybody - A Review

原创 Coursera-Python for Everybody Specialization-Using Databases with Python, Ass. 16-1

There is no quiz for Week 5 of the 4th course of this specialization.Assignment 16-1: Databases and VisualizationIn addition, you do not need to write Python code yourself to finish this assignment.Just follow the instructions step and step, then yo.

原创 Coursera-Python for Everybody Specialization-Using Databases with Python, Quiz 15-3 and Ass. 15-3

Quiz 15-3: Many-to-Many Relationships and PythonQ.9. has another alternative question that is not easy to answer. There is no ready answer online, and you cannot expect to solve it by trial-and-error because it is a multi-selection question.Assignm

原创 Coursera-Python for Everybody Specialization-Using Databases with Python, Quiz 15-2 and Ass. 15-2

Quiz 15-2: Multi-Table Relational SQLAssignment 15-2: Multi-Table Database - TracksThe majority of the code is as same asthe sample 'track.py', what we need to do is to add the 'Genre' into the database.We can check the result via both P...

原创 Coursera-Python for Everybody Specialization-Using Databases with Python, Quiz 15-1 and Ass. 15-1

Quiz 15-1: Single-Table SQLAssignment 15-1: Our first DatabaseThis assignment does not require you to write any Python code or your own SQL instructions. After installing the SQLite Brower,sequentially type in the given SQL instructions, you can.

原创 Coursera-Python for Everybody Specialization-Using Databases with Python, Quiz 14

原创 Coursera-Python for Everybody Specialization-Using Databases with Python, Quiz warm-up

Quiz warm-up: Using Encoded Data in Python 3Q.2 has another alternative question.

原创 Coursera-Python for Everybody Specialization-Using Python to Access Web, Quiz 13-2 and Ass. 13-2

Quiz 13.2: REST, JSON, and APIsQ.1, Q.2, Q.3, Q.4, and Q.6 have other alternative questions.Assignment 12-2: Extracting Data from JSONRunning thecode above and typing in the correct URL, you can get the result below.

原创 Coursera-Python for Everybody Specialization-Using Python to Access Web, Quiz 13-1 and Ass. 13-1

Quiz 13-1: eXtensible Markup LanguageQ.1, Q.2, Q.3, Q.8, and Q.9 have other alternative questions respectively.I have no complete copies right now, and will try to update them later.Q.3, "complex elements" are "person"and "people".As...

原创 Coursera-Python for Everybody Specialization-Using Python to Access Web, Quiz 12-2 and Ass. 12-2

Quiz 12-2: Reading Web Data from PythonQ.10 has another alternative question.Assignment 12-2: Scraping HTML Data with BeautifulSoupAfter running the code above, you can get the result below.Assignment 12-2: Following Links in HTML...

原创 Coursera-Python for Everybody Specialization-Using Python to Access Web, Quiz 12-1 and Ass. 12-1

Quiz 12-1: Networks and SocketsAssignment 12-1: Understanding the Request/Response CycleAfter running the code above, you should get the result below.

原创 Coursera-Python for Everybody Specialization-Using Python to Access Web, Quiz 11 and Ass. 11

Quiz 11: Regular ExpressionsQ.1 and Q.2 have other alternative questions.N.B. The correct solution for Q.2 is the 4th option rather than the 5th marked in the screenshot.Ass. 11 is not difficult, the code is given below.

原创 Coursera-Python for Everybody Specialization-Python Data Structure, Quiz 10 and Ass. 10

原创 Coursera-Python for Everybody Specialization-Python Data Structure, Quiz 9 and Ass. 9

原创 Coursera-Python for Everybody Specialization-Python Data Structure, Quiz 8 and Ass. 8

原创 Coursera-Python for Everybody Specialization-Python Data Structure, Quiz 7 and Ass. 7

原创 Coursera-Python for Everybody Specialization-Python Data Structure, Quiz 6 and Ass. 6

原创 Coursera-Python for Everybody Specialization-Programming for Everybody, Quiz 5 and Ass. 5

原创 Coursera-Python for Everybody Specialization-Programming for Everybody, Quiz 4 and Ass. 4

原创 Coursera-Python for Everybody Specialization-Programming for Everybody, Quiz 3 and Ass. 3

Ass. 3 contains 2 parts, 3.1 and 3.3.

原创 Coursera-Python for Everybody Specialization-Programming for Everybody, Quiz 2 and Ass. 2

Note: Q1 has another alternative question; Q3 and Q4 have other candidate options.Ass. 2 contains 2 parts, 2.2 and 2.3.

原创 Coursera-Python for Everybody Specialization-Programming for Everybody, Quiz 1 and Ass. 1

This is the first quiz in this course thatconcerns some basic concepts of Python. Thus, I only provide the solutions without any explanation.The first assignment is just a trial on the online editor.