Jingwen Zheng - page 11

Python: Apply regular expression with regex

Regular expressions provide a flexible way to search or match string patterns in text. A single expression, commonly called a regex, is a string formed according to the regular expression language.Python’s built-in re module is responsible for applying regular expressions to strings. In this blog, I’ll first introduce regular expression syntax,...

Read more

How to manipulate excel workbook by Python?

This blog introduces how to use openpyxl package to manipulate Excel workbook and worksheet, like create a workbook and worksheet, write values in cells, set font(size, type, bold, italic), cut and paste values from one cell to another, remove one row, merge cells, set number format, set cells' background colors and center text in one cell, wrap...

Read more