You've converted a CSV file into SQLite3 and pulled that data from SQlite3 into Haskell, now you're going to demonstrate how use WHERE and ORDER clauses in SQL.
- [Instructor] This video will be an overview…of the versatility of the SELECT query in SQLite3.…Most of the content of this video will pertain…to the inner workings of the SELECT query…and not the Haskell language itself.…So in this video we're going to have an understanding…of the following SELECT clauses…WHERE, ORDER BY, and LIMIT.…Each of these have their own utility,…but when these clauses work together you can quickly see…how data can be sliced into workable chunks…that can be studied later.…This is my preferred way of working with data,…let SQL do the slicing and Haskell do the dicing.…
Once we have a data slice that we're happy with…we'll spend some time at the end…looking at how to parse that chunk of data…into something usable by Haskell.…I am back in my virtual machine…running the Jupyter Notebook.…I am going to drop over to my…primary earthquake notebook.…We're going to begin with a simple question.…If our data set of worldwide earthquakes is truly worldwide…shouldn't there be a nearly equal number of…
Note: This course was created by Packt Publishing. We are pleased to host this training in our library.
- Data ranges, means, and medians
- Standard deviation
- SQLite3 command line
- Slices of data
- Regular expressions
- Atoms and modifiers
- Character classes
- Line plots of a single variable
- Plotting a moving average
- Feature scaling
- Scatter plots
- Normal distribution
- Kernel density estimation (KDE)
Skill Level Intermediate
NumPy Data Science Essential Trainingwith Charles Kelly3h 54m Intermediate
SQL: Data Reporting and Analysiswith Emma Saunders2h 16m Intermediate
1. Descriptive Statistics
3. Regular Expressions
5. Kernel Density Estimation
6. Course Review
- 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.