使用 Pandas 刪除 DataFrame 的幾行后，標題不會改變；它保持行被刪除之前的狀態。我怎樣才能得到更新的標題？for row in range(rowStart): # rowStart is my index (int). It means it should drop all rows up to this df.drop(row, inplace=True)df = df.reset_index(drop=True)header = list(df) # even assigning the header after the drop, it keeps returning the same as beforeprint(header)print('')print(df) # the DataFrame is ok, without the removed rows (as expected)最小的例子：data = { '': '', 'asd': '', 'bfdgfd': '', 'trytr': '', 'jlhj': '', 'Job': 'Revenue', 'abc123': 1000.00, 'hey098': 2000.00}df = pd.DataFrame(data.items(), columns=['Unnamed: 0', 'Unnamed: 1'])header = list(df)print(header)print('')print(df)startRow = 5for row in range(startRow): df.drop(row, inplace=True)df = df.reset_index(drop=True)header = list(df)print(header)print('')print(df)
1 回答
ABOUTYOU
TA貢獻1812條經驗 獲得超5個贊
在熊貓中，“標題”是列的名稱，與數據框中的數據分開存儲。根據您的意見，我認為您需要先更改列名，然后刪除行。
import pandas as pd
data = {
'': '',
'asd': '',
'bfdgfd': '',
'trytr': '',
'jlhj': '',
'Job': 'Revenue',
'abc123': 1000.00,
'hey098': 2000.00
}
df = pd.DataFrame(data.items(),
columns=['Unnamed: 0', 'Unnamed: 1'])
startRow = 5
df.columns = df.loc[startRow].to_list() # set the "header" to the values in this row
df = df.loc[startRow+1:].reset_index(drop=True) # select only the rows you want
在這段代碼之后，df 將是：
Job Revenue
0 abc123 1000
1 hey098 2000
添加回答
舉報
0/150
提交
取消