filmov
tv
Tips and Tricks: Small data with Python and SQLite
Показать описание
In this video, Pluralsight author Jeremy Morgan shows you how to use Python and SQLite to manipulate small (less than 1TB) data sets. This can be a useful way for developers to move and manipulate data quickly. You'll learn how to export from a CSV into SQLite, then perform manipulations and export it back out.
0:00 Introduction
6:40 Accessing SQLite from the command prompt
12:02 Creating Python file to import CSV
13:15 Creating a table in SQLite with Python
14:21 Reading CSV file with Python
19:34 Validating data with Python
0:00 Introduction
6:40 Accessing SQLite from the command prompt
12:02 Creating Python file to import CSV
13:15 Creating a table in SQLite with Python
14:21 Reading CSV file with Python
19:34 Validating data with Python
0:24:05
0:00:33
0:00:49
0:00:14
0:00:19
0:00:14
0:00:37
0:00:38
0:57:48
0:02:12
0:00:12
0:00:11
0:00:57
0:00:29
0:00:54
0:00:30
0:00:57
0:05:12
0:00:30
0:00:06
0:00:19
0:00:47
0:00:08
0:00:15