<p>下面的代码将标准化的<code>.txt</code>文件转换为JSON文件。唯一的问题是,有时我有300多个文件,并手动执行此操作(即更改文件末尾的编号并运行脚本太多且耗时太长。我希望自动执行此操作。您可以看到,这些文件位于一个<code>folder/directory and I am placing the JSON file in a different</code>文件夹/目录,但基本上保持命名约定的标准化,除了以<code>.txt</code>结尾之外,它以.json结尾,但前缀或文件名相同且标准化。例如:<code>CRAZY_CAT_FINAL1.TXT, CRAZY_CAT_FINAL2.TXT</code>诸如此类,一直到文件300。我如何能够自动执行并保持文件命名约定,并将文件读取和输出到不同的文件夹/目录?我已经尝试过,但似乎无法使其重复。任何帮助都将不胜感激</p>
<pre><code>import glob
import time
from glob import glob
import pandas as pd
import numpy as np
import csv
import json
csvfile = open(r'C:\Users\...\...\...\Dog\CRAZY_CAT_FINAL1.txt', 'r')
jsonfile = open(r'C:\Users\...\...\...\Rat\CRAZY_CAT_FINAL1.json', 'w')
reader = csv.DictReader(csvfile)
out = json.dumps([row for row in reader])
jsonfile.write(out)
****************************************************************************
I also have this code using the python library "requests". How do I make this code so that it uploads multiple json files with a standard naming convention? The files end with a number...
import requests
#function to post to api
def postData(xactData):
url = 'http link'
headers = {
'Content-Type': 'application/json',
'Content-Length': str(len(xactData)),
'Request-Timeout': '60000'
}
return requests.post(url, headers=headers, data=xactData)
#read data
f = (r'filepath/file/file.json', 'r')
data = f.read()
print(data)
# post data
result = postData(data)
print(result)
</code></pre>