Series.to_clipboard(excel=True, sep=None, **kwargs)
[source]
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
sep : str, default Field delimiter. **kwargs These parameters will be passed to DataFrame.to_csv. |
---|
See also
DataFrame.to_csv
read_clipboard
Requirements for your platform.
xclip
, or xsel
(with gtk
or PyQt4
modules)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 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
© 2008–2012, AQR Capital Management, LLC, Lambda Foundry, Inc. and PyData Development Team
Licensed under the 3-clause BSD License.
http://pandas.pydata.org/pandas-docs/version/0.23.4/generated/pandas.Series.to_clipboard.html