jtrive84

library(ROracle)

Sys.setenv(TZ='America/Chicago')
Sys.setenv(ORA_SDTZ='America/Chicago')

#=============================================
# Upload dataframe as Oracle database table  |          
#=============================================
dfToOracle <- function(dataframe, 
                       tablename, 

jtrive84

A
abactinally
Abassieh
Abbottstown
Abe
abevacuation
abiogenesist
ablauts
aboideaus
Aboukir

jtrive84

"""
Suppress  double-spaced output in Python 3 by specifying `lineterminator="\n"` 
to csv.writer instance.
"""
import csv

fsrc_pth = "src_pth"
fdst_pth = "dst_pth"

with open(fdst_pth, 'w') as f1:

jtrive84

Introduction to cx_Oracle

cx_Oracle is a third-party Python library that facilitates Oracle-to-Python database communication. A cursor is a control structure that enables traversal over the records in a database. This is Python's primary means of accessing database table data. The setup is:

• Create a connection object
• Define a cursor and call the cursor() method on the connection object
• Construct a query string for the data of interest
• Pass the query string to the cursor's execute method

jtrive84

jtrive84

Higher Order Functions

Relevant Links:

Python Functional Programming HOWTO
Python's itertools module
Python Sorting Wiki

jtrive84

Introduction to SQLite in Python

Relevant Links:

• Python sqlite3 Documentation
• SQLite Documentation

---

SQLite is a C library that provides a lightweight disk-based database that doesn't require a separate server process. Applications can use SQLite for internal data storage. It's also possible to prototype an application using SQLite then later migrate to a more

jtrive84

Python Data Structures and Iteration

The first part of this introduction will discuss two very useful functions: enumerate and zip:

jtrive84

cd && dircolors -p > .dircolors

jtrive84