如何將串列添加到資料框？

我知道之前有人問過這個問題，但我已經嘗試實施我找到的所有解決方案，但仍然沒有解決問題。

這是我的代碼

import csv

import pandas as pd

import helperFunctions import pandas tickers = []

f = open("watchlist.txt", "r") for i in f:
    tickers.append((helperFunctions.getTicker(i)))

head = ["Name", "Growth", "Recommendation", "Earnings Growth", "Current Ratio",
        "Total Cash", "Debt", " Revenue", "Percentage Shares Out", "Percentage Institutions", "Percentage Insiders",
        "Price to Book", "Short Ratio", "Regular Market Price"] df = pd.DataFrame() df = pd.DataFrame(columns=head) try:
    for i in tickers:
        currentTicker = []
        currentTicker.append(i.info['longName'])
        currentTicker.append(i.info['revenueGrowth'])
        currentTicker.append(i.info['recommendationKey'])
        currentTicker.append(i.info['earningsGrowth'])
        currentTicker.append(i.info['currentRatio'])
        currentTicker.append(i.info['totalCash'])
        currentTicker.append(i.info['totalDebt'])
        currentTicker.append(i.info['totalRevenue'])
        currentTicker.append(i.info['sharesPercentSharesOut'])
        currentTicker.append(i.info['heldPercentInstitutions'])
        currentTicker.append(i.info['heldPercentInsiders'])
        currentTicker.append(i.info['priceToBook'])
        currentTicker.append(i.info['shortRatio'])
        currentTicker.append(i.info['beta'])
        currentTicker.append(i.info['regularMarketPrice'])
        print(str(currentTicker   "\n"))
        '''
        # Why Don't these work??
        1.
        df.append(currentTicker)
        
        2.
        df_length = len(df)
        df.loc[df_length] = currentTicker
        
        3.
        a_series = pd.Series(currentTicker, index=df.columns)
        df = df.append(a_series, ignore_index=True)
        
        '''

except Exception as e:
    print(str(i)   repr(e))

print(df)

在串列中看到注釋的部分中，這些都是我嘗試將每次迭代添加到資料幀的所有內容。基本上監視串列是一個帶有一些代碼的 txtfile，我想獲取該資料并將其放入資料幀中，但我遇到了一些麻煩。謝謝你的時間。

uj5u.com熱心網友回復：

這就是我最終解決它的方式

import csv
import pandas as pd
import helperFunctions
import pandas
tickers = []

f = open("watchlist.txt", "r")
for i in f:
    tickers.append((helperFunctions.getTicker(i)))

head = ["Name", "Growth", "Recommendation", "Earnings Growth", "Current Ratio",
        "Total Cash", "Debt", "Revenue", "Percentage Shares Out", "Percentage Institutions", "Percentage Insiders",
        "Price to Book", "Short Ratio", "Regular Market Price"]
df = pd.DataFrame(columns=head)
try:
    for i in tickers:
        currentTicker = []
        currentTicker.append(i.info['longName'])
        currentTicker.append(i.info['revenueGrowth'])
        currentTicker.append(i.info['recommendationKey'])
        currentTicker.append(i.info['earningsGrowth'])
        currentTicker.append(i.info['currentRatio'])
        currentTicker.append(i.info['totalCash'])
        currentTicker.append(i.info['totalDebt'])
        currentTicker.append(i.info['totalRevenue'])
        currentTicker.append(i.info['sharesPercentSharesOut'])
        currentTicker.append(i.info['heldPercentInstitutions'])
        currentTicker.append(i.info['heldPercentInsiders'])
        currentTicker.append(i.info['priceToBook'])
        currentTicker.append(i.info['shortRatio'])
        currentTicker.append(i.info['beta'])
        currentTicker.append(i.info['regularMarketPrice'])

        df = df.append({'Name': currentTicker[0],
                        'Growth': currentTicker[1],
                        "Recommendation":currentTicker[2],
                        "Earnings Growth":currentTicker[3],
                        "Current Ratio": currentTicker[4],
                        "Total Cash":currentTicker[5],
                        "Debt": currentTicker[6],
                        "Revenue": currentTicker[7],
                        "Percentage Shares Out": currentTicker[8],
                        "Percentage Institutions": currentTicker[9],
                        "Percentage Insiders": currentTicker[10],
                        "Price to Book": currentTicker[11],
                        "Short Ratio": currentTicker[12],
                        "Regular Market Price": currentTicker[13],
                        },
                       ignore_index=True)
        #print(currentTicker)
except Exception as e:
    print(str(i)   repr(e))

print(df)

uj5u.com熱心網友回復：

在你的代碼的問題似乎涉及到一個事實，即currentTicker串列中有一個額外的列，即beta，這是不存在的列df。

將該列添加到head或從中洗掉后currentTicker，方法 2 和 3 將起作用。

import csv

import pandas as pd

import helperFunctions

with open("watchlist.txt", "r") as f:
    tickers = [helperFunctions.getTicker(i) for i in f]

head = [
    "Name",
    "Growth",
    "Recommendation",
    "Earnings Growth",
    "Current Ratio",
    "Total Cash",
    "Debt",
    "Revenue",
    "Percentage Shares Out",
    "Percentage Institutions",
    "Percentage Insiders",
    "Price to Book",
    "Short Ratio",
    "Regular Market Price"
]
df = pd.DataFrame(columns=head)

columns_to_extract = [
    'longName',
    'revenueGrowth',
    'recommendationKey',
    'earningsGrowth',
    'currentRatio',
    'totalCash',
    'totalDebt',
    'totalRevenue',
    'sharesPercentSharesOut',
    'heldPercentInstitutions',
    'heldPercentInsiders',
    'priceToBook',
    'shortRatio',
    # 'beta', # <- The column for this value is missing from `head`
    'regularMarketPrice'
]

currentTicker = [i.info[key] for key in columns_to_extract]

# 1. Method - THIS DOES NOT WORK
# df.append(currentTicker)

# 2. Method
df_length = len(df)
df.loc[df_length] = currentTicker

# 3. Method
a_series = pd.Series(currentTicker, index=df.columns)
df = df.append(a_series, ignore_index=True)

print(df)

標籤：Python 熊猫 列表 数据框 文件

上一篇：基于其他兩個資料框條件的Pandas新列

下一篇：將列值與資料框中的另一個值進行比較（天氣資料預測）