Learn how to look at the provided data in Excel before you start writing code to read the data. Looking at the data is important for understanding the structure, but also for noticing anomalies, edge cases, or nuances that would cause issues for the code trying to parse the data. After looking at the raw data it is also worth attempting to visualize the data to look for trends, anomalies, or nuances in the "shape" of the data.
- [Instructor] Before we start writing any code,…let's just take a quick look at the data itself.…As part of your exercise files, you should have a zip file…containing text files.…Extract the zip file.…Let's take a look at one of the text files.…I'll double-click the first one.…It'll open in Notepad.…Here I can see the first line of text.…Seems to be the headings of the various columns…and then the data is repeated one line after another.…That's fairly typical.…Let's try and open this in Excel.…
So from Excel, browse to where your files are.…Once you reach the folder containing your text files,…you might not actually see them.…Excel is filtering to show only Excel files.…So select the filter, change it to All Files,…and then select the first file, one ending in 2012,…and click Open.…Excel will show you the Text Import Wizard.…And indeed, its assumption is correct.…
Our data is delimited, meaning there are characters,…in our case, tabs separating the various fields,…the various columns.…We can also see from the preview…
Skill Level Intermediate
1. Problem 1: Pond Oreille
2. Problem 2: Where Am I?
3. Problem 3: Eight Queens
4. Problem 4: Accessing Peripherals
5. Problem 5: Facial Recognition
6. Problem 6: Real-Time Information Dashboard
Next steps2m 46s
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.