数据列拆分请求：将字典{"1": 3.0, "5": 3.0}拆分为四列

Got it, let's tackle this problem where you need to split the dictionary {"1": 3.0, "5": 3.0} into four separate columns with values 1, 3.0, 5, 3.0 respectively. Here's a practical, easy-to-follow solution using Python and pandas—perfect for tabular data tasks like this:

Step-by-Step Implementation #

First, we'll flatten the dictionary into a linear list of its keys and values, then convert that list into a pandas DataFrame with four dedicated columns.

import pandas as pd

# Your input dictionary
input_dict = {"1": 3.0, "5": 3.0}

# Flatten the dict into a list of keys followed by their values
flattened_values = []
for key, val in input_dict.items():
    flattened_values.append(key)
    flattened_values.append(val)

# Create a DataFrame with four columns
result_df = pd.DataFrame([flattened_values], columns=["col_key_1", "col_val_1", "col_key_2", "col_val_2"])

print(result_df)

Output #

Running this code will give you the exact structure you need:

col_key_1  col_val_1 col_key_2  col_val_2
0         1        3.0         5        3.0

Concise One-Liner Version #

If you prefer shorter code, you can use a list comprehension to flatten the dictionary in one go:

import pandas as pd

input_dict = {"1": 3.0, "5": 3.0}
flattened = [item for pair in input_dict.items() for item in pair]
result_df = pd.DataFrame([flattened], columns=[f"col_{i+1}" for i in range(4)])

Customization Tip #

If you want specific column names instead of the generic ones above, just replace the columns parameter with your preferred labels. For example:

columns=["first_key", "first_value", "second_key", "second_value"]

内容的提问来源于stack exchange，提问作者ak3191