What could be interesting about the lowly quadratic formula? It’s a formula after all. You just stick numbers into it. Well, there’s an interesting wrinkle. When the linear coefficient b is large relative to the other coefficients, the quadratic formula can give wrong results when implemented in floating point arithmetic. Quadratic formula and loss of precision The […]
By Lance Eliot, the AI Trends Insider How fast can you think? If I give you a jigsaw puzzle and ask you to assemble it, you would likely take some amount of time to look at the puzzle pieces and mull over in your mind which piece might go where. You might create a kind […]
Big Data and analytical skills are becoming an important part of the IT industry worldwide. Hence, there is…
Weird — I actually kind of look like that guyThis story is a step-by-step guide to how I built a language detection model using machine learning (that ended up being 97% accurate) in under 20 minutes.Language detection is a great use case for machine l…
R is considered as the de facto programming language for statistical analysis right? But In this post, I…
By Lance Eliot, the AI Trends Insider What do these aspects have in common: Roswell, Area 51, JFK assassination, moon landing, AI self-driving cars? They are all considered by some to be conspiracies. Most of us are familiar with Roswell, New Mexico and the claims of a UFO that landed there. Likewise, most of us […]
Diabetes Prediction — Artificial Neural Network ExperimentationBeing a data science profesional, we tend to learn about all the available techniques to crunch our data and deduce meaningful insights from them. In this article, I have described my exper…
Manually labelling data is nobodies favourite machine learning chore. You needn’t worry though about asking others to help out provided you can give them a pleasant tool for the task. Let me present to you: generated Google Forms using Google App Script!
The regular way people might label data is just by typing in the labels into a spreadsheet. I would normally do this as well, however in a recent task I needed to label paragraphs of text. Have you ever tried to read paragraphs of text in a spreadsheet?.. it’s hell! Luckily whilst trying to figure out a way to make the labelling process less gruelling I came across a way of auto generating a form based on data in a spreadsheet document using Google App Script.
Creating the script that will generate our Form
To get started we just jump into the App Script editor from within the Google Spread Sheet containing the data we want to gather labels for:
What’s great about using Forms for labelling is that you can guarantee consistency in the user input by specifying the data input type. For example:
item.createChoice('Is a cat')
Multi class label
See the details for more input types in the App Script API docs (or just look at the different input types when manually creating a Google Form).
You can grab the script I have used to generate a Form for labelling text documents with numbers 0 to 10 from my Github:
After you have your script written (or copy and pasted); you then select your scripts’ entry point and run it! Warning You’re probably going to have to jump through a few authorisation hoops the first time you do it.
Using the generated Form
After the script has run, you can head over to your Google Forms and there you should find a brand new Form! You can send the Form to whoever you want to do the labelling:
Accessing the data labels
After the labelling is done, you can then just view the labels as a spreadsheet and export as a CSV:
Hopefully this saves you a bit of headache in your future machine learning efforts!
The full script and dataset used in this article can be found on my Github:
Friendlier data labelling using generated Google Forms was originally published in Towards Data Science on Medium, where people are continuing the conversation by highlighting and responding to this story.