Tag Archives: python

Use MySQL database in Python

PyMySQL its a pure python client library, you can install using pip install PyMySQL (find documentation at https://pymysql.readthedocs.io/en/latest/). The following is a simple example to demonstrate how to use the library. #!/usr/bin/env python from __future__ import print_function import pymysql conn … Continue reading

Share
Posted in MySQL, Python | Tagged , , | Leave a comment

Use python to create PowerPoint slides automatically

I have a large number of images. I want to organize them in powerpoint files by automatically insert each picture to a new powerpoint slide and control it’s position and size. I came across a nice Python library – python-pptx … Continue reading

Share
Posted in Python | Tagged , , , , | Leave a comment

Python development environment

I productive python development environment is important when you want to use Python to develop applications. Download the right version of Python from https://www.python.org/ and install it. For example, I downloaded macOS version Python 3.6 and installed it to the machine. … Continue reading

Share
Posted in Python | Tagged , , , , | Leave a comment

Let Python work with Apache2

Python is very good language with efficient execution and clean code. It will be nice to write server side scripts in Python. A simply search of the internet, ended the following use information. The original information was from the following … Continue reading

Share
Posted in Python, Tips | Tagged , , , | Leave a comment

Read text file in the zip file directly

Here is an example to read text file in the zip file directly. In order to use the library, you have to import zipfile library. import zipfile def readtextfile(thezipfile, filename): ”’ read a text file from the compressed file and … Continue reading

Share
Posted in Python | Tagged , , , , | Leave a comment