-1

Please help me creating a Dataframe from list of dictionaries

Dataset = [{'A': ' X1'}, {'B': ' Y1'}, {'A': ' X2'}, {'B': ' Y2'}, {'A': ' X3'}, {'B': ' Y3'}, {'C': ' Z3'}]

The output should be:

The output should be:

Ch3steR
  • 20,090
  • 4
  • 28
  • 58
Roy
  • 1
  • 1

1 Answers1

2

you can use defaultdict and pandas' from_dict method. The trick is to use the orient parameter and transpose the dataframe in order to handle the missing values in the C column

def cast_to_dataframe(_ds):
    """
    Cast the given list of dictionaries to one dataframe

    :param _ds: List of dictionaries
    :return: DataFrame
    """

    final_dict = defaultdict(list)

    # Iterate through each dictionary in _ds
    for d in _ds:
        for key, value in d.items():
            final_dict[key].append(value)
    # Cast back to dict
    final_dict = dict(final_dict)
    df = pd.DataFrame.from_dict(final_dict, orient='index')

    return df.transpose()

dataset = [{'A': ' X1'}, {'B': ' Y1'}, {'A': ' X2'}, {'B': ' Y2'}, {'A': ' X3'}, {'B': ' Y3'}, {'C': ' Z3'}]

cast_to_dataframe(dataset)
Jannik
  • 965
  • 2
  • 12
  • 21
  • Thank You The output is a bit different. Z3 is coming in X1 row. The output u are gettng is similar to what i was getting, but the i need Z3 in X3 row. – Roy Jun 22 '20 at 10:33