Pylenin Weekly #20

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

Pylenin Weekly #20

Welcome to Pylenin Weekly #20, a newsletter dedicated to improving the lives of my fellow peers through knowledge sharing in the field of programming and data.

This week, we have a whole lot of articles dedicated to working with Excel files using Python.

Let's check out the articles.


Python articles

Handling Excel files in Python

Microsoft Excel is probably one of the highly used data storage applications. A huge proportion of small to medium size businesses fulfill their analytics requirement using Excel.

However, if you have a little knowledge of Python, you could build highly professional Business Intelligence using Excel data, without the need of a database. Using Python with Excel could be a game changer for your business.

Check out this article to perform basic data analysis with Excel files in Python.

Openpyxl tutorial: Handling Excel sheets in Python
Automate your Excel workflow by using Openpyxl module in Python 3.

Adding hyperlinks to Excel files can be beneficial when you would like to refer to an external website.

It is super easy to add hyperlinks to your excel file without even opening it using Python.

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

Combining multiple Excel sheets into one in Python

Let’s say you have a directory with multiple Excel files containing sales data of every month. You would like to store all those separate Excel files as separate sheets in one Excel sheet named “yearly_sales.csv”.

Check out this article to figure out how to do it!

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

Plotting Line Charts in Excel

A line chart is a type of chart used to show information that changes over time. Line charts are created by plotting a series of several points.

Learn to plot Line 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.

Plotting Bubble Charts in Excel

A Bubble chart is similar a Scatter chart except, the data points are replaced with bubbles and an additional dimension of the data is represented in the size of the bubbles.

Check out this article to plot bubble charts in Excel using Python.

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

Plotting Bar Charts in Excel

A bar chart or bar graph is a chart or graph that presents categorical data with rectangular bars with heights or lengths proportional to the values.

Check out this article to plot a bar chart in Excel using Python.

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


100 days of data

A visual guide to AWS Lambda for beginners

In this blog, you will learn to create and fire your first Lambda function. Conceptually, you will also learn about the basic configurations, the importance of event and context in a lambda function, and experience the AWS Lambda dashboard to not feel intimidated by it. All you need to have is an account on Amazon Web Services.

A visual guide to AWS Lambda for beginners
Trigger your first AWS Lambda function with Python in just 10 mins.

We are on Discord!

Both Pylenin and 100 days of data

Join us

Something important!!

I am realizing that my newsletter is ending up in your promotion tab. Now, if you want to keep it that way, feel free to! However, if you think my newsletters are worthy of reaching your inbox, do follow the instructions below!

  1. Add noreply@pylenin.com to your safe senders list.
  2. Drag the Pylenin Weekly issue from the Promotions tab to Primary tab.

You will never miss any updates!


You can support me by becoming a paid member of my website! The subscription is very cheap and will prove to be a real value for your money.

If not, just follow me on Twitter! Its free!

Thank you everyone! See you again next week.

Subscribe to Pylenin

Don’t miss out on the latest issues. Sign up now to get access to the library of members-only issues.
jamie@example.com
Subscribe