I knew it wouldn't take much code to do this, but there was still a little fiddling around and some odd errors along the way. Anyhow if you want to do this here is some helpful tips

Firstly download the latest stable version of Python. Next download and install the cx_Oracle extension, from Oracle official website. You will then need to download and install the Oracle Client ensuring you select the version specific to your installation ie. 10g or 11g etc. You can get the download from here Oracle software downloads.

Make sure that you have the ORACLE_HOME variable set and the bin is in your PATH variable, otherwise you will get cx_Oracle DLL load failure messages.

If you have a fairly, long complex SQL statement then encase the query within triple single quotes. It works a treat and takes care of new lines without need for you to do any formatting or

string manipulation. Lets Start

Note : This Course explicitly for working with CSV, Python and Oracle .

What is CSV?

CSV stands for “Comma Separated Values.” It is the simplest form of storing data in tabular form as plain text. It is important to know to work with CSV because we mostly rely on CSV data in our day-to-day lives as data scientists.

1. Import the CSV library

import csv

2. Open the CSV file

The .open() method in python is used to open files and return a file object.

file = open('your_file.csv')

type(file)

The type of file is “_io.TextIOWrapper” which is a file object that is returned by the open() method.

3. Use the csv.reader object to read the CSV file

csvreader = csv.reader(file)

Good Luck !!!

Thanks,

Arun Ammasai