How to create empty pandas DataFrame with same columns and types as existing DataFrame

create_empty_dataframe.py

empty_df = pd.DataFrame(columns=df.columns).astype(df.dtypes)

empty_df = pd.DataFrame(columns=df.columns).astype(df.dtypes)

Full example

create_empty_dataframe_example.py

import pandas as pd

# Initialize data to lists.
data = {'Name': ['Tom', 'Nick', 'John'],
        'Age': [20, 21, 19]}

# Create DataFrame
df = pd.DataFrame(data)

empty_df = pd.DataFrame(columns=df.columns).astype(df.dtypes)

import pandas as pd

# Initialize data to lists.
data = {'Name': ['Tom', 'Nick', 'John'],
        'Age': [20, 21, 19]}

# Create DataFrame
df = pd.DataFrame(data)

empty_df = pd.DataFrame(columns=df.columns).astype(df.dtypes)

Check out similar posts by category: Pandas, Python

If this post helped you, please consider buying me a coffee or donating via PayPal to support research & publishing of new posts on TechOverflow

Buy me a coffee