python处理excel的问题

Question

对于一个这样的excel文件，

我现在想要做的是讲RevisionID相同的行合并到一块进行数据的处理。请问该如何弄、

Answer 1

Assume that the original excel has been sorted according to id:

import pandas as pd
table = pd.read_excel(r"....your file path")
rid = list(table['RevisionID'])
did = []
for i in range(len(table)-1):
    if rid[i] == rid[i+1]:
        did.append(i)
for i in did:
    del table[i:i+1]
pd.to_excel(r'...new file path')

After execution, a new excel will be formed listing the content you want.

Answer 2

You can consider converting it to a csv file, and then just open the file for processing

Answer 3

Reference material http://bbs.bathome.net/thread-39568-1-1....

Answer 4

Research the xlrd library, or how to use python to modify .csv files (just convert .xlsx/.xls files into csv). There is also an openpyxl library, but it should not be able to merge as you require.

Answer 5

Thought:

Use an array to record rows with the same ID, and then use another library to merge them