Print this chapterPrint this chapter

Data Analysis Techniques

Combining and importing data

Introduction Data Analysis: Visualization and Dashboard Design



Copy paste


Load from File

Felienne explains how instead of copy-pasting the contents of Excel files into one, we can import data from CSV files. If you participated in the previous MOOC EX101x you probably remember we imported data from the web. You can click here to revisit that lecture on EDX or on YouTube. In this video, we import data from a CSV file instead. WARNING! The features shown in the lectures do not exist in every version of Excel.


Combine CSV

What do you do when you need to import more than one CSV file? Felienne shows you in this video.


Combine script

When you start from multiple Excel files, how do you efficiently concatenate them into a single CSV file?


Data Types

In this video Felienne shows how to deal with the inconsistencies that can be introduced into your spreadsheet by importing data from multiple sources.

Source: Adrienne Watt, https://ocw.tudelft.nl/courses/data-analysis-visualization-dashboard-design/subjects/module-1-combining-importing-data/
Creative Commons License This work is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 4.0 License.