In this series of blog posts, we will introduce 2 methods to perform web scrapping with Python: Method 1: Using requests and BeautifulSoup This method is applicable for web page which having static or server side rendered content. However, this method is not applicable for web page that rendered by client side Javascript. Method 2: […]
Category: Python
How to save retrieved SQL server result to excel with Python?
Prerequisites: Ensure you have Python 3 and SQL server install on your environment If you not sure how to retrieve data from SQL server with Python 3 and how to write data to excel file wtih Python 3, you are recommended to read through other blog posts below if you find difficulties to follow this […]
How to read / write and create excel easily with Python?
Prerequisites: Ensure you have Python 3 install at your environment In order to interact with excel file with python, we need to install openpyxl. Run command below in terminal / cmd to install the library. Script 1: Read excel file Create a simple excel file “sample1.xlsx” with content above and saved it in my project […]
How to access SQL server with Python?
Prerequisites: Ensure you have python 3 and above installed in your environment Ensure you have SQL server Management Studio installed in your environment In order to connect to SQL server, we’re going to install python library pyodbc. To install this library please run command below: After that, complete library installation, we’re going to write a simple […]