python-3.x - 在 Python 3 中的 CSV 文件中的两个连续行之间插入新行

Question

我有一个像这样的 CVS 表：

 1st row: Types, Categories, Calculation
 2nd row: Type1, Category1, Calculation1
 3rd row: "   ", Category2, Calculation2
 4th row: "   ", Category3, Calculation3
 5th row: Type2, Category4, Calculation4
 6th row: "   ", Category5, Calculation5
 7th row: "   ", Category6, Calculation6
 8th row: Type3, Category7, Calculation7
 9th row: "   ", Category8, Calculation8

我有让用户输入类型、类别和数值的代码，由一个逗号分隔，后跟一个空格。我想知道如果输入的类型与现有类型之一匹配并且输入的类别与类型中的任何类别都不匹配，我如何在类型的最后一行下方插入一行而不更改任何一个。IE：

Input: Type1, Category5, Calculation9

目标：

 1st row:  Types, Categories, Calculation
 2nd row:  Type1, Category1, Calculation1
 3rd row:  "   ", Category2, Calculation2
 4th row:  "   ", Category3, Calculation3
 5th row:  "   ", Category5, Calculation9
 6th row:  Type2, Category4, Calculation4
 7th row:  "   ", Category5, Calculation5
 8th row:  "   ", Category6, Calculation6
 9th row:  Type3, Category7, Calculation7
 10th row: "   ", Category8, Calculation8

标签： python-3.xcsv