Guided Course: Scraping and Data Visualization with Tableau
Cleaning and data processing
A guided course by Victor Pascual , Data Visualization Specialist
About the video: Cleaning and data processing
Overview
“Unfortunately, the data we encounter is often not perfect. It will contain errors, non-normalized values, and a myriad of case studies that we will have to learn to manage in order to prepare it for work. We call this process "cleaning and processing." In this lesson, we'll see how to use Google Spreadsheets functions to extract relevant data from one of our columns, and we'll see how to start preparing a simple template that will make our life easier when generating the dataset for our project.”
In this video lesson Victor Pascual addresses the topic: Cleaning and data processing, which is part of the Domestika online course: Guided Course: Scraping and Data Visualization with Tableau. Learn to extract, clean and visualize television series data using Scraping and Tableau public techniques.
Partial transcription of the video
“Okay. after collecting all the data we plan to use. as shown in the tabs and within the folder I set up on Google Drive. we can proceed. This organization ensures that everything is accessible and ready for our next I have data from five series: Mad Men. sex and the City. the Sopranos. and True Blood. Our next step is to standardize this data. which means aligning them all to a common format for easier analysis and comparison. into one spreadsheet. To begin. and in case anyone is unsure. i've moved them. Essentially. when you use the Chrome plugin to scrape data. it helps consolidate everyt...”
This transcript is automatically generated, so it may contain mistakes.
Course summary for: Guided Course: Scraping and Data Visualization with Tableau
-
Category
Design, Marketing & Business -
Software
Google Sheets, Tableau Public -
Areas
Infographics, Information Design, Interactive Design, Multimedia
Victor Pascual
A guided 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.
- 24 students
- 7 lessons (1h 27m)
- 7 additional resources (1 files)
- Online and at your own pace
- Available on the app
- Audio: Spanish, German, English, French, Italian, Dutch, Polish, Portuguese, Turkish
- Spanish · French · English · German · Italian · Portuguese · Polish · Turkish · Dutch
- Level: Beginner
- Unlimited access forever
Recommended software & tools for this course
Google Sheets
Tableau PublicCategory
Areas
