擅长:python、mysql、java
<p>这是使用<code>pandas</code>库的一种方法。只要用<code>pd.read_csv('input_file.csv')</code>替换<code>pd.read_csv(mystr)</code></p>
<pre><code>import pandas as pd
from io import StringIO
mystr = StringIO('''personal:01
personal:apple
colorsid:fruitgreen
personal:01
personal:banana
colorsid:fruityellow
personal:01
personal:stawberry
colorsid:fruitred
personal:01
personal:mango
colorsid:fruitdarkgreen''')
df = pd.read_csv(mystr, header=None, names=['Col1', 'Col2'], delimiter=':')
# Col1 Col2
# 0 personal 01
# 1 personal apple
# 2 colorsid fruitgreen
...
# 9 personal 01
# 10 personal mango
# 11 colorsid fruitdarkgreen
x = df.iloc[df.index[1::3], 1] # ['apple', 'banana', 'stawberry', 'mango']
y = df.iloc[df.index[2::3], 1] # ['fruitgreen', 'fruityellow', 'fruitred', 'fruitdarkgreen']
x.to_csv('file1.csv', header=False, index=False)
y.to_csv('file2.csv', header=False, index=False)
</code></pre>