Introduction
In the previous chapter, we learned how to import and export data into other analytical tools in order to leverage analytical tools outside of our database. It is often easiest to analyze numbers; however, in the real world, data is frequently found in other formats, such as words, locations, dates, and, sometimes, complex data structures. In this chapter, we will look at these other formats and examine how we can use this data in our analysis.
First, we will look at commonly found column types: the latitude
, and longitude
columns. These data types will give us a foundational understanding of our data from both a temporal and a geospatial perspective. Next, we will look at complex data types, such as arrays and JSON, and learn how to extract data points from these complex data types. These data structures are often used for alternative data, or log-level data, such as website logs. Finally, we will look at how we can extract meaning out of text in our database and use...