Background
Mobile Engineering Guides

ByProgrammers Blog

Comprehensive React Native tutorials, UI animations, navigation architectures, and best practices.

All Articles (23) React Native Python Web Django iOS Excel SQL Server
Python
1 min read

Introduction of web scrapping with Python

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: […]

Jan 13, 2019 Read Tutorial
Excel
3 min read

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 […]

Dec 30, 2018 Read Tutorial
Excel
2 min read

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 […]

Dec 26, 2018 Read Tutorial
Python
2 min read

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 […]

Dec 25, 2018 Read Tutorial