擅长:python、mysql、java
<h2>读入<code>csv</code>并使用<a href="http://pandas.pydata.org/pandas-docs/stable/text.html#working-with-text-data" rel="nofollow">Series ^{<cd2>}</a>操作,如<a href="http://pandas.pydata.org/pandas-docs/stable/generated/pandas.Series.str.replace.html#pandas-series-str-replace" rel="nofollow">^{<cd3>}</a></h2>
<pre><code>import pandas as pd
from cStringIO import StringIO
# Fake csv text for example
textcsv = '''
cycle,cid,amount,date,realcode,type,di,feccandid
|2014|,|N00029285|,1000,05/15/2014,|E1600|,|24K|,|D|,|H8TX22107|
|2014|,|N00026722|,5000,10/22/2013,|G4600|,|24K|,|D|,|H4TX28046|
|2014|,|N00030676|,4 ,03/26/2014,|C2100|,|24Z|,|D|,|H0MO07113|
'''
# Read in fake csv
# normally you would use: dfy = pd.read_csv('/path/to/file.csv')
dfy = pd.read_csv(StringIO(textcsv))
# Replace '|' in cells with series.str methods
for col in dfy:
if dfy[col].dtype == 'object':
dfy[col] = dfy[col].str.replace('|', '')
print day
</code></pre>
<hr/>
^{pr2}$