2023年6月22日 13:57:38go评论72阅读模式

英文:

how to replace specific spaces with new line using python script?

问题

问题可能出在你的正则表达式替换模式中的双反斜杠 \1 和 \2 上。在 Python 的正则表达式中，捕获组的引用应该是单反斜杠 \1 和 \2，而不是双反斜杠 \\1 和 \\2。所以，你需要将正则表达式模式的替换部分中的双反斜杠改为单反斜杠。

以下是已更正的代码：

import os
import re

# Define the directory path where the text files are located
directory = r'E:\Desktop\Copy'

# Define the regex patterns and their replacements
patterns = [
    (r'\(Netherlands\) \(United States\)', r'\n'),
    (r'\(United States\) \(Portugal\)', r'\n'),
    # ... 还有其他的模式
]

# Iterate over the files in the directory
for filename in os.listdir(directory):
    if filename.endswith('.txt'):
        file_path = os.path.join(directory, filename)

        # Read the contents of the file
        with open(file_path, 'r', encoding='utf-8') as file:
            contents = file.read()

        # Apply the regex replacements
        for pattern, replacement in patterns:
            contents = re.sub(pattern, replacement, contents)

        # Write the modified contents back to the file
        with open(file_path, 'w', encoding='utf-8') as file:
            file.write(contents)

print("Replacements completed.")

通过将替换模式中的 \1 和 \2 更改为单反斜杠，应该能够成功运行脚本并将所需的替换应用到文本文件中。

英文:

I have about 3000 number of txt files in a folder directory and now i want to replace some spaces in txt files with new line.
for example:

Ottoman Empire Spain
Japan Sweden
United States Tuscany
Brazil United States
Mexico United States
United States Brazil
United States Mexico
Romania Belgium
Spain Sweden
Spain United States
Sweden Belgium
Japan Kingdom of Italy

i want to convert above list to following:

Ottoman Empire
Spain
Japan
Sweden
United States
Tuscany
Brazil
United States
Mexico
United States
United States
Brazil
United States
Mexico
Romania
Belgium
Spain
Sweden
Spain
United States
Sweden
Belgium
Japan
Kingdom of Italy

I written following script for it:

import os
import re
# Define the directory path where the text files are located
directory = r&#39;E:\Desktop\Copy&#39;
# Define the regex patterns and their replacements
patterns = [
(r&#39;\(Netherlands\) \(United States\)&#39;, r&#39;\\1\n\\2&#39;),
(r&#39;\(United States\) \(Portugal\)&#39;, r&#39;\\1\n\\2&#39;),
(r&#39;\(United States\) \(Greece\)&#39;, r&#39;\\1\n\\2&#39;),
(r&#39;\(United States\) \(Romania\)&#39;, r&#39;\\1\n\\2&#39;),
(r&#39;\(Baden\) \(Tuscany\)&#39;, r&#39;\\1\n\\2&#39;),
(r&#39;\(Portugal\) \(United States\)&#39;, r&#39;\\1\n\\2&#39;),
(r&#39;\(Netherlands\) \(Romania\)&#39;, r&#39;\\1\n\\2&#39;),
(r&#39;\(Ottoman Empire\) \(Spain\)&#39;, r&#39;\\1\n\\2&#39;),
(r&#39;\(Japan\) \(Sweden\)&#39;, r&#39;\\1\n\\2&#39;),
(r&#39;\(United States\) \(Tuscany\)&#39;, r&#39;\\1\n\\2&#39;),
(r&#39;\(Brazil\) \(United States\)&#39;, r&#39;\\1\n\\2&#39;),
(r&#39;\(Mexico\) \(United States\)&#39;, r&#39;\\1\n\\2&#39;),
(r&#39;\(United States\) \(Brazil\)&#39;, r&#39;\\1\n\\2&#39;),
(r&#39;\(United States\) \(Mexico\)&#39;, r&#39;\\1\n\\2&#39;),
(r&#39;\(Romania\) \(Belgium\)&#39;, r&#39;\\1\n\\2&#39;),
(r&#39;\(Spain\) \(Sweden\)&#39;, r&#39;\\1\n\\2&#39;),
(r&#39;\(Spain\) \(United States\)&#39;, r&#39;\\1\n\\2&#39;),
(r&#39;\(Sweden\) \(Belgium\)&#39;, r&#39;\\1\n\\2&#39;),
(r&#39;\(Japan\) \(Kingdom of Italy\)&#39;, r&#39;\\1\n\\2&#39;),
(r&#39;\(Sweden\) \(Bulgaria\)&#39;, r&#39;\\1\n\\2&#39;),
(r&#39;\(Romania\) \(Sweden\)&#39;, r&#39;\\1\n\\2&#39;),
(r&#39;\(Japan\) \(Ottoman Empire\)&#39;, r&#39;\\1\n\\2&#39;),
(r&#39;\(Spain\) \(Romania\)&#39;, r&#39;\\1\n\\2&#39;),
(r&#39;\(Japan\) \(Ethiopia\)&#39;, r&#39;\\1\n\\2&#39;),
(r&#39;\(Belgium\) \(Portugal\)&#39;, r&#39;\\1\n\\2&#39;),
(r&#39;\(Japan\) \(Republic of China\)&#39;, r&#39;\\1\n\\2&#39;),
(r&#39;\(Japan\) \(Romania\)&#39;, r&#39;\\1\n\\2&#39;),
(r&#39;\(Ethiopia\) \(Yugoslavia\)&#39;, r&#39;\\1\n\\2&#39;),
(r&#39;\(Republic of China\) \(Austria-Hungary\)&#39;, r&#39;\\1\n\\2&#39;),
(r&#39;\(Sweden\) \(Portugal\)&#39;, r&#39;\\1\n\\2&#39;),
(r&#39;\(Czechoslovakia\) \(Ethiopia\)&#39;, r&#39;\\1\n\\2&#39;),
(r&#39;\(Yugoslavia\) \(Czechoslovakia\)&#39;, r&#39;\\1\n\\2&#39;),
(r&#39;\(Kingdom of Italy\) \(Russian SFSR\)&#39;, r&#39;\\1\n\\2&#39;),
(r&#39;\(Spain\) \(Yugoslavia\)&#39;, r&#39;\\1\n\\2&#39;),
(r&#39;\(Ethiopia\) \(Belgium\)&#39;, r&#39;\\1\n\\2&#39;),
(r&#39;\(Weimar Republic\) \(Yugoslavia\)&#39;, r&#39;\\1\n\\2&#39;),
(r&#39;\(N. Germany\) \(Yugoslavia\)&#39;, r&#39;\\1\n\\2&#39;),
(r&#39;\(Czechoslovakia\) \(Yugoslavia\)&#39;, r&#39;\\1\n\\2&#39;),
(r&#39;\(Romania\) \(Yugoslavia\)&#39;, r&#39;\\1\n\\2&#39;),
(r&#39;\(Kingdom of Italy\) \(Soviet Union\)&#39;, r&#39;\\1\n\\2&#39;),
(r&#39;\(Brazil\) \(Iran\)&#39;, r&#39;\\1\n\\2&#39;),
(r&#39;\(Brazil\) \(Greece\)&#39;, r&#39;\\1\n\\2&#39;),
(r&#39;\(Greece\) \(Brazil\)&#39;, r&#39;\\1\n\\2&#39;),
(r&#39;\(Brazil\) \(Afghanistan\)&#39;, r&#39;\\1\n\\2&#39;),
(r&#39;\(Afghanistan\) \(Mexico\)&#39;, r&#39;\\1\n\\2&#39;),
(r&#39;\(Kingdom of Italy\) \(New Zealand\)&#39;, r&#39;\\1\n\\2&#39;),
(r&#39;\(Saxony\) \(Baden\)&#39;, r&#39;\\1\n\\2&#39;),
(r&#39;\(Poland\) \(Yugoslavia\)&#39;, r&#39;\\1\n\\2&#39;),
(r&#39;\(Poland\) \(Romania\)&#39;, r&#39;\\1\n\\2&#39;),
(r&#39;\(Poland\) \(North Korea\)&#39;, r&#39;\\1\n\\2&#39;),
(r&#39;\(Poland\) \(Brazil\)&#39;, r&#39;\\1\n\\2&#39;),
(r&#39;\(Pakistan\) \(Italy\)&#39;, r&#39;\\1\n\\2&#39;),
(r&#39;\(Czechoslovakia\) \(Romania\)&#39;, r&#39;\\1\n\\2&#39;),
(r&#39;\(Spain\) \(Poland\)&#39;, r&#39;\\1\n\\2&#39;),
(r&#39;\(India\) \(Yugoslavia\)&#39;, r&#39;\\1\n\\2&#39;),
(r&#39;\(Italy\) \(Poland\)&#39;, r&#39;\\1\n\\2&#39;),
(r&#39;\(Czechoslovakia\) \(North Korea\)&#39;, r&#39;\\1\n\\2&#39;),
(r&#39;\(Czechoslovakia\) \(Poland\)&#39;, r&#39;\\1\n\\2&#39;),
(r&#39;\(Italy\) \(North Korea\)&#39;, r&#39;\\1\n\\2&#39;),
(r&#39;\(Czechoslovakia\) \(Indonesia\)&#39;, r&#39;\\1\n\\2&#39;),
(r&#39;\(Spain\) \(North Korea\)&#39;, r&#39;\\1\n\\2&#39;),
(r&#39;\(Italy\) \(Yugoslavia\)&#39;, r&#39;\\1\n\\2&#39;),
(r&#39;Indonesia \(West Germany\)&#39;, r&#39;\\1\n\\2&#39;),
(r&#39;\(Portugal\) \(Denmark\)&#39;, r&#39;\\1\n\\2&#39;),
(r&#39;\(United States\) \(Baden\)&#39;, r&#39;\\1\n\\2&#39;),
(r&#39;\(Spain\) \(Italy\)&#39;, r&#39;\\1\n\\2&#39;),
(r&#39;\(Spain\) \(Indonesia\)&#39;, r&#39;\\1\n\\2&#39;),
(r&#39;\(West Germany\) \(Czechoslovakia\)&#39;, r&#39;\\1\n\\2&#39;),
(r&#39;\(Soviet Union\) \(United States\)&#39;, r&#39;\\1\n\\2&#39;),
(r&#39;\(West Germany\) \(Spain\)&#39;, r&#39;\\1\n\\2&#39;),
(r&#39;\(North Korea\) \(Yugoslavia\)&#39;, r&#39;\\1\n\\2&#39;),
(r&#39;\(K. Two Sicilies\) \(Netherlands\)&#39;, r&#39;\\1\n\\2&#39;),
(r&#39;\(Brazil\) \(Saxony\)&#39;, r&#39;\\1\n\\2&#39;),
(r&#39;\(Spain\) \(Vietnam\)&#39;, r&#39;\\1\n\\2&#39;),
(r&#39;\(North Korea\) \(Spain\)&#39;, r&#39;\\1\n\\2&#39;),
(r&#39;\(Mexico\) \(Brazil\)&#39;, r&#39;\\1\n\\2&#39;),
(r&#39;\(West Germany\) \(North Korea\)&#39;, r&#39;\\1\n\\2&#39;),
(r&#39;\(Brazil\) \(Egypt\)&#39;, r&#39;\\1\n\\2&#39;),
(r&#39;\(Pakistan\) \(Brazil\)&#39;, r&#39;\\1\n\\2&#39;),
(r&#39;\(West Germany\) \(Brazil\)&#39;, r&#39;\\1\n\\2&#39;),
(r&#39;\(Italy\) \(Brazil\)&#39;, r&#39;\\1\n\\2&#39;),
(r&#39;\(Brazil\) \(Spain\)&#39;, r&#39;\\1\n\\2&#39;),
(r&#39;\(Italy\) \(Taiwan\)&#39;, r&#39;\\1\n\\2&#39;),
(r&#39;\(Egypt\) \(Taiwan\)&#39;, r&#39;\\1\n\\2&#39;),
(r&#39;\(Egypt\) \(Brazil\)&#39;, r&#39;\\1\n\\2&#39;),
(r&#39;\(Pakistan\) \(Taiwan\)&#39;, r&#39;\\1\n\\2&#39;),
(r&#39;\(Portugal\) \(Belgium\)&#39;, r&#39;\\1\n\\2&#39;),
(r&#39;\(Iraq\) \(South Korea\)&#39;, r&#39;\\1\n\\2&#39;),
(r&#39;\(Pakistan\) \(Poland\)&#39;, r&#39;\\1\n\\2&#39;),
(r&#39;\(Pakistan\) \(Egypt\)&#39;, r&#39;\\1\n\\2&#39;),
(r&#39;\(Italy\) \(West Germany\)&#39;, r&#39;\\1\n\\2&#39;),
(r&#39;\(Portugal\) \(Sweden\)&#39;, r&#39;\\1\n\\2&#39;),
(r&#39;\(Iran\) \(France\)&#39;, r&#39;\\1\n\\2&#39;),
(r&#39;\(Italy\) \(Egypt\)&#39;, r&#39;\\1\n\\2&#39;),
(r&#39;\(Iran\) \(Egypt\)&#39;, r&#39;\\1\n\\2&#39;),
(r&#39;\(India\) \(North Korea\)&#39;, r&#39;\\1\n\\2&#39;),
(r&#39;\(Ukraine\) \(Egypt\)&#39;, r&#39;\\1\n\\2&#39;),
(r&#39;\(Iran\) \(Ukraine\)&#39;, r&#39;\\1\n\\2&#39;),
(r&#39;\(Taiwan\) \(Egypt\)&#39;, r&#39;\\1\n\\2&#39;),
(r&#39;\(Italy\) \(Iraq\)&#39;, r&#39;\\1\n\\2&#39;),
(r&#39;\(Iraq\) \(France\)&#39;, r&#39;\\1\n\\2&#39;),
(r&#39;\(Myanmar\) \(Taiwan\)&#39;, r&#39;\\1\n\\2&#39;),
(r&#39;\(Syria\) \(Taiwan\)&#39;, r&#39;\\1\n\\2&#39;),
(r&#39;\(Iraq\) \(Myanmar\)&#39;, r&#39;\\1\n\\2&#39;),
(r&#39;\(Indonesia\) \(Thailand\)&#39;, r&#39;\\1\n\\2&#39;),
(r&#39;\(Iraq\) \(Vietnam\)&#39;, r&#39;\\1\n\\2&#39;),
(r&#39;\(Brazil\) \(Indonesia\)&#39;, r&#39;\\1\n\\2&#39;),
(r&#39;\(Indonesia\) \(France\)&#39;, r&#39;\\1\n\\2&#39;),
(r&#39;\(Egypt\) \(Myanmar\)&#39;, r&#39;\\1\n\\2&#39;),
(r&#39;\(Saxony\) \(United States\)&#39;, r&#39;\\1\n\\2&#39;),
(r&#39;\(Saudi Arabia\) \(Thailand\)&#39;, r&#39;\\1\n\\2&#39;),
(r&#39;\(Iran\) \(South Korea\)&#39;, r&#39;\\1\n\\2&#39;),
(r&#39;\(K. Two Sicilies\) \(Denmark\)&#39;, r&#39;\\1\n\\2&#39;),
(r&#39;\(Kingdom of Hanover\) \(United States\)&#39;, r&#39;\\1\n\\2&#39;),
(r&#39;\(Netherlands\) \(Mexico\)&#39;, r&#39;\\1\n\\2&#39;),
(r&#39;\(Belgium\) \(K. Two Sicilies\)&#39;, r&#39;\\1\n\\2&#39;),
(r&#39;\(United States\) \(Kingdom of Hanover\)&#39;, r&#39;\\1\n\\2&#39;),
(r&#39;\(United States\) \(Denmark\)&#39;, r&#39;\\1\n\\2&#39;),
(r&#39;\(United States\) \(Belgium\)&#39;, r&#39;\\1\n\\2&#39;),
(r&#39;\(Portugal\) \(Kingdom of Hanover\)&#39;, r&#39;\\1\n\\2&#39;),
(r&#39;\(Brazil\) \(Mexico\)&#39;, r&#39;\\1\n\\2&#39;),
(r&#39;\(Saxony\) \(Denmark\)&#39;, r&#39;\\1\n\\2&#39;),
(r&#39;\(Portugal\) \(Mexico\)&#39;, r&#39;\\1\n\\2&#39;),
(r&#39;\(Brazil\) \(Kingdom of Hanover\)&#39;, r&#39;\\1\n\\2&#39;),
(r&#39;\(Haiti\) \(United States\)&#39;, r&#39;\\1\n\\2&#39;),
(r&#39;\(Spain\) \(Bavaria\)&#39;, r&#39;\\1\n\\2&#39;),
(r&#39;\(Denmark\) \(Mexico\)&#39;, r&#39;\\1\n\\2&#39;),
(r&#39;\(Denmark\) \(Saxony\)&#39;, r&#39;\\1\n\\2&#39;),
(r&#39;\(Denmark\) \(Paraguay\)&#39;, r&#39;\\1\n\\2&#39;),
# Add more patterns here following the same format
]
# Iterate over the files in the directory
for filename in os.listdir(directory):
if filename.endswith(&#39;.txt&#39;):
file_path = os.path.join(directory, filename)
# Read the contents of the file
with open(file_path, &#39;r&#39;, encoding=&#39;utf-8&#39;) as file:
contents = file.read()
# Apply the regex replacements
for pattern, replacement in patterns:
contents = re.sub(pattern, replacement, contents)
# Write the modified contents back to the file
with open(file_path, &#39;w&#39;, encoding=&#39;utf-8&#39;) as file:
file.write(contents)
print(&quot;Replacements completed.&quot;)

when i run this script i get Replacements completed. but when i check txt files then no any changes applied to txt files!

when i change \\1 and \\2 to \1 and \2 in my script then i get following errors:

Traceback (most recent call last):
File &quot;E:\Desktop\scr\OCR\tetetert.py&quot;, line 152, in &lt;module&gt;
contents = re.sub(pattern, replacement, contents)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File &quot;C:\Users\Administrator\AppData\Local\Programs\Python\Python311\Lib\re\__init__.py&quot;, line 185, in sub
return _compile(pattern, flags).sub(repl, string, count)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File &quot;C:\Users\Administrator\AppData\Local\Programs\Python\Python311\Lib\re\__init__.py&quot;, line 317, in _subx
template = _compile_repl(template, pattern)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File &quot;C:\Users\Administrator\AppData\Local\Programs\Python\Python311\Lib\re\__init__.py&quot;, line 308, in _compile_repl
return _parser.parse_template(repl, pattern)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File &quot;C:\Users\Administrator\AppData\Local\Programs\Python\Python311\Lib\re\_parser.py&quot;, line 1072, in parse_template
addgroup(int(this[1:]), len(this) - 1)
File &quot;C:\Users\Administrator\AppData\Local\Programs\Python\Python311\Lib\re\_parser.py&quot;, line 1008, in addgroup
raise s.error(&quot;invalid group reference %d&quot; % index, pos)
re.error: invalid group reference 1 at position 1

where is problem?

答案1

得分: 1

代码中有过多的反斜杠线：

使用原始字符串时，\1 应该只是 \1，而不是 \\1。
分组不需要 \ - 只需使用 (...)。

英文:

The code has an excess of backslashes:

With raw strings, \1 should be just \1 and not \\1
Groups don't need \ - you can use just (...).

答案2

得分: 1

手动列举成百上千个替换案例并不是解决这个问题的高效方法。相反，使用分支（例如 `荷兰|美国|...`）匹配所有国家名称，然后将匹配列表与 `\n` 连接起来：

```py
countries = [
  '荷兰',
  '美国',
  '葡萄牙',
  '希腊',
  ...
]

def format_country_name_files(file):
  content = file.read()
  countries_escaped = (re.escape(country) for country in countries)
  matches = re.findall('|'.join(countries_escaped), content)
  
  file.seek(0)
  file.write('\n'.join(matches))
  file.truncate()

尝试一下：

with open('.txt', 'r+') as file:
  format_country_name_files(file)

# 文件内容：
'''
奥斯曼帝国
西班牙
日本
瑞典
美国
...
'''

英文:

Manually listing hundreds of replacing cases is not an efficient solution to this problem. Instead, match all country names using branches (e.g. Netherlands|United States|...) and join that list of matches with a \n:

countries = [
  &#39;Netherlands&#39;,
  &#39;United States&#39;,
  &#39;Portugal&#39;,
  &#39;Greece&#39;,
  ...
]

def format_country_name_files(file):
  content = file.read()
  countries_escaped = (re.escape(country) for country in countries)
  matches = re.findall(&#39;|&#39;.join(countries_escaped), content)
  
  file.seek(0)
  file.write(&#39;\n&#39;.join(matches))
  file.truncate()

Try it:

with open(&#39;.txt&#39;, &#39;r+&#39;) as file:
  format_country_name_files(file)

# File content:
&#39;&#39;&#39;
Ottoman Empire
Spain
Japan
Sweden
United States
...
&#39;&#39;&#39;

通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库，让每个人都能够通过互相帮助和分享经验来进步。

如何使用Python脚本将特定空格替换为换行符？

问题

答案1

答案2

pandas 根据日期和月份创建掩码。

在Django中基于角色实现访问控制

错误从S3存储桶加载数据到Databricks外部表

如何对包含字符串和整数的列中的整数进行数据框排序？

What's the correct way to type hint an empty list as a literal in python?

如何在Highcharts Gantt中更改本地化的星期名称

如何在同一个流中使用多个过滤器和映射函数？

如何使用Map/Set来将代码优化到O(n)？

.NET MAUI Android在GitHub Actions上构建失败，错误代码为1。

如何在Playwright视觉比较中屏蔽多个定位器？

在C++中，可以使用可变模板参数来检索类型的内部类型。

selenium.common.exceptions.StaleElementReferenceException: Message: stale element reference: stale element not found

Creating and opening a URL to log in to Website via Basic Auth with Robot Framework/Selenium (Python)

AG Grid 在上下文菜单中以大文本形式打开

发表评论