World wide Milk Production 1970 - 2018
The bar race chart shows milk production of top 15 countries over a period of 1970 to 2018. Please press the play button at the bottom right to play the animation.
The interactive map was made using Leaflet which is the leading open-source JavaScript library for mobile-friendly interactive maps.
The code is available on my GitHub account. The map is available on my GitHub Page.Further to my earlier post, here is the last post on the topic.
The best layout for your data within a spreadsheet is as a single big rectangle with rows corresponding to subjects and columns corresponding to variables.
The first row should contain variable names, and please do not use more than one rows for the variable names.
It is helpful to have a separate file that explains what all of the variables are. It is helpful if this is laid out in rectangular form, so that the data analyst can make use of it in analyses.
Such a “data dictionary” might contain:
Your primary data file should contain just the data and nothing else: no calculations, no graphs.
As the logic will not be clear to the person analyzing the data. Instead add a column to comment on the value.
Make regular back ups in different locations.
It might seem cumbersome but it will help you avoid data entry mistakes.
It would be worth it.
Keep the copy of your data files in a plain text format, with comma or tab delimiters.
- courtesy
Data Organization in Spreadsheets