BUG: to_clipboard raises an error with null values in data frame

[BabakAmini]

With the latest version of pandas installed on windows, running the following code will raise an error:

df = pd.DataFrame(['\x00'])
df.to_clipboard(index=False, excel=False)

Here is the traceback:

ArgumentError Traceback (most recent call last)

in
1 df = pd.DataFrame(['\x00'])
----> 2 df.to_clipboard(index=False, excel=False)

e:\Anaconda\lib\site-packages\pandas\core\generic.py in to_clipboard(self, excel, sep, **kwargs)
3023 from pandas.io import clipboards
3024
-> 3025 clipboards.to_clipboard(self, excel=excel, sep=sep, **kwargs)
3026
3027 @Final

e:\Anaconda\lib\site-packages\pandas\io\clipboards.py in to_clipboard(obj, excel, sep, **kwargs)
143 else:
144 objstr = str(obj)
--> 145 clipboard_set(objstr)

e:\Anaconda\lib\site-packages\pandas\io\clipboard_init_.py in lazy_load_stub_copy(text)
631 global copy, paste
632 copy, paste = determine_clipboard()
--> 633 return copy(text)
634
635

e:\Anaconda\lib\site-packages\pandas\io\clipboard_init_.py in copy_windows(text)
454 # the object must have been allocated using the
455 # function with the GMEM_MOVEABLE flag.
--> 456 count = wcslen(text) + 1
457 handle = safeGlobalAlloc(GMEM_MOVEABLE, count * sizeof(c_wchar))
458 locked_handle = safeGlobalLock(handle)

e:\Anaconda\lib\site-packages\pandas\io\clipboard_init_.py in call(self, *args)
306
307 def call(self, *args):
--> 308 ret = self.f(*args)
309 if not ret and get_errno():
310 raise PyperclipWindowsException("Error calling " + self.f.name)

ArgumentError: argument 1: <class 'ValueError'>: embedded null character

[mzeitlin11]

Thanks for reporting this @BabakAmini. Can you please post a reproducible example (https://matthewrocklin.com/blog/work/2018/02/28/minimal-bug-reports)?

Can you also please try on the latest version (1.3.2)? There are some fixes which might have fixed your issue (like #41109)

[BabakAmini]

Thanks for the reply @mzeitlin11. I've upgraded to the latest version but still got the same error. Below is the code to reproduce it:

import json
import pandas as pd
import requests

r = requests.get("http://cdn.tsetmc.com/api/Trade/GetTradeHistory/23086515493897579/20210831/false")
js = json.loads(r.text.replace("'", "\""))
df = pd.json_normalize(js['tradeHistory'])
df.to_clipboard(index=False, excel=False)

The problem is with the column named iSensVarP. This column contains NULL (\x00) in all rows.

[mzeitlin11]

Thanks for checking! I can't reproduce this on macOS, so perhaps a windows specific issue? Would you mind trying to simplify the failing example to not use requests or json? For example, something along the lines of

df = pd.DataFrame(['\x00'])
df.to_clipboard(index=False, excel=False)

would be a nicer reproducer (if that fails or something similar) to ensure the issue is only with presence of \x00. But I can't check this since it doesn't fail for me :)

[BabakAmini]

I just copied your sample code and got the same error.

[mzeitlin11]

Thanks! Would you mind editing your issue body with this failing example and the traceback? Further investigations to fix welcome!

[Hossein1399]

Hi! I use windows 10 and Python 3.8 and PyCharm professional 2020.3 . My computer uses CPU Intel core I5 9600k and 8G ram.
I executed above codes and there wasn't any error and I could print the data.