我最近獲取了當地健身房的數據，我正在嘗試對數據進行標準化，以便可以創建一個“健身房注冊”對象，其中包含注冊該會話的所有人員。文本文件如下所示：Sep 30th? '20 at 9:00AM Until Sep 30th? '20 at 10:00AMJD? John Doe? ??AW? Alice Wonderland? ??IM? Iron ManSep 30th? '20 at 8:00AM Until Sep 30th? '20 at 9:00AMJD? John Doe? ??AW? Alice Wonderland? ??IM? Iron Man我已經能夠使用 pandas 按列 [姓名首字母，姓名] 分隔注冊，但我不知道如何檢測何時一行對應于時間段而不是注冊的人。因此，程序運行后，每一行都應包含 [姓名首字母、姓名、時間段] 列對我來說處理這些數據最簡單的方法就是采用這種格式，JD? John Doe? ? Sep 30th? '20 at 9:00AM Until Sep 30th? '20 at 10:00AMAW? Alice Wonderland? ? Sep 30th? '20 at 9:00AM Until Sep 30th? '20 at 10:00AMIM? Iron Man? ? Sep 30th? '20 at 9:00AM Until Sep 30th? '20 at 10:00AMJD? John Doe? ? Sep 30th? '20 at 8:00AM Until Sep 30th? '20 at 9:00AMAW? Alice Wonderland? ? Sep 30th? '20 at 8:00AM Until Sep 30th? '20 at 9:00AMIM? Iron Man? ? ? Sep 30th? '20 at 8:00AM Until Sep 30th? '20 at 9:00AM我嘗試遍歷每一行，一旦出現一個時隙行，我就會將該行附加到下一行，直到出現新的時隙。def testSort():? ? with open("1-weak-gym.txt") as fp:? ? ? ? id= []? ? ? ? totalSheet=[]? ? ? ? timeSlot = []? ? ? ? lastLine=[]? ? ? ? for ln in fp:? ? ? ? ? ? if ln.startswith("Sep"): ##this is a time slot? ? ? ? ? ? ? ? timeSlot.clear()? ? ? ? ? ? ? ? timeSlot.append(ln[0:]) ##save that time slot as the lastDate variable? ? ? ? ? ? else:? ? ? ? ? ? ? ? if (timeSlot):? ? ? ? ? ? ? ? ? ? totalSheet.append(timeSlot) ##append the time slot? ? ? ? ? ? ? ? ? ? totalSheet.append(ln[0:]) ##append the name line? ? ? ? ? ? ? ? else:? ? ? ? ? ? ? ? ? ? print('Hello eror')? ? print(totalSheet, file=open("newOuput.txt","a"))?
txt 文件中有兩種不同類型的數據，我如何使用 pandas 來交互每一行并添加相應的數據
慕的地6264312
2023-09-26 14:57:28
