In the last video, you stuffed from CSV file data into an SQLite3 file. This video will discuss how to pull data from a SQLite3 file into Haskell.
- [Instructor] Our last video discussed how to convert…a CSV file into a SQLite3 database.…This video will be about getting data…from SQLite3 into Haskell.…In this video, we're going to be taking a look at…understanding the basic types within SQLite3…and their Haskell counterparts.…We're going to be installing the necessary software…in order to get Haskell and SQLite3…to communicate with each other…and we're going to be writing…a few SELECT queries within Haskell.…
There are few different data types in SQLite3,…those types with their Haskell counterparts.…The four primary types are integer, real, text, and blob.…And text and blob are almost the same types.…I believe that one is for raw data…and the other is for string data.…But we can interpret both of those in Haskell as string.…Integer corresponds to integer,…real corresponds to decimal.…There is a fifth type in SQLite3 called numeric…which is adaptive and is treated as an integer…with integer data and a real with real data.…
And for those instances in which you have…
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.