%install_ext https://raw.githubusercontent.com/FrankSalad/ipython-csvmagic/master/csvtools.py
%load_ext csvtools

"n","order_number","name"
"0","389","John Snow"
"1","405","Princess Bubblegum"

In [7]: %loadcsv a.csv
Loaded 2 values in n,order_number,name

In [8]: n
Out[8]: ['0', '1']
In [9]: order_number
Out[9]: ['389', '405']
In [10]: name
Out[10]: ['John Snow', 'Princess Bubblegum']

In [13]: %loadcsv a.csv col_
Loaded 2 values in col_n,col_order_number,col_name

In [14]: col_n
Out[14]: ['0', '1']

In [15]: col_order_number
Out[15]: ['389', '405']

In [16]: col_name
Out[16]: ['John Snow', 'Princess Bubblegum']

In [23]: title = ['The Origin of Species', 'Oryx and Crake', 'Fahrenheit 451']

In [24]: name = ['Charles Darwin', 'Margaret Atwood', 'Ray Bradbury']

In [25]: n = range(len(title))

In [26]: %storecsv b.csv n name title

$ cat b.csv 
"n","name","title"
"0","Charles Darwin","The Origin of Species"
"1","Margaret Atwood","Oryx and Crake"
"2","Ray Bradbury","Fahrenheit 451"