Jan-09-2018, 03:51 AM
import pandas as pd all_datab = pd.DataFrame() dfb = pd.read_excel("File2.xlsx") dfc = dfb[dfb["BoardName"] == 'Alex'] print(dfc)Results:
Output: AreaName BoardName
1 Utopia Alex
2 Utopia Alex
3 Utopia Alex
4 Utopia Alex
5 Utopia Alex
6 Utopia Alex
7 Utopia Alex
8 Utopia Alex
9 Utopia Alex
10 Utopia Alex
11 Utopia Alex
22 Utopia Alex
23 Utopia Alex
24 Utopia Alex
25 Utopia Alex
29 Japan Alex
30 Japan Alex
31 Japan Alex
32 Japan Alex
33 Japan Alex
34 Japan Alex
35 Japan Alex
36 Japan Alex
37 Japan Alex
38 Japan Alex
39 Japan Alex
40 Japan Alex
52 Indonesia Alex
62 Indonesia Alex
63 Indonesia Alex
.. ... ...
90 Utopia Alex
101 Utopia Alex
102 Utopia Alex
103 Utopia Alex
104 Utopia Alex
108 Japan Alex
109 Japan Alex
110 Japan Alex
111 Japan Alex
112 Japan Alex
113 Japan Alex
114 Japan Alex
115 Japan Alex
116 Japan Alex
117 Japan Alex
118 Japan Alex
119 Japan Alex
131 Indonesia Alex
141 Indonesia Alex
142 Indonesia Alex
143 Indonesia Alex
144 Indonesia Alex
145 Indonesia Alex
146 Indonesia Alex
147 Indonesia Alex
148 Indonesia Alex
149 Indonesia Alex
150 Indonesia Alex
151 Indonesia Alex
156 Cebu Alex
[80 rows x 2 columns]