Python按列和按行读取数据

def data_transform(heading, value):
  """
    按列读取
  """
    data_length = len(value)
    ticker_length =len(heading)-1
    value_list=[]
    ticker_list =[]
    date_list =[]
    for i in range(ticker_length):
        value_list.extend(value[:,i+1]) //按列读取
        date_list.extend(value[:,0])
        ticker =repeat(heading[i+1], data_length)
        ticker_list.extend(ticker)
    
    length = len(value_list)
    ticker_list =np.array(ticker_list).reshape(length,1)
    date_list = np.array( date_list).reshape(length,1)
    value_list = np.array(value_list).reshape(length,1)
    list_con = np.concatenate((ticker_list, date_list),axis=1) //数组连接
    
    list_con = np.concatenate((list_con, value_list), axis=1)
    #print(list_con)
    #print(len(value_list))
    #print(len(date_list))
    return list_con



 """
    按行读取
  """

def data_transform(heading, value):
  
    data_length = len(value)
    ticker_length =len(heading)-1
    value_list=[]
    ticker_list =[]
    date_list =[]
    for i in range(ticker_length):
        value_list.extend(value[i+1]) //按行读取
        date_list.extend(value[:,0])
        ticker =repeat(heading[i+1], data_length)
        ticker_list.extend(ticker)
    
    length = len(value_list)
    ticker_list =np.array(ticker_list).reshape(length,1)
    date_list = np.array( date_list).reshape(length,1)
    value_list = np.array(value_list).reshape(length,1)
    list_con = np.concatenate((ticker_list, date_list),axis=1) //数组连接
    
    list_con = np.concatenate((list_con, value_list), axis=1)
    #print(list_con)
    #print(len(value_list))
    #print(len(date_list))
    return list_con

 

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值