擅长:python、mysql、java
<p>首先,您在pandas中读取输入csv的方式是错误的,您需要在数据框中正确读取它以分隔列:</p>
<pre><code>import pandas as pd
fileInput = input("Which file would you like to open: ") # python3 input is str by default
df = pd.read_csv(fileInput, skiprows=[1], delimiter="\s{2,}", engine="python")
</code></pre>
<p>之后,您可以轻松提取特定城市的行,如下所示:</p>
<pre><code>selectCity = input("Which city would you like to be visualized: ")
output = df[df["CITY"] == selectCity]
</code></pre>
<p>给予</p>
<pre><code> CODE AGE GROUP SEX CITY
0 E101 25 to 29 M Denver
1 E102 25 to 29 F Denver
4 E105 25 to 29 M Denver
</code></pre>
<p>一旦有了满意的行,您就可以根据需要进行格式化</p>