updated readme · rafunet/python_reference@45c931b · GitHub

rafunet / python_reference Public

forked from rasbt/python_reference

• Notifications You must be signed in to change notification settings
• Fork 0
• Star 0

• Code
• Pull requests
• Actions
• Projects
• Wiki
• Security and quality
• Insights

Additional navigation options

Commit 45c931b

Browse filesBrowse the repository at this point in the historyBrowse files

rasbt

committed

updated readme

1 parent edc17e2 commit 45c931b
Copy full SHA for 45c931b

1 file changed

+4-1Lines changed: 4 additions & 1 deletion

File tree

Expand file treeCollapse file tree

Open diff view settings

Filter options

• useful_scripts
  • large_csv_to_sqlite.py

Expand file treeCollapse file tree

Open diff view settings

Collapse file

‎useful_scripts/large_csv_to_sqlite.py‎

Copy file name to clipboardExpand all lines: useful_scripts/large_csv_to_sqlite.py

+4-1Lines changed: 4 additions & 1 deletion

Original file line number	Diff line number	Diff line change
@@ -17,6 +17,9 @@
17	17	table_name = 'my_table' # name for the SQLite database table
18	18	chunksize = 100000 # number of lines to process at each iteration
19	19
	20	+ # columns that should be read from the CSV file
	21	+ columns = ['molecule_id','charge','db','drugsnow','hba','hbd','loc','nrb','smiles']
	22	+
20	23	# Get number of lines in the CSV file
21	24	nlines = subprocess.check_output('wc -l %s' % in_csv, shell=True)
22	25	nlines = int(nlines.split()[0])
@@ -33,7 +36,7 @@
33	36	skiprows=i) # skip rows that were already read
34	37
35	38	# columns to read
36		- df.columns = ['molecule_id','charge','db','drugsnow','hba','hbd','loc','nrb','smiles']
	39	+ df.columns = columns
37	40
38	41	sql.to_sql(df,
39	42	name=table_name,

0 commit comments

Comments

0 (0)