Introduction to Data Visualization
Cleaning and data processing
A course by Victor Pascual , Data Visualization Specialist
About the video: Cleaning and data processing
Overview
“Unfortunately, the normal thing is that the data we find is not perfect. They will contain errors, non-normalized values, and an infinite number of cases that we will have to learn to manage in order to prepare them for work. We will call this process "cleaning and processing". In this lesson we will see how to use functions of Google Spreadsheets to extract relevant data from one of our columns, and we will see how to start preparing a simple template that will make life easier for us to generate the dataset of our project.”
In this video lesson Victor Pascual addresses the topic: Cleaning and data processing, which is part of the Domestika online course: Introduction to Data Visualization. Create interactive visualizations and learn to represent data from your favorite series.
Partial transcription of the video
“Once we've collected the data we'll use. as shown in the tabs and within the folder I set up in Google we can proceed. This setup ensures everything is organized and accessible for our project. streamlining I've gathered data from five series: Mad Men. sex and the City. the Sopranos. and True Blood. Our next step is to homogenize this data. meaning we'll standardize it to ensure consistency across all series. into a single spreadsheet. To begin. and to clarify any uncertainties. i moved data by using the Chrome plugin for scraping. This method ensures that all information is collected effic...”
This transcript is automatically generated, so it may contain mistakes.
Course summary for: Introduction to Data Visualization
-
Category
Design, Marketing & Business -
Software
Google Sheets, Tableau Public -
Areas
Infographics, Information Design, Interactive Design, Multimedia
Victor Pascual
A course by Victor Pascual
Víctor Pascual is a self-confessed lover of scientific data visualization, who has a doctorate in computer science and digital communication. He dedicated his doctoral thesis to researching new methods for representing web data and has been a data scientist and data visualization specialist since 2009.
After three years as part of the Bestiario team, Víctor began his new adventure as a data analysis and visualization consultant for companies including SIRIS Academic and Mobile Media Content, where he leads a diverse range of R&D projects.
Víctor is also committed to training in information visualization, which led him to codirect Spain's first postgraduate course on the subject (IDEC) as well as participate in a number of different conferences and workshops. He currently collaborates with different master's and postgraduate degree programs.
- 95% positive reviews (592)
- 15,578 students
- 12 lessons (2h 46m)
- 9 additional resources (2 files)
- Online and at your own pace
- Available on the app
- Audio: Spanish, English, French, Italian, Portuguese, Turkish
- Spanish · English · Portuguese · German · French · Italian · Polish · Dutch · Turkish
- Level: Beginner
- Unlimited access forever
Recommended software & tools for this course
Google Sheets
Tableau PublicCategory
Areas
