Ever wondered which celebrity looks similar to you? If you are thinking “YES I DO” then this is the article for you.
Thanks to machine learning you can scan your face features and compare it with a database of 2.6 million faces of over 3.000 celebrities.
After reading this guide, you will know the following:
If you want to know more about:
In this article you will learn how to convert a batch of corrupt XLS files to an XLSX file.
In this article, you will learn how to automate the conversion process from (corrupt) xls files to normal xlsx files.
Data can be found: here
Automate the extraction of attachments in e-mails using python
The client sends you 60 e-mails that include an excel attachment which needs to be verified.
Normally, you spend 40 minutes opening each e-mail, opening the attachment and then saving it somewhere.
Using this script, you will be able to automate this process.
First, you specify the respective locations of the files:
Also, you change the working directory to be the source location.
A guide on how to convert currencies in your files automatically using Python
You can find the full script down below.
Dataset used: link
Install and import the forex_python package.
We import pandas as well for our dataframe operations.
!pip install forex_pythonfrom forex_python.converter import CurrencyRates
import pandas as pd
The dataset consists of multiple transactions in their local currency at different dates. …
You can find the script down below.
You receive the population file from the client of which you need to make a sample.
Before you can create your sample, you need to do the following steps:
Load in the population that you have received from the client. You can download the dataset here.
Software as a service (SaaS) companies are trending on Wall Street. Sixteen SaaS companies IPO’ed on Wall Street in 2020 amidst a global pandemic.
However, you shouldn’t measure SaaS companies performance using on the traditional standard metrics alone. These companies have a specific business model based on subscription revenue, which requires different metrics.
In this cheat sheet, you can discover the most popular SaaS metrics and their formulas.
In the article below, you can read more over the rationale behind each metric.
Enterprise value divided by the next twelve months revenue
SAAS companies operate…
Why and how you should use the Pandas Transform function in your code
After reading this article, you will know:
The Pandas transform is a relatively unknown function in the pandas packages.
You use it in conjunction with the groupby function to aggregate data but at the same time you keep your orignal shape.
If you use groupby with apply to summarize data, you notice that your data gets reduced on the level of the groupby variable.
However, if you want to…
Strategy & Data Science | Passionate about the application of analytics in a strategy context