Programmiererforum

import pandas as pd
import numpy as np
import os

df=pd.read_csv('data.csv', header=0)
with pd.ExcelWriter('Mergeddata.xlsx', engine="openpyxl", mode='a', if_sheet_exists='overlay') as writer:
df.to_excel(writer, sheet_name='Sheet1',startcol=3,startrow=1,index=False)

Ich versuche, die Daten in [b] Daten zu kopieren. Mit dem folgenden Code kann ich die Daten in die spezifischen Zellen schreiben. < /P>
[code]import pandas as pd
import numpy as np
import os

df=pd.read_csv('data.csv', header=0)
with pd.ExcelWriter('Mergeddata.xlsx', engine="openpyxl", mode='a', if_sheet_exists='overlay') as writer:
df.to_excel(writer, sheet_name='Sheet1',startcol=3,startrow=1,index=False)
[/code]
Data.csv(Initial content)[/b]enter image description here [b]data that needs to copy:[/b]
90.77 90.7 90.8 81 69.3 90 0.72 0.71 0.72 64.46 90 64.54 63.64 65 5808.68 90 0.98 [b]0.98[/b] [b]0.98[/b] 88.24 [b]90[/b]
[b]Initial data(MergeData.xlsx) :[/b]
Time NE Index DuVoltageAvg(V) DuVoltageMin(V) DuVoltageMax(V) DuVoltageTot(V) DuVoltageCnt(count) DuCurrentAvg(A) DuCurrentMin(A) DuCurrentMax(A) DuCurrentTot(A) DuCurrentCnt(count) DuPowerAvg(W) DuPowerMin(W) DuPowerMax(W) DuPowerTot(W) DuPowerCnt(count) PowerFactorAvg(PF) PowerFactorMin(PF) PowerFactorMax(PF) PowerFactorTot(PF) PowerFactorCnt(count)
2025-06-08 15:15 SC_401B ShelfID0/SlotID0 90.73 90.6 90.8 8165.7 90 0.72 0.71 0.72 64.44 90 64.46 63.64 65.45 5801.3 90 0,98 0,98 0,98 88,24 90
[b] Daten nach Excelwriter (mergedata.xlsx): [/b]
Bildbeschreibung hier
Bildbeschreibung hier
90,0,1 64,54 63,64 65,0 5808.68 [b] 90,0,2 [/b] 0,98 [b] 0,98,1 [/b] [b] 0,98,2 [/b] 88.24 90.0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 sich, Dezimalpunkte kamen in den Zellwerten. Nöte Hilfe bei diesem [url=viewtopic.php?t=26065]Problem[/url]