Databricks, Python Notebook Data file use issue

[khalid2200]

Hi Guys,
G'day
I am using python notebook at the databricks platform,i have imported a csv file which has two columns C1 and C2. After importing I want to use those columns in further coding to apply other requirements on the data. After the import i can see python notebooks has created a table

%sql

/* Query the created temp table in a SQL cell */

select * from table name


with above command i can see C1 and C2 data but i am unable to find the way how can i use them in python normal coding if i need to store both of the columns in an array and apply other restrictions by checks e.g if statements, loops, store them in a list etc

please let me know if so that i can proceed further?

Khalid
[email protected]