Pylenin Weekly #20
Working with excel files in Python and a visual AWS Lambda guide for beginners.
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.
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.
Adding hyperlinks to cells in Excel with Python
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.
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!
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.
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.
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.
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.
We are on Discord!
Both Pylenin and 100 days of dataJoin us
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!
firstname.lastname@example.org your safe senders list.
- 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.