Creating DataFrames Cookbook

Combining multiple Series into a DataFrame Combining multiple Series to form a DataFrame Converting a Series to a DataFrame Converting list of lists into DataFrame Converting list to DataFrame Converting percent string into a numeric for read_csv Converting scikit-learn dataset to Pandas DataFrame Converting string data into a DataFrame Creating a DataFrame from a string Creating a DataFrame using lists Creating a DataFrame with different type for each column Creating a DataFrame with empty values Creating a DataFrame with missing values Creating a DataFrame with random numbers Creating a DataFrame with zeros Creating a MultiIndex DataFrame Creating a Pandas DataFrame Creating a single DataFrame from multiple files Creating empty DataFrame with only column labels Filling missing values when using read_csv Importing Dataset Initialising a DataFrame using a constant Initialising a DataFrame using a dictionary Initialising a DataFrame using a list of dictionaries Inserting lists into a DataFrame cell Keeping leading zeroes when using read_csv Parsing dates when using read_csv Preventing strings from getting parsed as NaN for read_csv Reading data from GitHub Reading file without header Reading large CSV files in chunks Reading n random lines using read_csv Reading space-delimited files Reading specific columns from file Reading tab-delimited files Reading the first few lines of a file to create DataFrame Reading the last n lines of a file Reading URL using read_csv Reading zipped csv file as a DataFrame Removing Unnamed:0 column Resolving ParserError: Error tokenizing data Saving DataFrame as zipped csv Skipping rows without skipping header for read_csv Specifying data type for read_csv Treating missing values as empty strings rather than NaN for read_csv

thumb_up

thumb_down

chat_bubble_outline
0
 auto_stories new 
settings

Initialising a Pandas DataFrame using a list of dictionaries

Programming

Python

Pandas

Cookbooks

DataFrame Cookbooks

Creating DataFrames Cookbook

Mar 9, 2022

Last updated

local_offer Python●Pandas

Tags

Table of Contents

Suppose we have the following list of dictionaries:


        
        
            
                
                
                    data = [{"A":3, "B":4, "C":5}, 
        {"A":6, "C":7}, 
        {"A":8, "B":9}]

To initialise a Pandas DataFrame using data, simply pass it to the DataFrame constructor:


        
        
            
                
                
                    df = pd.DataFrame(data)
df
                
            
               A  B    C
0  3  4.0  5.0
1  6  NaN  7.0
2  8  9.0  NaN

Published by Isshin Inada

Edited by 0 others

Did you find this page useful?

thumb_up

thumb_down

Comment

Citation

Share on Twitter

Share on Facebook

Ask a question or leave a feedback...

thumb_up

thumb_down

chat_bubble_outline

settings

A modern learning experience for data science and analytics