擅长:python、mysql、java
<p>假设您有一个表,您想保存标题<strong>驱动器id</strong>和<strong>角色<strong>
它们保存在数据帧df1中
要遍历您的行并创建一个新表,我更喜欢使用dict列表</p>
<pre><code>out_table = []
for index, row in df1.iterrows()
drive_id = row["drive id"]
if row["role"]=="follower":
out_row ={}
out_row["drive_id"]= drive_id
out_row["task name"] = "rotate rev"
out_row["description"] = "check rotate hmi"
out_row["comment"] = "NA"
out_table.append(out_row)
#this is the end of the first row, so on you add all the rows for this role
out_row ={}
out_row["drive_id"] = driver_id
out_row["task name"] = "rotate fwd"
out_row["description"] = "check hdmi for footlock"
out_row["comment"] = ""
out_table.append(out_row)
if row["role"] == "FOLLOWER"
# here you add all the rows for this role
df2 = pd.DataFrame(out_table) # this makes a dataframe where the dict keys are the table headers
df2.to_excel(r"D:\drive_table.xlsx")
</code></pre>