Python Working with the Pandas DataFrame & MySQL – Part 2

Background Part 2 of this series centers around running more complex MySQL queries. This skill is a must-have if you are interested in pursuing a career as a Data Scientist. After completing Part 1 of this series, you should be comfortable: Installing Libraries Downloading and saving a CSV file from the web. Creating a Pandas … Read more

Python requests.get() – The Ultimate Guide

Syntax requests.get(url, args) You can replace args with one or more of the following arguments, comma-separated: Parameter Description url Required The URL of the request params Optional Send data using a URL query string. Dictionary, list of tuples, or bytes. allow_redirects Optional By default, True: allowing redirects. If False, the code prevents redirection to another … Read more

Python Requests Library – Exception Handling & Advanced request.get() Parameters

This is the first part of a 3-part series on the Python request library: Python Requests Library – Your First HTTP Request in Python Python Requests Library – Understanding requests.get() Parameters Python Requests Library – Exception Handling & Advanced request.get() Parameters Syntax Background & Preparation The Requests library has several methods for GET. Part 1 … Read more

Python Requests Library – Understanding requests.get()

This is the first part of a 3-part series on the Python request library: Python Requests Library – Your First HTTP Request in Python Python Requests Library – Understanding requests.get() Parameters Python Requests Library – Exception Handling & Advanced request.get() Parameters Syntax requests.nameofmethod(parameters) Background and Preparation The Requests library has several options for GET. Part … Read more

Python Requests Library – Your First HTTP Request in Python

This is the first part of a 3-part series on the Python request library: Python Requests Library – Your First HTTP Request in Python Python Requests Library – Understanding requests.get() Parameters Python Requests Library – Exception Handling & Advanced request.get() Parameters Syntax Background There are many libraries around that make HTTP requests. However, the requests … Read more

BeatifulSoup Find *

Preparation This article assumes you have the following libraries installed: Requests Beautifulsoup and a basic understanding of: HTML CSS Python Add the following code to the top of each code snippet. This snippet will allow the code in this article to run error-free. Beautifulsoup Find by ID If the HTML code contains one or more … Read more

How to Install MySQL on PyCharm?

MySQLdb is an interface to an existing MySQL database server for Python. Problem Formulation: Given a PyCharm project. How to install MySQL in your project within a virtual environment or globally? Here’s a solution that always works: Open File > Settings > Project from the PyCharm menu. Select your current project. Click the Python Interpreter … Read more