pandas filter not working

issac_n · Jan-11-2018, 08:28 AM

(Jan-09-2018, 03:51 AM)Larz60+ Wrote:

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]

.. finally found my mistake. thanks :)

Possibly Related Threads…
Thread		Author	Replies	Views	Last Post
	Pandas replace function not working on datafram with floats	bcrypto	1	2,890	Apr-12-2021, 08:59 PM Last Post: bcrypto
	Python Custom Module not working in Jupyter Notebook with Pandas	fid	0	2,038	Jul-04-2020, 11:05 AM Last Post: fid
	Pandas + Groupby + Filter unique values	JosepMaria	1	2,880	Jun-15-2020, 08:15 AM Last Post: JosepMaria
	Pandas DF filter base on another DF	Johnse	1	2,242	Sep-06-2019, 03:41 PM Last Post: ThomasL
	import pandas as pd not working in pclinuxos	loren41	3	2,324	May-19-2019, 03:49 PM Last Post: Larz60+
	Working with date indexes (pandas)	dervast	0	1,960	Apr-05-2019, 01:29 PM Last Post: dervast

pandas filter not working

User Panel Messages

Announcements