How To Add An Empty Column To A Dataframe In Python

How to add Empty Column to Dataframe in Pandas?

In dataFrames, Empty columns are defined and represented with NaN Value(Not a Number value or undefined or unrepresentable value). At that place are diverse methods to add together Empty Column to Pandas Dataframe.

Method 1: Using the Assignment Operator.

This method is used to forcefully assign any cavalcade a cipher or NaN value.

Python3

                import                numpy equally np              
                import                pandas as pd              
                Mydataframe                                =                pd.DataFrame({                'FirstName'                : [                'Vipul'                ,              
                                'Ashish'                ,              
                                'Milan'                ],              
                                "Historic period"                : [                21                ,                22                ,                23                ]})              
                print                (                "\n\n---Original Dataframe---\north"                ,              
                                Mydataframe)              
                Mydataframe[                'Gender'                ]                                =                ''              
                Mydataframe[                'Section'                ]                                =                np.nan              
                print                (                "---Updated Dataframe---\north"                ,              
                                Mydataframe)              

Output:

add empty column to dataframe

In the in a higher place case, nosotros are usingthe consignment operator to assign empty cord and Zilch value to two newly created columns every bit "Gender" and "Department" respectively for pandas data frames (table). Numpy library is used to import NaN value and apply its functionality.

Method ii: Using Dataframe.reindex().

This method is used to create new columns in a dataframe and assign value to these columns(if not assigned, null will be assigned automatically).
Instance :

Python3

                import                pandas every bit pd              
                Mydataframe                                =                pd.DataFrame({                'FirstName'                : [                'Preetika'                ,              
                                'Tanya'                ,              
                                'Akshita'                ],              
                                "Age"                : [                25                ,                21                ,                22                ]})              
                print                (                "---Original Dataframe---\north"                ,              
                                Mydataframe)              
                Mydataframe                                =                Mydataframe.reindex(columns                                =                Mydataframe.columns.tolist()              
                                +                [                'Gender'                ,                'Roll Number'                ])              
                print                (                "\northward\due north---Updated Dataframe---\n"                ,              
                                Mydataframe)              

Output:

add empty column to dataframe-2

In the in a higher place instance, we created a data frame with two columns "Offset name and "Age" and later usedDataframe.reindex() method to add together ii new columns "Gender" and " Roll Number" to the listing of columns with NaN values.

Method 3: Using Dataframe.insert().

This method is used to add a new column to a pandas dataframe at any index location we desire and assign the appropriate value equally per demand.
Instance:

Python3

                import                pandas equally pd              
                Mydataframe                                =                pd.DataFrame({                'FirstName'                : [                'Rohan'                ,              
                                'Martin'                ,              
                                'Mary'                ],              
                                "Age"                : [                28                ,                39                ,                21                ]})              
                print                (                "---Original Dataframe---\n"                ,              
                                Mydataframe)              
                Mydataframe.insert(                0                ,                'Whorl Number'                ,'')              
                print                (                "\n\northward---Updated Dataframe---\due north"                ,              
                                Mydataframe)              

Output:

add empty column to dataframe-3

In the above example, we are using theDataframe.insert()method on pandas information frames (tabular array) to add together an empty column "Roll Number", here we can also insert the column at any index position nosotros want (equally here we placed the value at index location 0).