-
Book Overview & Buying
-
Table Of Contents
Data Wrangling with SQL
By :
Data capture is the process of collecting information from online or electronically in structured or unstructured formats and storing it in a readable format in a table or a document as raw data. For example, weather data from a website (such as https://www.timeanddate.com/weather/usa/boston/historic) or the top 10 Fortune 500 companies (https://fortune.com/fortune500/) can be extracted from these websites and then can be stored in an Excel or CSV file.
Every day in our day-to-day life we either capture data ourselves or see data being created by us. For example, in bank transactions, we don’t create that data, but data is captured and stored electronically in different database tables, which we review as our daily transaction activity or in statements. Swiping a credit card does not just pay a bill; it is also a process of creating a trail of data.
There are several data-capturing techniques that...