大家好,我有一個(gè)程序可以讀取 csv 文件并將字符串替換為數(shù)字序列,它還有其他列,如日期/時(shí)間,它必須僅為所有操作打印日期,該程序運(yùn)行良好,但我想在該程序中使用Pandas 數(shù)據(jù)框請(qǐng)有人可以使用此代碼并使用所有操作對(duì) Pandas 我對(duì) Pandas 的知識(shí)較少我會(huì)非常感謝你..謝謝這是代碼with open(tempFile, 'r',encoding="utf8") as csvfile: # creating a csv reader object reader = csv.DictReader(csvfile, delimiter=',') # next(reader, None) '''We then restructure the data to be a set of keys with list of values {key_1: [], key_2: []}:''' data = {} for row in reader: # print(row) for header, value in row.items(): try: data[header].append(value) except KeyError: data[header] = [value] '''Next we want to give each value in each list a unique identifier.''' # Loop through all keys for key in data.keys(): values = data[key] things = list(sorted(set(values), key=values.index)) for i, x in enumerate(data[key]): if data[key][i] == "": data[key][i] = datetime.datetime.now().isoformat()with open('ram5.csv', "w") as outfile: writer = csv.writer(outfile) # Write headers writer.writerow(data.keys()) # Make one row equal to one value from each list rows = zip(*data.values()) # Write rows writer.writerows(rows)注意:空的日期/時(shí)間列被替換為當(dāng)前日期......所以在這個(gè)程序中我得到了所有所需的數(shù)據(jù),上面的輸出是我編寫的程序的輸出。 但是想使用 Pandas 數(shù)據(jù)框編寫整個(gè)程序..請(qǐng)幫助伙計(jì)們,任何幫助都是可觀的..thnx
添加回答
舉報(bào)
0/150
提交
取消