Tag Archives: python

Conversion of list of dictionary and dataframe in Python

In Python there is a dataframe package: pandas. The dataframe package simplifies a lot of things and it is comparable to a dataframe in R. Sometime you need convert a list of dictionary to a dataframe and vice versa. To … Continue reading

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

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