我在用 _ 分割數(shù)據框并從中創(chuàng)建新列時遇到問題。原來的股AMAT_0000006951_10Q_20200726_Item1A_excerpt.txt as section我當前的代碼df = pd.DataFrame(myList,columns=['section','text'])#df['text'] = df['text'].str.replace('?','')df['section'] = df['section'].str.replace('Item1A', 'Filing Section: Risk Factors')df['section'] = df['section'].str.replace('Item2_', 'Filing Section: Management Discussion and Analysis')df['section'] = df['section'].str.replace('excerpt.txt', '').str.replace(r'\d{10}_|\d{8}_', '')df.to_csv("./SECParse.csv", encoding='utf-8-sig', sep=',',index=False)輸出：section textAMAT_10Q_Filing Section: Risk Factors_ The COVID-19 pandemic and global measures taken in response thereto have adversely impacted, and may continue to adversely impact, Applied’s operations and financial results.AMAT_10Q_Filing Section: Risk Factors_ The COVID-19 pandemic and measures taken in response by governments and businesses worldwide to contain its spread, AMAT_10Q_Filing Section: Risk Factors_ The degree to which the pandemic ultimately impacts Applied’s financial condition and results of operations and the global economy will depend on future developments beyond our control我真的很想以某種方式拆分“部分”，將其放入基于“_”的新列中我已經嘗試了許多不同的正則表達式變體來拆分“部分”，并且所有這些都給了我沒有填充的標題或者他們在部分和文本之后添加了列，這是沒有用的。我還應該補充一下，大約有 100,000 個觀察結果。期望的結果：Ticker Filing type Section TextAMAT 10Q Filing Section: Risk Factors The COVID-19 pandemic and global measures taken in response 任何指導將不勝感激。
1 回答
jeck貓
TA貢獻1909條經驗 獲得超7個贊
如果您始終知道分割數(shù)，您可以執(zhí)行以下操作：
import pandas as pd
df = pd.DataFrame({ "a": [ "test_a_b", "test2_c_d" ] })
# Split column by "_"
items = df["a"].str.split("_")
# Get last item from splitted column and place it on "b"
df["b"] = items.apply(list.pop)
# Get next last item from splitted column and place it on "c"
df["c"] = items.apply(list.pop)
# Get final item from splitted column and place it on "d"
df["d"] = items.apply(list.pop)
這樣，數(shù)據框將變成
a b c d
0 test_a_b b a test
1 test2_c_d d c test2
由于您希望列按特定順序排列，因此可以對數(shù)據框的列重新排序，如下所示：
>>> df = df[[ "d", "c", "b", "a" ]]
>>> df
d c b a
0 test a b test_a_b
1 test2 c d test2_c_d
添加回答
舉報
0/150
提交
取消