Want to create an interactive transcript for this episode?
Podcast: New Books in Economics
Episode: Renee M. P. Teate, "SQL for Data Scientists: A Beginner's Guide for Building Datasets for Analysis" (John Wiley & Sons, 2021)
Description: Economists and other social scientists are used to working with data that comes nicely organized into a table with a series of variable names across the top and a list of observations or datapoints down the right hand side. Data also naturally falls into this format when it comes from surveys we run. But the vast amounts of data generated by businesses and by all our online activities are usually organized in different ways. In corporate settings that first step of getting the right data and putting it into a table where it can be analyzed can be as...