Elegant way to create empty pandas DataFrame with NaN of type float

Question

I want to create a Pandas DataFrame filled with NaNs  During my research I found an answer   import pandas as pd  df   pd DataFrame index range 0 4  columns   A      This code results in a DataFrame filled with NaNs of type  object   So they cannot be used later on for example with the interpolate   method  Therefore  I created the DataFrame with this complicated code  inspired by this answer    import pandas as pd import numpy as np  dummyarray   np empty  4 1   dummyarray      np nan  df   pd DataFrame dummyarray    This results in a DataFrame filled with NaN of type  float   so it can be used later on with interpolate    Is there a more elegant way to create the same result

User · Answer

You can try this line of code   pdDataFrame   pd DataFrame  np nan    7    This will create a pandas dataframe of size 7 with NaN of type float   if you print pdDataFrame the output will be        0 0   NaN 1   NaN 2   NaN 3   NaN 4   NaN 5   NaN 6   NaN   Also the output for pdDataFrame dtypes is   0    float64 dtype  object

User · Answer

For multiple columns you can do    df   pd DataFrame np zeros  nrow  ncol   np nan

User · Answer

You could specify the dtype directly when constructing the DataFrame    gt  gt  gt  df   pd DataFrame index range 0 4  columns   A    dtype  float    gt  gt  gt  df dtypes A    float64 dtype  object   Specifying the dtype forces Pandas to try creating the DataFrame with that type  rather than trying to infer it

User · Answer

Hope this can help    pd DataFrame np nan  index   np arange  lt num rows gt    columns     A

User · Answer

Simply pass the desired value as first argument  like 0  math inf or  here  np nan  The constructor then initializes and fills the value array to the size specified by arguments index and columns    gt  gt  gt  import numpy as np  gt  gt  gt  import pandas as pd  gt  gt  gt  df   pd DataFrame np nan  index  0  1  2  3   columns   A    B      gt  gt  gt  df dtypes A    float64 B    float64 dtype  object   gt  gt  gt  df values array   nan  nan           nan  nan           nan  nan           nan  nan

[python] Elegant way to create empty pandas DataFrame with NaN of type float

Examples related to python

Examples related to pandas

Examples related to numpy

Examples related to dataframe

Examples related to nan