Write from dictionary to excel

[divon]

Hello everyone, I would like to ask about how to write from a dictionary into excel.

The program that I have written so far:

import numpy as np
import pandas as pd

n = 3
N = pow(2, n)

ilr_arr = np.zeros((n+1, N))
ilr_dict = dict()
for idp in range(n + 1):
    a = pow(2, idp)
    b = pow(2, n - idp)
    ilr_dict[idp] = np.reshape(ilr_arr[idp], (a, b))
    for ing in range(a):
        interleaver = np.arange(pow(2, n - idp))
        np.random.shuffle(interleaver)
        ilr_dict[idp][ing] = interleaver
    # df = pd.DataFrame(data=ilr_dict[idp], index=[0]) when I use this syntax, it become error.

If there are any suggestions about this, please tell me.

[Am1n3]

Hi divon,
The answer to your request by using df.to_excel() method, which creates the excel file then writes your dataframe into it,

import numpy as np
import pandas as pd

n = 3
N = pow(2, n)

ilr_arr = np.zeros((n+1, N))
ilr_dict = dict()
df = pd.DataFrame
for idp in range(n + 1):
    a = pow(2, idp)
    b = pow(2, n - idp)
    ilr_dict[idp] = np.reshape(ilr_arr[idp], (a, b))
    for ing in range(a):
        interleaver = np.arange(pow(2, n - idp))
        np.random.shuffle(interleaver)
        ilr_dict[idp][ing] = interleaver
        df=pd.DataFrame(data=ilr_dict[idp])
print(df)
df.to_excel('saveMyOutput.xlsx')

[divon]

Hi divon,
The answer to your request by using df.to_excel() method, which creates the excel file then writes your dataframe into it,

import numpy as np
import pandas as pd

n = 3
N = pow(2, n)

ilr_arr = np.zeros((n+1, N))
ilr_dict = dict()
df = pd.DataFrame
for idp in range(n + 1):
    a = pow(2, idp)
    b = pow(2, n - idp)
    ilr_dict[idp] = np.reshape(ilr_arr[idp], (a, b))
    for ing in range(a):
        interleaver = np.arange(pow(2, n - idp))
        np.random.shuffle(interleaver)
        ilr_dict[idp][ing] = interleaver
        df=pd.DataFrame(data=ilr_dict[idp])
print(df)
df.to_excel('saveMyOutput.xlsx')

Thank you very much for your reply, @Am1n3. It really helps me to proceed with my task.

[Larz60+]

There are many packages that deal with excel.
Not something that I do often, but when I do, I tend to use openpyxl
Now, there may be better choices.
PyPi: https://pypi.org/project/openpyxl/
ReadTheDocs: https://openpyxl.readthedocs.io/en/stable/