Create single row python pandas dataframe

Question

I want to create a python pandas DataFrame with a single row, to use further pandas functionality like dumping to *.csv.

I have seen code like the following being used, but I only end up with the column structure, but empty data

import pandas as pd  df = pd.DataFrame() df['A'] = 1 df['B'] = 1.23 df['C'] = "Hello" df.columns = [['A','B','C']]  print df  Empty DataFrame Columns: [A, B, C] Index: [] 

While I know there are other ways to do it (like from a dictionary), I want to understand why this piece of code is not working for me!? Is this a version issue? (using pandas==0.19.2)

Answer 1

In [399]: df = pd.DataFrame(columns=list('ABC'))  In [400]: df.loc[0] = [1,1.23,'Hello']  In [401]: df Out[401]:    A     B      C 0  1  1.23  Hello 

or:

In [395]: df = pd.DataFrame([[1,1.23,'Hello']], columns=list('ABC'))  In [396]: df Out[396]:    A     B      C 0  1  1.23  Hello