Refactor read_excel result using python

Question

I'm working on small project using Python i try to refactor my pd.read_excel() result but i get only the last row in my data variable:

this is my code :

@action(methods=['post'], detail=False)
def bulkImport(self, request, pk=None):
    file_uploaded = request.FILES.get('file')
    context = pd.read_excel(file_uploaded, engine='openpyxl')
    data = {}
    for column in context:
        for b in context[column].tolist():
            data[column] = b
            
    print(data)

Native read_excel() result :

{
    "name": [
        "amine",
        "bill"
    ],
    "company": [
        "bouhaddi",
        "microsoft"
    ],
    "email": [
        "[email protected]",
        "[email protected]"
    ],
    "phone": [
        43822510594,
        559485556555
    ],
    "adress": [
        "3820 albert st",
        "new york"
    ]
}

Expected Result :

{
    'name' : 'value',
    'phone' : 'value',
    'email' : 'value',
    'company' : 'value',
    'adress' : 'value',
},
{
    'name' : 'value',
    'phone' : 'value',
    'email' : 'value',
    'company' : 'value',
    'adress' : 'value',
}

Ajay · Accepted Answer · 2021-03-25 22:08:16Z

1

context={
    "name": [
        "amine",
        "bill"
    ],
    "company": [
        "bouhaddi",
        "microsoft"
    ],
    "email": [
        "[email protected]",
        "[email protected]"
    ],
    "phone": [
        43822510594,
        559485556555
    ],
    "adress": [
        "3820 albert st",
        "new york"
    ]
}

data=[{k:v[i]  for k,v in context.items() } for i in range(2) ]

Output:

[{'name': 'amine',
  'company': 'bouhaddi',
  'email': '[email protected]',
  'phone': 43822510594,
  'adress': '3820 albert st'},
 {'name': 'bill',
  'company': 'microsoft',
  'email': '[email protected]',
  'phone': 559485556555,
  'adress': 'new york'}]

Using list comprehension and dictionary comprehension can give you the two dicts within a list

edited Mar 25, 2021 at 22:08

answered Mar 25, 2021 at 21:54

Ajay

5,3092 gold badges26 silver badges30 bronze badges

Sign up to request clarification or add additional context in comments.

13 Comments

Amine Bouhaddi Over a year ago

please can you give me a real example :) using my function if possible

Amine Bouhaddi Over a year ago

data is empty when i print

Ajay Over a year ago

I modified your data variable because there are many unknowns for me like columns...

Amine Bouhaddi Over a year ago

i used your code but there is no result in data :(

Amine Bouhaddi Over a year ago

print(data) is empty

|

Collectives™ on Stack Overflow

Refactor read_excel result using python

1 Answer 1

13 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

13 Comments

Your Answer

Sign up or log in

Post as a guest

Related