Modern-day research requires merging data sets from multiple sources while maintaining consistency and integrity. This workshop will discuss the fundamentals of using a lightweight database like SQLite to achieve those goals, which opens up the powerful world of SQL. We will also explore examples in which various analysis tools like R, Stata, and Python, can access, interrogate, and combine this information with little effort.
Pre-class preparation: Please follow the installation instructions at http://bit.ly/hdf_merge_install.
Full lesson materials, files, etc will be posted at http://bit.ly/hdf_merge_lesson.