The Compound Annual Growth Rate (CAGR) is a useful measure to understand the growth of an investment over time. How do I calculate CAGR in Google Sheets? π To calculate CAGR in Google Sheets, use the following formula: (Ending Value/Starting Value)Λ(1/Number of Years) – 1 Step 1: Input Your Start and End Values In column … Read more
Python provides robust tools for handling Excel files, and this article will guide you through the process of parsing Excel sheets into different formats using Python. To parse Excel sheets into text files and lists in Python, use the pandas library. Install pandas and openpyxl, then read the Excel file with pd.read_excel(). Convert the DataFrame … Read more
Problem Formulation and Solution Overview This article will show different ways to read and filter an Excel file in Python. To make it more interesting, we have the following scenario: Sven is a Senior Coder at K-Paddles. K-Paddles manufactures Kayak Paddles made of Kevlar for the White Water Rafting Community. Sven has been asked to … Read more
Problem Formulation π‘ Challenge: Given a CSV file. How to convert it to an excel file in Python? We create a folder with two files, the file csv_to_excel.py and my_file.csv. We want to convert the CSV file to an excel file so that after running the script csv_to_excel.py, we obtain the third file my_file.csv in … Read more
Microsoft Excel is a cross-platform and battle-tested spreadsheet software widely used for data analysis and visualization. It is a powerful and user-friendly tool indeed! But how can we bring it to the next level? We can combine Excel with Python to read data from Excel, save data to Excel with formats, formulas, and even charts, … Read more
Microsoft Excel is a cross-platform and battle-tested spreadsheet software widely used for data analysis and visualization. It is a powerful and user-friendly tool indeed! But how can we bring it to the next level?Β We can combine Excel with Python to read data from Excel, save data to Excel with formats, formulas, and even charts, … Read more
Annual Income How much does a VBA Developer make per year? The average annual income of a VBA Excel Developer is between $96,000 and $125,000 according to Salary.com (source): Let’s have a look at the hourly rate of VBA Developers next! Hourly Rate VBA Developers are well-paid on freelancing platforms such as Upwork or Fiverr. … Read more
Over your career as a Data Scientist, there may be instances where you will work with data to/from a DataFrame to an Excel file. This article shows you how to manipulate this data using the above functions. This article covers the commonly used parameters for each function listed above. For a complete list of all … Read more
In this tutorial, we will learn how to read copied tabular data from our clipboard using the read_clipboard() function and how to copy a data frame to our clipboard to paste it somewhere by applying the to_clipboard() function. Read Data from the Clipboard When we come across an interesting dataset, for example on the web, … Read more
Part 6 in Working with Excel focuses on styling. Impress your customers by styling the Worksheet to match their brand by: adding in their unique logo, using their color scheme, using their preferred font style, formatting the Worksheet using their preferred report style. Taking the time to do this makes you stand above the crowd. … Read more
Part 5 in the Working with Excel series focuses on formulas. Background After completing Part 4 of this series, you should be comfortable using Python and openpyxl to: add worksheets rename worksheets reorder worksheets delete Worksheets The j-greats.xlsx file should exist on your system. If you do not have this particular file, click here … Read more
Part 4 in the Working with Excel series focuses on Worksheet(s) manipulation. Background After completing Part 3 of this series, you should be comfortable using Python and openpyxl to: append row(s), modify data, insert column(s), delete row(s) and column(s) The j-greats.xlsx file should exist on your system. If you do not have this particular … Read more