Pandas confused

[snippsat]

Yes if the goal to take data out Pandas to a list then it will work,as column index don't get used.
If take that list back into DataFrame then it will automatically give column index.

>>> data = Qdf.values.tolist()
>>> data
[['AF-10', 744.42],
 ['AF-10', 1243.68],
 ['AF-20', 90.0],
 ['BA-40', -1425.0],
 ['BA-40', 1425.0],
 ['BA-40', 1425.0],
 ['BA-40', 1425.0],
 ['BA-50', 150.0],
 ['BO-30', 16514.61],
 ['BR-10', 528.35]]
>>> type(data) # A normal Python list
<class 'list'>
>>> 
>>> import pandas as pd
>>> 
>>> df = panda.DataFrame(data)
>>> df
       0         1
0  AF-10    744.42
1  AF-10   1243.68
2  AF-20     90.00
3  BA-40  -1425.00
4  BA-40   1425.00
5  BA-40   1425.00
6  BA-40   1425.00
7  BA-50    150.00
8  BO-30  16514.61
9  BR-10    528.35
>>> df = df.rename(columns={0: 'Name', 1: 'Cost'})
>>> df
    Name      Cost
0  AF-10    744.42
1  AF-10   1243.68
2  AF-20     90.00
3  BA-40  -1425.00
4  BA-40   1425.00
5  BA-40   1425.00
6  BA-40   1425.00
7  BA-50    150.00
8  BO-30  16514.61
9  BR-10    528.35
>>> type(df) # A DataFrame
<class 'pandas.core.frame.DataFrame'>