copy pandas Excel Dataframe to clipboard without index header

Question

I have an Excel file from Where I have to copy some subset of data to the clipboard so that I can paste it to any place. I am using pandas DataFrame.to_clipboard(excel=True, sep=None, **kwargs) function but I don't want index headers to be copied.

What it is copying is this:

What I want to copy is this only:

Dharman · Accepted Answer · 2021-08-12 14:43:47Z

14

you have to pass two parameters for that : index and header.

DataFrame.to_clipboard(excel=True, sep=None, index=False, header=None)

edited Aug 12, 2021 at 14:43

Dharman♦

33.9k27 gold badges105 silver badges157 bronze badges

answered Aug 12, 2021 at 14:37

Sherar MDP

3212 silver badges7 bronze badges

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

Collectives™ on Stack Overflow

copy pandas Excel Dataframe to clipboard without index header

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related