Python中科学计数法转换为浮点数

# import pandas as pd
# import xlwt
# total_relation_matrix = [[1.51818600e-02, 1.17929053e-01,2.71389429e-02, 2.45193226e-02,
#   7.17463798e-04, 1.16871931e-04, 9.06054283e-03, 7.07482649e-03,
#   0.00000000e+00, 0.00000000e+00, 0.00000000e+00, 1.57393658e-01,
#   0.00000000e+00, 1.28911059e-02, 0.00000000e+00, 0.00000000e+00,
#   1.58274134e-01, 9.35640243e-02, 1.42524195e-02, 2.37843280e-02],
#  [1.10208293e-01, 2.23494559e-02, 7.82132223e-02, 3.12900738e-02,
#   8.44033991e-04, 1.37489700e-04, 1.06589435e-02, 7.56216579e-03,
#   0.00000000e+00, 0.00000000e+00, 0.00000000e+00, 1.62748722e-01,
#   0.00000000e+00, 1.41388819e-02,0.00000000e+00, 0.00000000e+00,
#   1.73594050e-01, 9.98804670e-02, 4.39311326e-02, 3.02496042e-02],
#  [6.92177050e-02, 1.02197235e-01, 4.07637081e-02,.21744476e-01,
#   3.98088328e-04, 6.48469674e-05, 5.02728688e-03, 1.51956146e-03,
#   0.00000000e+00, 0.00000000e+00, 0.00000000e+00, 1.89807540e-01,
#   0.00000000e+00, 1.70177916e-02, 0.00000000e+00, 0.00000000e+00,
#   2.08940664e-01, 1.96894335e-02, 1.04631312e-02, 7.59435015e-02],
#  [9.99921946e-02, 1.38919771e-01,1.30349320e-01, 3.55242531e-02,
#   2.38617641e-04, 3.88698420e-05, 3.01339993e-03, 1.65764938e-03,
#   0.00000000e+00, 0.00000000e+00, 0.00000000e+00, 1.73659831e-01,
#   0.00000000e+00, 1.63795318e-02, 0.00000000e+00, 0.00000000e+00,
#   2.01104252e-01, 2.18047592e-02, 8.50655085e-03, 2.40258171e-02],
#  [9.49700973e-03, 1.37075601e-02, 2.85539023e-02, 8.76825337e-02,
#   9.88187877e-03, 1.64505645e-01, 1.24794012e-01, 1.27468397e-01,
#   0.00000000e+00, 0.00000000e+00, 0.00000000e+00, 1.70650698e-01,
#   0.00000000e+00, 1.32460411e-02, 0.00000000e+00, 0.00000000e+00,
#   1.62631949e-01, 2.41675261e-02, 1.38972912e-02, 8.93498401e-02],
#  [8.27639011e-03, 1.18650684e-02, 2.22364974e-02, 7.81549973e-02,
#   5.05868445e-05, 8.24039095e-06, 6.38839579e-04, 1.84354841e-04,
#   0.00000000e+00, 0.00000000e+00,0.00000000e+00, 1.21825318e-01,
#   0.00000000e+00, 9.72368490e-03, 0.00000000e+00, 0.00000000e+00,
#   1.19385242e-01, 2.38492616e-03, 1.56210639e-03, 9.72966441e-03],
#  [2.87851143e-03, 4.37684463e-03, 1.54678076e-02, 2.20741201e-02,
#   8.04300566e-02, 1.31017287e-02, 1.57167144e-02, 1.47233087e-02,
#   0.00000000e+00, 0.00000000e+00, 0.00000000e+00, 1.13716661e-01,
#   0.00000000e+00, 9.10593347e-03, 0.00000000e+00, 0.00000000e+00,
#   1.11800628e-01, 6.31530095e-02, 8.02881091e-03, 2.19205977e-02],
#  [2.98216601e-03, 4.63128153e-03, 1.83661529e-02, 2.12947205e-02,
#   6.58997432e-04, 1.07347998e-04, 8.32219614e-03, 5.57936361e-03,
#   0.00000000e+00, 0.00000000e+00, 0.00000000e+00, 1.28877271e-01,
#   0.00000000e+00, 1.17619488e-02, 0.00000000e+00, 0.00000000e+00,
#   1.44410594e-01, 7.36313290e-02, 4.94292150e-02, 2.22369113e-02],
#  [3.08848080e-03, 4.91209020e-03, 2.08169277e-02, 2.07914404e-02,
#   5.43841581e-05, 8.85895788e-06, 6.86794225e-04, 1.23516326e-04,
#   8.96566917e-04, 0.00000000e+00, 0.00000000e+00,1.29734204e-01,
#   0.00000000e+00, 1.51367083e-02, 0.00000000e+00, 1.58513031e-02,
#   1.62508501e-01, 1.56372992e-03, 1.63764094e-03, 1.24882835e-02],
#  [1.74436717e-02, 5.32520680e-02, 1.10190009e-01, 8.82285185e-02,
#   1.79130252e-04,2.91795885e-05, 2.26215918e-03, 7.70340620e-02,
#   8.99787682e-04, 3.59233081e-03, 7.56100104e-02, 1.67591364e-01,
#   0.00000000e+00, 2.63608490e-02, 0.00000000e+00, 1.59082462e-02,
#   2.20421606e-01, 1.31124433e-02, 8.40493758e-03, 2.32029096e-02],
#  [1.20745950e-02, 2.20641864e-02, 8.63686472e-02, 7.44217950e-02,
#   1.50471213e-04, 2.45111478e-05, 1.90023646e-03, 7.90422491e-02,
#   4.27500935e-05, 4.76819886e-02, 3.59233081e-03, 1.68952960e-01,
#   0.00000000e+00, 1.01974648e-01, 0.00000000e+00, 7.55821653e-04,
#   1.91561865e-01, 1.00518072e-02, 9.73962248e-03, 1.96299715e-02],
#  [1.22740860e-02, 1.77217200e-02, 6.93289648e-02, 9.32870697e-02,
#   7.39003518e-05, 1.20380664e-05, 9.33255871e-04, 2.72367170e-04,
#   0.00000000e+00, 0.00000000e+00, 0.00000000e+00, 4.08097929e-02,
#   0.00000000e+00, 1.16684303e-02,0.00000000e+00, 0.00000000e+00,
#   1.43262394e-01, 3.52490212e-03, 2.20433961e-03, 1.41837625e-02],
#  [2.33158186e-02, 3.96946513e-02,1.86193580e-01, 1.35566686e-01,
#   1.70712923e-04, 2.78084400e-05, 2.15586034e-03, 6.02086763e-04,
#   7.69869204e-02, 0.00000000e+00, 0.00000000e+00, 2.48544610e-01,
#   0.00000000e+00, 1.82980263e-01, 0.00000000e+00, 1.21128752e-01,
#   2.62707011e-01, 7.77979207e-03, 1.04857932e-02, 2.98950649e-02],
#  [1.86184211e-02, 6.22921403e-02, 1.02308452e-01, 9.64034805e-02,
#   2.40069525e-04, 3.91063480e-05, 3.03173515e-03, 8.40105496e-04,
#   0.00000000e+00, 0.00000000e+00, 0.00000000e+00, 1.86097131e-01,
#   0.00000000e+00, 1.78978880e-02, 0.00000000e+00, 0.00000000e+00,
#   2.19746291e-01, 1.08522062e-02, 4.13621374e-02, 2.44732359e-02],
#  [2.20108754e-02, 3.75062523e-02, 1.59711723e-01, 1.37855276e-01,
#   5.17575517e-04, 8.43109440e-05, 6.53623939e-03, 1.12516932e-03,
#   1.90507662e-01, 0.00000000e+00, 0.00000000e+00, 2.84902151e-01,
#   0.00000000e+00, 1.76459346e-01, 0.00000000e+00, 1.68175461e-01,
#   3.07825881e-01, 1.42078238e-02, 4.90144400e-02, 9.79138303e-02],
#  [1.78338514e-02, 3.02124024e-02, 1.16765334e-01, 1.19733299e-01,
#   1.37192098e-04, 2.23480341e-05, 1.73254021e-03, 4.69293797e-04,
#   5.66117968e-02, 0.00000000e+00, 0.00000000e+00, 2.24330375e-01,
#   0.00000000e+00, 1.40185379e-01, 0.00000000e+00, 8.96566917e-04,
#   2.47622762e-01, 6.05703918e-03, 8.14371414e-03, 2.46039335e-02],
#  [1.16701961e-02, 1.96650229e-02, 8.88875040e-02, 7.07842081e-02,
#   3.30430629e-04, 5.38258037e-05, 4.17286679e-03, 6.55416732e-04,
#   0.00000000e+00, 0.00000000e+00, 0.00000000e+00, 1.66276243e-01,
#   0.00000000e+00, 8.65952750e-02, 0.00000000e+00, 0.00000000e+00,
#   6.31975435e-02, 8.22789427e-03, 9.49733922e-03, 7.87251370e-02],
#  [3.89434408e-03, 5.70030866e-03, 1.22833272e-02, 3.54951860e-02,
#   7.32016130e-03, 1.19242447e-03, 9.24431799e-02, 7.74699664e-02,
#   0.00000000e+00, 0.00000000e+00, 0.00000000e+00, 4.49017228e-02,
#   0.00000000e+00, 7.57339678e-03, 0.00000000e+00, 0.00000000e+00,
#   9.29844827e-02, 2.54277659e-02, 1.02310134e-01, 1.29784219e-01],
#  [3.63574313e-03, 5.29381299e-03, 1.02867299e-02, 3.39045750e-02,
#   2.87916548e-03, 4.69004332e-04, 3.63597470e-02, 5.38624254e-03,
#   0.00000000e+00, 0.00000000e+00, 0.00000000e+00, 2.59138435e-02,
#   0.00000000e+00, 6.48535349e-03, 0.00000000e+00, 0.00000000e+00,
#   7.96257289e-02, 6.73443970e-02, 1.13525981e-02, 7.55923380e-02],
#  [6.64913074e-03, 9.56710753e-03, 1.91138376e-02, 6.19707458e-02,
#   3.94293811e-03, 6.42288560e-04, 4.97936755e-02, 5.80957258e-03,
#   0.00000000e+00, 0.00000000e+00, 0.00000000e+00, 1.12161843e-01,
#   0.00000000e+00, 8.58035290e-03, 0.00000000e+00, 0.00000000e+00,
#   1.05347666e-01, 7.12414996e-02, 7.18125984e-02, 2.09625907e-02]]
# total = []
# for x in total_relation_matrix:
#     for i in x:
#         i = '%.12f' % i
#         # print(x)  # 输出结果为0.00001623，输出的数据类型是字符串。%.8f表示输出结果用8位小数显示。
#
#         # 如果要拿转换后的字符串计算，需要先用float函数把字符串转换为浮点数
#         i = float(i)
#         # print(x)  # 输出1.5229999999999998e-05
#         # print('%.8f' % x)  # 输出0.00001523
#         total.append(i)



# total_relation_matrix = [1.91155209e-01, 6.19485053e-02, -4.80549622e-01, -5.35511961e-01,
#   9.30818430e-01,  2.05339171e-01,  1.17254507e-01,  7.76898190e-02,
#   6.43539462e-02,  8.52448963e-01,  7.50828116e-01, -2.60933891e+00,
#   1.32823541e+00, -1.01960409e-01,  1.65435402e+00,  6.72641677e-01,
#  -2.76821434e+00,  1.11384322e-03, -1.11506673e-01, -3.01099694e-01]
# total = []
# for i in total_relation_matrix:
#     i = '%.12f' % i
#         # print(x)  # 输出结果为0.00001623，输出的数据类型是字符串。%.8f表示输出结果用8位小数显示。
#
#         # 如果要拿转换后的字符串计算，需要先用float函数把字符串转换为浮点数
#     i = float(i)
#         # print(x)  # 输出1.5229999999999998e-05
#         # print('%.8f' % x)  # 输出0.00001523
#     total.append(i)
# print(f'总关系矩阵：{total}')
# from openpyxl import Workbook, load_workbook
# wb = load_workbook(r"C:\Users\25871\Desktop\start.xlsx")
# ws = wb.active
# ws1 = ws['C2:L26']
# print(ws1)
i = 2.365e-40
i = '%.12f' % i
        # print(x)  # 输出结果为0.00001623，输出的数据类型是字符串。%.8f表示输出结果用8位小数显示。

        # 如果要拿转换后的字符串计算，需要先用float函数把字符串转换为浮点数
i = float(i)
        # print(x)  # 输出1.5229999999999998e-05
        # print('%.8f' % x)  # 输出0.00001523
    # total.append(i)
# print(f'总关系矩阵：{total}')
print('%.12f' % i)