Python and Jupiter Notebook : How to connect Oracle DB using cx_oracle and save the data into a csv file

import cx_Oracle

# Connect as user "hr" with password "welcome" to the "oraclepdb" service running on this computer.
connection = cx_Oracle.connect("username", "*******", "pdatabasename:1521/DBNAME")

cursor = connection.cursor()

cursor.execute("""
    SELECT profile_id,first_name, last_name
    FROM t_profile
    WHERE rownum<= :run """,
    run = 50)

res = cursor.fetchall()
cursor.close()

print (res)

import pandas as pd
df_ora = pd.read_sql('SELECT profile_id,first_name, last_name FROM t_profile WHERE rownum<= 50', con=connection) 
df_ora

df_ora.to_csv('data_from_ora.csv',index=False,header=True)

df_ora.info()