bash和python出现csv.collator.py错误

Question

我正在尝试使用csv.collator.py将csv文件中的一些数据分成块。当我尝试这样做时，我似乎得到了一些错误，我不确定为什么或如何解决它们。代码如下：

Ijeomas-MacBook-Pro:Heathrow data- 2019-02-07 till 2019-03-15 ijeoma$ csv_reader.py 15_min_Praxis_LHR2_meteo.csv | csv_collator.py -v -l 20 -u 100 -d 10 -f rh/15_min_Praxis_LHR2_meteo meteo.val.hmd  

Traceback (most recent call last):
  File "/Users/ijeoma/SCS/scs_analysis/src/scs_analysis/csv_reader.py", line 99, in <module>
    for datum in reader.rows:
  File "/Users/ijeoma/SCS/scs_core/src/scs_core/csv/csv_reader.py", line 88, in rows
    datum = self.__header.as_dict([CSVReader.__recast(cell) for cell in row])
  File "/Users/ijeoma/SCS/scs_core/src/scs_core/csv/csv_dict.py", line 111, in as_dict
    raise ValueError("unmatched lengths: header: %s row: %s" % (self, row))
ValueError: unmatched lengths: header: CSVHeader:{cells:<generator object CSVHeader.__str__.<locals>.<genexpr> at 0x1100f7138>} row: ['rec', 'gases.Max of Time', 'gases.Average of praxis-431.val.NO2.cnc', 'gases.Average of praxis-431.val.NO.cnc', 'gases.Average of ref.NOCNC1 (Processed)', 'gases.Average of ref.NO2CNC1 (Processed)', 'gases.15 minute "real" data', 'meteo.val.hmd', 'meteo.val.tmp', 'meteo.tag', 'Error (C-G)', 'Praxis NO2 baselined']
csv_collator: CmdCSVCollator:{lower:20.0, upper:100.0, delta:10.0, file_prefix:rh/15_min_Praxis_LHR2_meteo, verbose:True, path:meteo.val.hmd}
Traceback (most recent call last):
  File "/Users/ijeoma/SCS/scs_analysis/src/scs_analysis/csv_collator.py", line 71, in <module>
    collator = CSVCollator.construct(cmd.lower, cmd.upper, cmd.delta, cmd.file_prefix)
  File "/Users/ijeoma/SCS/scs_analysis/src/scs_analysis/helper/csv_collator.py", line 31, in construct
    bins.append(CSVCollatorBin.construct(bin_lower, bin_upper, file_prefix, form))
  File "/Users/ijeoma/SCS/scs_analysis/src/scs_analysis/helper/csv_collator.py", line 105, in construct
    writer = CSVWriter(file_name)
  File "/Users/ijeoma/SCS/scs_core/src/scs_core/csv/csv_writer.py", line 45, in __init__
    self.__file = open(self.__filename, "a" if self.__append else "w", newline='')
FileNotFoundError: [Errno 2] No such file or directory: 'rh/15_min_Praxis_LHR2_meteo_020p0_030p0.csv'
Ijeomas-MacBook-Pro:Heathrow data- 2019-02-07 till 2019-03-15 ijeoma$

Answer 1

根据堆栈上出现的ValueError: unmatched lengths，跟踪似乎表明您正在尝试设置超出其能力范围的值(即: 18值数组中的20个值数组)。

另外，您有一个FileNotFoundError: [Errno 2] No such file or directory: 'rh/15_min_Praxis_LHR2_meteo_020p0_030p0.csv'，所以您应该检查15_min_Praxis_LHR2_meteo_020p0_030p0.csv是否存在，或者您是否有足够的权限访问它。

如果没有一些示例代码，这就是我能为您提供的全部帮助：

希望这篇文章对你有用！