按特定顺序合并两个文件？

Question

我有两个文件

第一个名为plays.txt的

D:\data\nfl\Weekly\2014Week1\ARI.txt
D:\data\nfl\Weekly\2014Week1\ATL.txt
...
D:\data\nfl\Weekly\2014Week1\WAS.txt

===
D:\data\nfl\Weekly\2014Week2\ARI.txt
...

我还有一个名为spreads.txt的文件，看起来像

D:\data\nfl\spreads\2014Week1\NFL Games 2014Week1.csv
D:\data\nfl\spreads\2014Week2\NFL Games 2014Week2.csv
D:\data\nfl\spreads\2014Week3\NFL Games 2014Week3.csv
D:\data\nfl\spreads\2014Week4\NFL Games 2014Week4.csv
D:\data\nfl\spreads\2014Week5\NFL Games 2014Week5.csv
...

我正试图将它们合并到一个文件中

D:\data\nfl\Weekly\2014Week1\ARI.txt
D:\data\nfl\Weekly\2014Week1\ATL.txt
...
D:\data\nfl\Weekly\2014Week1\WAS.txt

D:\data\nfl\spreads\2014Week1\NFL Games 2014Week1.csv
===
D:\data\nfl\Weekly\2014Week2\ARI.txt
D:\data\nfl\Weekly\2014Week2\ATL.txt
...
D:\data\nfl\Weekly\2014Week2\WAS.txt

D:\data\nfl\spreads\2014Week2\NFL Games 2014Week2.csv
===
...

如何组合这两个文件，以便将排列.csv文件的文件位置放在每年/每周的所有TEAM.txt文件之后

Answer 1

对于好奇的人来说，我是如何解决这个问题的这是我想出的剧本

import os


games = [line.rstrip('\n') for line in open('plays.txt', 'r')]
spreads = [line.rstrip('\n') for line in open('spreads.txt', 'r')]

for spread in spreads:
    year_week = os.path.splitext(os.path.basename(spread).split()[-1])[0]
    for idx, game in enumerate(games):
        parts = os.path.splitext(game)[0].split('\\')
        if parts[-1] == 'WAS' and parts[-2] == year_week:
            games.insert(idx + 1, "")
            games.insert(idx + 2, spread)

基本上，我想在最后一个团队之后插入csv文件，它总是was.txt，然后我只是拉出周/年，以确保我将它们插入到正确的位置

Answer 2

我的建议是在编辑器中打开plays.txt和spreads.txt，最后粘贴spreads.txt（在plays.txt之后）。另存为名为newfile.txt的新文件，并在excel或openoffice中打开。然后你就可以分类了。希望你能得到你想要的。Python也可以做到这一点，但这将是一种过度的杀伤力。 致以最良好的祝愿