时间戳

首页 > 解决方案 > ndarray 到表（从阶跃函数结果）

python - ndarray 到表（从阶跃函数结果）

问题描述

我正在研究生存函数，作为输出，我在 ndarray 中得到了这个概率

   array([StepFunction(x=array([ 0,  1,  2,  3,  4,  5,  6,  7,  8,  9, 10, 11, 12, 13, 14, 15, 16,
       17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33,
       34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47]), y=array([9.17296785e-01, 8.58509959e-01, 7.95751449e-01, 7.23932861e-01,
       6.72942004e-01, 6.18755675e-01, 5.57276831e-01, 5.13920939e-01,
       4.68160907e-01, 4.16574744e-01, 3.80432714e-01, 3.42539970e-01,
       3.00064379e-01, 2.70472496e-01, 2.39721587e-01, 2.05666153e-01,
       1.82207637e-01, 1.58125975e-01, 1.31987128e-01, 1.14216290e-01,
       9.63014259e-02, 7.73126310e-02, 6.47332309e-02, 5.23714045e-02,
       3.96594097e-02, 3.14924449e-02, 2.37709655e-02, 1.70021158e-02,
       1.30073223e-02, 9.69078403e-03, 6.66962927e-03, 4.98463919e-03,
       3.47434981e-03, 2.20675133e-03, 1.50212153e-03, 9.34847760e-04,
       5.32180234e-04, 3.43887595e-04, 1.95095396e-04, 1.02772900e-04,
       5.78492414e-05, 3.44687086e-05, 1.84070989e-05, 8.30616036e-06,
       2.61503613e-06, 5.73250479e-07, 6.00917151e-08, 2.59960925e-09]))],
      dtype=object)

我想将此结果转换为这样的表，其中包含 x、y1、y2 等列（手动显示示例）

预期表

标签： pythonarraysnumpy

解决方案

看起来您需要将 numpy 数组转换为 xls 文件？如果是这样，一种方法是从 Pandas 设施中获得帮助。

import pandas as pd

## convert your array into a dataframe
df = pd.DataFrame (array)

## save to xlsx file

filepath = 'my_excel_file.xlsx'

df.to_excel(filepath, index=False)

推荐阅读