Standardizing, cleaning and normalizing currency & money amounts in data is relatively simple if all the amounts are from the same denomination and format. Such as the following amounts that are all USD and follow American numerical conventions:
Planning the music for an event or party can be stressful. Especially if you’re the DJ & everyone attending wants their song to be played.
This is part one of a three part series about how to build a custom web app with spreadsheets.
For part one, we will go through how to make a form for guests to submit their song request and how that data can instantly…
Raise your hand if you have tried doing some analytics with company names and it led to a visualization like this one
Dirty data strikes again. The same company name can be written a bunch of different ways.
Not to mention the usual dirty data suspects:
4. Inconsistent capitalization — apple Inc
5. Random commas and dots — Apple, Inc.
Let’s go step by step and use this list as an example
Data lives in a ton of places. Your marketing software, your payment provider, random spreadsheets, your email thread with Rebecca.
But in our collective 20+ years of working with Data teams, we have noticed that the most important data usually lives in a database. Whether it is your sales data as an e-commerce provider or usage numbers as a SaaS startup.
So, it becomes imperative that managers, leaders and business people should access the database with ease. Especially if they want their team or organization to champion data-driven decision making.
Currently there are 2 ways for business people to access…
A form in HTML is a full or part of a web page that allows a user to submit data to a server. This can be something like a mailing list or a survey.
It’s really easy to set up a web form using HTML & some CSS. If you have any coding experience, HTML can be picked up quickly…
Perfect for beginners to web development or experienced devs looking to make a website without a backend!
My website is about How to Pronounce Indian names — a cause close to my heart as an Indian-American.
Below is a sample of how it looks. You can view it live here, as well.
Here is the full code for the two files that will create the website: index.html & index.css.
Don’t worry! …
Ah, there’s nothing as satisfying as finishing all your code for a website you’re making. But then comes the hard part — deploying it. Don’t worry, we got you covered with this guide.
We will go through deploying without a custom domain, with a HTTP custom domain, and a secured HTTPS domain custom.
The amount of data we need to analyze keeps increasing but MS Excel still has a 1 million record limit. Well 1,048,576 rows to be precise.
There are many ways to deal with large files using code but a simple way is to split up the files into smaller files.
Then they can be opened in Excel easily.
There are a few ways to do this
Disclaimer: we made this tool
Phone numbers are frequently used data types. So you would think they would be straightforward to work with, right? Right?
Well if you have phone numbers from multiple people and countries, it gets to be a mess.
You may find yourself having a spreadsheet with a bunch of different phone numbers and you’re stuck figuring out how to clean them.
If you want a quick way to do it, check out Clean Spreadsheets!
However, if you are trying to code or manually clean them yourself here is what you need to keep in mind.
Cleaning a phone number will allow…
Automating sending emails from a Google Sheet filled with names, emails, messages etc. is a common task for any person or business.
This tutorial is opinionated, i.e. it outlines one specific way we found best to automate sending emails. We also use our own product API Spreadsheets to get the data from your Google Sheet.
There are many ways to go about this all and you should modify the code to fit your needs.
If you do not know how to use the Terminal and Python, then go through this tutorial first: Intro to Reading and Writing Spreadsheets with Python