擅长:python、mysql、java
<p>IIUC我想这就是你想要的:</p>
<pre><code>import pandas as pd
from io import StringIO
def str_int_chooser(string):
return int(string) if string.isnumeric() else string
csv = """projectIDs, Name
1, Project Runway
2, Project Alpha
3, Astronomical-Society
4a, Necronomicon-con"""
csv_file = StringIO(csv)
df = pd.read_csv(csv_file, converters={"projectIDs": str_int_chooser})
print(df)
for i in df["projectIDs"]:
print(i, type(i))
</code></pre>
<p>输出:</p>
<pre><code> projectIDs Name
0 1 Project Runway
1 2 Project Alpha
2 3 Astronomical-Society
3 4a Necronomicon-con
1 <class 'int'>
2 <class 'int'>
3 <class 'int'>
4a <class 'str'>
</code></pre>