GRADE XII IP - Creating DataFrame from Dictionary

 

Creating DataFrame from Dictionary

1. Dictionary of List

import pandas as pd

# Creating dictionary

data = {

    'Name': ['Aman', 'Riya', 'Karan', 'Sita'],

    'Class': ['XII', 'XII', 'XII', 'XII'],

    'Marks': [85, 90, 78, 88]

}

# Creating DataFrame

df = pd.DataFrame(data)

# Display DataFrame

print(df)

2. import pandas as pd

data = {

    'Product': ['Pen', 'Pencil', 'Eraser'],

    'Price': [10, 5, 3]

}

df = pd.DataFrame(data, index=['P1', 'P2', 'P3'])

print(df)

Creating DataFrame from List of Dictionaries

import pandas as pd

# List of dictionaries

data = [

    {'Name': 'Aman', 'Marks': 85, 'Subject': 'Math'},

    {'Name': 'Riya', 'Marks': 90, 'Subject': 'Science'},

    {'Name': 'Karan', 'Marks': 78, 'Subject': 'English'}

]

# Create DataFrame

df = pd.DataFrame(data)

print(df)

Example 2: Missing Values Case

import pandas as pd

data = [

    {'Name': 'Aman', 'Marks': 85},

    {'Name': 'Riya', 'Subject': 'Science'},

    {'Name': 'Karan', 'Marks': 78, 'Subject': 'English'}

]

df = pd.DataFrame(data)

print(df)

Important Exam Points

1. List contains multiple dictionaries (rows)

2. Missing values are filled with NaN

3. Column names are taken from all unique keys

Creating DataFrame from Dictionary of Series

import pandas as pd

# Creating Series

s1 = pd.Series([85, 90, 78], index=['Aman', 'Riya', 'Karan'])

s2 = pd.Series([88, 92, 80], index=['Aman', 'Riya', 'Karan'])

# Dictionary of Series

data = {

    'Math': s1,

    'Science': s2

}

# Creating DataFrame

df = pd.DataFrame(data)

print(df)

IMP POINTS

1.Each Series becomes a column in the DataFrame

2.The index of Series becomes row labels

3.Dictionary keys → column names

4.Data aligns automatically based on index values