What is data?
Data is a collection of facts and statistics collected together for reference or analysis.
Where do they come from?
Data comes from measurement which can be found around us such as, Interviews, Observations and Technology they can also come from a source, such as from the government, companies, reports and yourself. This allows you to gather quantitive and qualitative data.
Data cleansing is the process of detecting and correcting (or removing) corrupt or inaccurate data from a record set. Corrupt data could have been due to human error or if it is not from an original source, data could have been changed. This is where normalisations are made.
During the lesson we were asked, in groups to collect data of trees, buses, signs, pubs, bikes, street lights, bins, parks and food shops from a specific road we were assigned to. Patrick, Xavier and I visited Newington Causeway to find the data. Other groups visited different roads.
Once we had collected the data, we looked at different file formats; CSV, JSON and XML.
CSV: CSV is a file format used to store data (in columns), such as a spreadsheet or database.
JSON: JSON is an open-standard format that uses human-readable text to transmit data objects which use attribute–value pairs.
XML: XML is a markup language that defines a set of rules for encoding documents in a format that is both human-readable and machine-readable.
We combined our data into a table and exported it as a CSV file which could be access by other groups :
Oliver combined the data gathered by each group and we were asked to write a JSON file which showed the data:
We also validated the data to see if there were any errors:
From here we can add more context to we were trying to show, for example adding a longitude or latitude of each point to that you are able to view it on a map.