with open() error 22 (windows path)

Question

I have trouble getting the following code to work:

path = "C:\\Users\\jiversen\\Documents\\Jsons\\"+jsonName+'.json'

with open(path,'w') as outfile:
        json.dump(df,outfile)

I get the following error:

OSError                                   Traceback (most recent call last)
<ipython-input-162-ad4856eeb7ee> in <module>()
      7 #path = r "C:\Users\jiversen\Documents\CosmosDB Simulator\Jsons\"+jsonName+'.json'
      8 
----> 9 with open(abs_file_path,'w') as outfile:
     10         json.dump(df,outfile)

OSError: [Errno 22] Invalid argument: 'C:\\Users\\jiversen\\Documents\\Jsons\\2018.04.06 12:00:00.000.json'

I have tried the following ways to create the path:

1

path = "C:\Users\jiversen\Documents\Jsons\"+jsonName+'.json'

this produces the following error:

File "<ipython-input-166-405d2aae6e9c>", line 7
    path = "C:\Users\jiversen\Documents\Jsons\"+jsonName+'.json'
                                                                ^
SyntaxError: EOL while scanning string literal

2

path = R"C:\Users\jiversen\Documents\Jsons\"+jsonName+'.json'

this produces the folling error:

File "<ipython-input-167-ff5d5da61135>", line 7
    path = R"C:\Users\jiversen\Documents\Jsons\"+jsonName+'.json'
                                                                 ^
SyntaxError: EOL while scanning string literal

3

    import os
    script_dir = os.path.abspath('C:\\Users\\jiversen\\Documents\\jsons\\') # i.e. /path/to/dir/foobar.py
    rel_path = 'Jsons\\'+jsonName+'.json'
    abs_file_path = os.path.join(script_dir, rel_path)

this produces the folling error:

OSError                                   Traceback (most recent call last)
<ipython-input-168-d286c1f58b6a> in <module>()
      7 #path = R"C:\Users\jiversen\Documents\Jsons\"+jsonName+'.json'
      8 
----> 9 with open(path,'w') as outfile:
     10         json.dump(df,outfile)

OSError: [Errno 22] Invalid argument: 'C:\\Users\\jiversen\\Documents\\Jsons\\2018.04.06 12:00:00.000.json'

4 no subdir and no spaces

with open(jsonName+'.json','w') as outfile:
        json.dump(df,outfile)

this produces the following error:

OSError                                   Traceback (most recent call last)
<ipython-input-173-818eaaa66077> in <module>()
      6 path = 'C:\\Users\\jiversen\\Documents\\Jsons\\'+jsonName+'.json'
      7 
----> 8 with open(jsonName+'.json','w') as outfile:
      9         json.dump(df,outfile)

OSError: [Errno 22] Invalid argument: '2018.04.06-12:00:00.000.json'

Aditional info

I have copy pasted the path, and made sure over and over it exists (C:\Users\jiversen\Documents\Jsons)

I work in jupyter-notebook

Response to deepspace

OSError                                   Traceback (most recent call last)
<ipython-input-177-f09b6b3b06fe> in <module>()
     10 # C:\Users\jiversen\Documents\Jsons\2018.04.06-12:00:00.000.json
     11 
---> 12 with open(full_path, 'w') as outfile:
     13     json.dump(df, outfile)

OSError: [Errno 22] Invalid argument: 'C:\\Users\\jiversen\\Documents\\Jsons\\2018.04.06-12:00:00.000.json'

Answer 1

Windows does not allow a colon (:) in file names.

Try

import os

jsonName = '2018.04.06-12.00.00.000'
#                        ^  ^  No colons!

path = r'C:\Users\jiversen\Documents\Jsons'
file_name = '{}.json'.format(jsonName)
full_path = os.path.join(path, file_name)

print(full_path)
# C:\Users\jiversen\Documents\Jsons\2018.04.06-12.00.00.000.json

with open(full_path, 'w') as outfile:
    json.dump(df, outfile)