擅长:python、mysql、java
<p>输入:</p>
<pre><code>df = pd.read_table(StringIO(""" Index Fruit Price
0 Apple 55
1 Orange 98
62 Mango 141
55 Guva 184
5 Lemon 65
7 Tomato 65
8 Cabbage 65
30 Cucumber 65
31 Apple 65
35 Orange 45
9 Mango 78
22 Guva 66
11 Lemon 74
36 Tomato 57
14 Cabbage 58
12 Cucumber 59
16 Apple 60
13 Orange 61
19 Mango 62
18 Guva 63
20 Lemon 64"""), sep='\s+')
</code></pre>
<p>在列<code>Index</code>中查找15到20之间的值(<code>set_index</code>将以所需的输出格式输入,但完全是可选的):</p>
<pre><code>df.loc[(df.Index >= 15) & (df.Index <= 20)].set_index('Index')
</code></pre>
<p>输出:</p>
<pre><code> Fruit Price
Index
16 Apple 60
19 Mango 62
18 Guva 63
20 Lemon 64
</code></pre>