Skip to content

Instantly share code, notes, and snippets.

@GzuPark
Created March 6, 2018 14:28
Show Gist options
  • Save GzuPark/c6f58ad16bf6a7e68e3384680dfc08ed to your computer and use it in GitHub Desktop.
Save GzuPark/c6f58ad16bf6a7e68e3384680dfc08ed to your computer and use it in GitHub Desktop.
SQL 실습, Big Data (2018 spring), Postechx
1 data 4
1 base 3
1 system 5
1 fall 6
1 semeter 2
2 data 1
2 base 2
2 structure 3
2 network 4
2 algorithm 5
3 ds 2
3 sd 3
3 final 4
3 mid 5
4 system 1
4 ds 4
4 sd 3
4 pl 5
4 data 2
5 base 2
5 structure 2
5 network 3
5 fall 4
6 data 2
6 base 4
@GzuPark
Copy link
Author

GzuPark commented Mar 6, 2018

  • Requirements
  1. SQLite [Link]
  • Prep
  1. Install SQLite
  2. Download Documents.csv file. [Download Link]
  3. Run SQLite
  4. Run codes like below
create table Documents(DocID int, Term text, Count int);
.mode csv
.import <DIR where the file located>/Documents.csv Documents

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment