Pandas

csv-to-pandas.py

import pandas as pd

# Read file
results = pd.read_csv("/tmp/data.csv", encoding='utf-8',sep=',', quoting=csv.QUOTE_ALL)

# Print rows
for row in results:
  print(row)
 
# Iterate over rows
for index, row in data.iterrows():
  print(row)

sql-to-csv.py

import cx_Oracle
import pandas as pd

# Create connection
connection = cx_Oracle.connect(CONN_STRING)
cursor = connection.cursor()
cursor.execute("SELECT * FROM TABLE")

# Grab metadata
csv_heading = [col[0] for col in cursor.description]

# Grab results
results = cursor.fetchall()

# Write results to `CSV`
pd.DataFrame(results, columns=csv_heading).to_csv("/tmp/data.csv", index=False, encoding='utf-8',sep=',', quoting=csv.QUOTE_ALL)