Create data frame with missing values

Question

I want to create a table and fill missing values with my data

The data look like this:

    {'A': 0, 'C': 0, 'D': 0, 'E': 0, 'F': 0, 'G': 0}
    {'A': 0, 'B': 0, 'C': 0, 'D': 0, 'E': 0, 'F': 0}

I want to convert the data into pandas data frame with missing values

     A B C D E F G
   1 0 na 0 0 0 0 0
   2 0 0 0 0 0 0 na

I could manually give the missing values (using the below code) and then convert it into data frame. Is there a better way to fill the missing values and convert it into data frame

import pandas as pd

s = (( 0,  'na',  0,  0,  0,  0,  0),
( 0,  0,  0,  0,  0,  0,  'na'))

print (pd.DataFrame(list(s)))

print (pd.DataFrame(list(s), columns=['A', 'B', 'C', 'D', 'E', 'F','G'], index=[1,2]))

Thanks

jezrael · Accepted Answer · 2022-09-07 10:25:22Z

1

If pass list of DataFrame then need only sorting columns names:

L = [ {'A': 0, 'C': 0, 'D': 0, 'E': 0, 'F': 0, 'G': 0},
      {'A': 0, 'B': 0, 'C': 0, 'D': 0, 'E': 0, 'F': 0}]
    
print (pd.DataFrame(L).sort_index(axis=1))
   A    B  C  D  E  F    G
0  0  NaN  0  0  0  0  0.0
1  0  0.0  0  0  0  0  NaN

edited Sep 7, 2022 at 10:25

answered Sep 7, 2022 at 10:19

jezrael

868k103 gold badges1.4k silver badges1.3k bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Atom Over a year ago

Thank you. I can get the column names in order

Collectives™ on Stack Overflow

Create data frame with missing values

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related