Skip to main content

Decimal Comma or Point? A googleVis visualization

Decimal comma or decimal point? A handy tool to indicate the decimal separator used in each country so you never make a mistake in your sheet
Jun 2014  · 3 min read

As you all know, the decimal mark is a symbol used to separate the integer part from the fractional part of a number written in decimal form. Since I was born and raised in Continental Europe, I am quite fond of using the comma sign to indicate a decimal point. I've grown up with it, encountered this comma in both my literary and numerical escapades, and still shudder when thinking of its dual role in long divisions.

However, using the comma sign as a decimal mark has two consequences:

  • Since the comma "," sign is already taken to mark the radix point, I'm obligated to use the dot "." sign to separate the thousands.
  • As the comma "," sign is only used by 24% of the world's population, 76% of the people in the world are creating documents, writing texts, typing in working in spreadsheets, etc. that contain numbers with a fractional part that looks different from mine.

While the first consequence is the inevitable sacrifice one must make for having the privilege to use the comma for fractional numbers, the second is a much harder obstacle to deal with in the real world of professional number crunchers. More than necessary, I find myself struggling with sheets and documents that use the dot "." sign to mark the radix point instead of my beloved comma. Why that often? Based on Wikipedia, roughly 60% of the world's populations uses the dot "." sign to mark the radix point. And when looking for these numbers, I learnt that there are even more dissidents. In the Arab world they use the Arabic decimal separator for Eastern Arabic numerals, in Persian the decimal mark is called momayyez, and in English Braille the decimal mark even has its own sign… So it gets difficult to know whether to user a decimal comma or decimal point.

Since politely asking these people to change their disrupting behavior will most likely be hopeless, and finger pointing is only a prerogative of the majority, I was forced to make myself a little tool to guide me through of what at the beginning looked like an insurmountable problem. Using the data I found on Wikipedia and with the help of the googleVis package, I created a world map that indicates the decimal separator that is used in each country. That way, depending on the origin of the sheet I receive, I always know whether to use a decimal comma or decimal point.

The map (full-size) is not yet complete (mainly in Africa there are some blank spots left). So for those that are aware of the prevailing decimal mark culture in these regions, just let me know in the comment section and I'll make sure to update them in case of a comma, or to proselytize them otherwise ;-). You can find the original code here.

Interactive Data Visualization with plotly in R

Beginner
4 hours
8,797
Learn how to use plotly in R to create interactive data visualizations to enhance your data storytelling.
See DetailsRight Arrow
Start Course

Visualizing Big Data with Trelliscope in R

Beginner
4 hours
4,664
Learn how to visualize big data in R using ggplot2 and trelliscopejs.

Visualization Best Practices in R

Beginner
4 hours
13,647
Learn to effectively convey your data with an overview of common charts, alternative visualization types, and perception-driven style enhancements.
See all coursesRight Arrow
Related

YOLO Object Detection Explained

Understand YOLO object detection, its benefits, how it has evolved over the last couple of years and some real-life applications.
Zoumana Keita 's photo

Zoumana Keita

5 Ways to Use Data Science in Marketing

Discover five ways you can use data science in marketing. Get ahead of the game, improve your data skills, and work on a data science marketing project.
Natassha Selvaraj's photo

Natassha Selvaraj

_Quote.png

The Deep Learning Revolution in Space Science

Justin Fletcher joins the show to talk about how the US Space Force is using deep learning with telescope data to monitor satellites, potentially lethal space debris, and identify and prevent catastrophic collisions. 

Richie Cotton's photo

Richie Cotton

53 min

Regular Expressions Cheat Sheet

Regular expressions (regex or regexp) are a pattern of characters that describe an amount of text. Regular expressions are one of the most widely used tools in natural language processing and allow you to supercharge common text data manipulation tasks. Use this cheat sheet as a handy reminder when working with regular expressions.
DataCamp Team's photo

DataCamp Team