Flattened JSON Repeating Columns Pandas

Question

I'm having an issue currently with pulling from an API, getting a JSON dict, then flattening it, and placing it into a dataframe. The data is structured like this from the json: X1_0, X2_0, X3_0 ... X1_1, X2_1, X2_1, ... X1_2, X2_2, X2_3 and when I flatten it and place into a dataframe I get each flattened key as an individual column header rather than all combined since they have they _#. So rather than getting something that's shape is 22 x 6 I get something that would be like 1 x 130. I'm basically just interested in getting the shape of the dataframe correct but I'm not sure how I should fix it, and whether it should be done before flattening or after? Any help is appreciated JavaScript questions and answers, JavaScript questions pdf, JavaScript question bank, JavaScript questions and answers pdf, mcq on JavaScript pdf, JavaScript questions and solutions, JavaScript mcq Test , Interview JavaScript questions, JavaScript Questions for Interview, JavaScript MCQ (Multiple Choice Questions)

Answer 1

Try to strip the _# from the keys. My guess is that they are added in the flattening step, so it should be easy to get rid of them. Now you will get several values per key. Fix this by creating a list of JSON objects where each contains all the values for each key with the same _#.