How to extract comments with data using pandas?

Question

normally when we use the read function we get data only we don't get comments, sometimes those comments are also important for analysis, so any heads up would be helpful. Thank You

what read() function? they exist in many libraries.... if you mean pandas.pydata.org/pandas-docs/stable/reference/api/… it will read all data, if some of the columns are comments they will be read — Rob Raymond
– Rob Raymond, Commented Jun 13, 2021 at 8:35

Vikram Karthic · Accepted Answer · 2021-06-13 09:43:47Z

1

comments normally are on few random cell, hence you may have to loop through rows and cells to capture comments and Pandas may not help you, you may use openpyxl to do this

from openpyxl import load_workbook

workbook = load_workbook('yourexcel.xlsx')
sheet1 = workbook.get_sheet_names()[0]
worksheet = workbook.get_sheet_by_name(sheet1)

for row in worksheet.iter_rows():
    for cell in row:
        if cell.comment:
            print(cell.comment.text)

answered Jun 13, 2021 at 9:43

Vikram Karthic

4784 silver badges19 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

chinna venkat Over a year ago

okay seems a bit helpful, but I can't see my data and without data, there it's difficult looking|extracting the comments.

Collectives™ on Stack Overflow

How to extract comments with data using pandas?

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related