Data lego

 My son is building Lego.

At first he opened the box with excitement and pulled out all of the numbered bags. He opened the booklet and started to follow the instructions. Then he opened more bags to find the pieces. Eventually, he opened all of the bags and emptied them into great Big muddle on the floor.


Enter mum. 

I gave him 20 Tupperware tubs. Between us we sorted by colour. Another option would be to sort by type. For some colours there was so much Lego we sorted by both type and colour.


In other words, we had ourselves a data problem. 

Here is your data in the beginning

Big pile of mixed up bricks. At this date, you would not be able to tell what the Lego model is going to be.

Here is your data after some data cleansing and sorting

Bricks separated by colour In separate pots. He still cannot tell what it is going to be, but you have an idea of the size of the problem.

This is visualised data

Data by type and colour. You starting to see a pet merge you can visualise different possibilities for the end product. 

 Information 

Finished data model. 





Comments

Post a Comment

Popular posts from this blog

Nerdy nitrogen

 The term "nerdy nitrogen" captures the multifaceted nature of nitrogen in science, highlighting both its essential roles in biological systems and the complexities of its chemistry and environmental effects "Nerdy nitrogen" is an informal and humorous term that often refers to the complexities and intricacies of nitrogen compounds and their roles in various scientific fields, particularly in environmental science and chemistry. Here are some key points about nitrogen and its "nerdy" aspects: Working with a client on their nitrogen problem I realised that nitrogen plays a major role in my life. Not withstanding that it’s 80% of the atmosphere, I realise I just can’t get away from the stuff. As a Chief carbon reduction Engineer one of my Missions Was to raise awareness and understanding of the science behind global warming. Regularly, I talked about atmospheric composition, About the roles of carbon dioxide and nitrogen in the atmosphere. How carbon dioxide...
Read more

Ammonia

Image
  Imagine a bustling society of tiny, determined beings—the autotrophic bacteria—living in a vibrant, unseen world. These microscopic citizens thrive in environments rich with ammonia, a substance that many consider waste, yet for them, it’s a treasure trove of energy. In this miniature realm, the autotrophic bacteria are akin to resourceful warriors, battling against the harsh conditions of their surroundings. They form intricate communities, each member armed with unique abilities to harness energy from ammonia. As they  oxidise this nitrogen-rich compound, they engage in a relentless struggle for survival, converting ammonia into energy through a sophisticated process akin to a bustling factory. Picture them as skilled artisans, meticulously crafting energy from the raw materials at their disposal. They employ intricate biochemical pathways, transforming ammonia into essential nutrients that sustain their lives. This transformation is not without its challenges; they must n...
Read more

RSPB copy

  Senior Campaign Copywriting Writing Copy  Team Lead role Campaigning Communications Campaigning to drive inbound Leads Campaigning to raise environmental awareness Campaigning to raise the profile of our organisations ambitions Power Language Duolingo Drive change Mobilise people to take action Email Action Nature Campaigning to persuade funding  campaigning for support Responsible Ensuring organisations tone of voice health style and brand Advocate Champion Distal complex issues into engaging copy across a range of platforms Business leaders, team members, Financiers, Currency stakeholders and potential stakeholders,  Flexibility react to emerging situations Longtime strategic view Print web social media email digital media film storyboard Quality multi channel  Shared responsibility Understanding your knowledge Achieve buy in from colleagues Attention to detail Editing written material Editing material written by team member with a report to me Editing mater...
Read more