Pylenin Weekly #20

Working with excel files in Python and a visual AWS Lambda guide for beginners.

Combining multiple Excel sheets into one in Python

Combine multiple Excel files into one using Openpyxl module in Python 3.

Openpyxl - Plotting Bar Charts in Excel

Learn to plot Bar Charts in Excel with Openpyxl module in Python 3.

Openpyxl - Plotting Bubble Charts in Excel

Learn to plot Bubble Charts in Excel with Openpyxl module in Python 3.

Openpyxl - Plotting Line Charts in Excel

Learn to plot Line Charts in Excel with Openpyxl module in Python 3.

Openpyxl - Adding hyperlinks to cells in Excel with Python

Learn to add hyperlinks to cells in Excel using Openpyxl module in Python 3.

Openpyxl tutorial: Handling Excel sheets in Python

Automate your Excel workflow by using Openpyxl module in Python 3.

Pylenin Weekly #19

Python timeit module, web scraping with Beautiful Soup and Requests library.

Web Scraping Wikipedia tables with Beautiful Soup

A complete python tutorial on performing web scraping with the Beautiful soup library.