DataFrame.to_clipboard() ⚬ Entries

↩ 🔵 🔵 🔵

---

Primary

၊၊||၊|။

DataFrame.to_clipboard() ⚬｜Documentation｜1st｜20251021235925-00-⌔

pandas.DataFrame.to_clipboard — pandas 2.3.3 documentation#pandas.DataFrame.to_clipboard

DataFrame.to_clipboard(﹡, excel=True, sep=None, ﹡﹡kwargs)

Copy object to the system clipboard.

Write a text representation of object to the system clipboard. This can be pasted into Excel, for example.

Parameters:

excel: bool, default True

Produce output in a csv format for easy pasting into excel.

• True, use the provided separator for csv pasting.
• False, write a string representation of the object to the clipboard.

sep: str, default '\t'

Field delimiter.

﹡﹡kwargs

These parameters will be passed to DataFrame.to_csv.

See also:

DataFrame.to_csv

Write a DataFrame to a comma-separated values (csv) file.

read_clipboard

Read text from clipboard and pass to read_csv.

Notes:

Requirements for your platform.

• Linux: xclip, or xsel (with PyQt4 modules)
• Windows: none
• macOS: none

This method uses the processes developed for the package pyperclip. A solution to render any output string format is given in the examples.

Examples:

Copy the contents of a DataFrame to the clipboard.

>>> df = pd.DataFrame([[1, 2, 3], [4, 5, 6]], columns=["A", "B", "C"])

>>> df.to_clipboard(sep=",")
... # Wrote the following to the system clipboard:
... # ,A,B,C
... # 0,1,2,3
... # 1,4,5,6

We can omit the index by passing the keyword index and setting it to false.

>>> df.to_clipboard(sep=",", index=False)
... # Wrote the following to the system clipboard:
... # A,B,C
... # 1,2,3
... # 4,5,6

Using the original pyperclip package for any string output format.

import pyperclip
 
html = df.style.to_html()
pyperclip.copy(html)

Printed 2026-06-28.

(echo:: @ ᯤ)

Link to original

Secondary

• • •

---