pandas filter not working

issac_n · Jan-09-2018, 01:13 AM

(Jan-08-2018, 11:28 AM)Larz60+ Wrote: remove the c:\ fro m file name

 import pandas as pd import numpy as np all_dataB = pd.DataFrame() dfB= pd.read_excel("File2.xlsx") dfB[dfB["BoardName"]=='Alex*'] all_dataB = dfB print(dfB)#check

results:

Output:
 Backend TkAgg is interactive backend. Turning interactive mode on. AreaName BoardName 0 Utopia Darren 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 12 Utopia Darren 13 Utopia Darren 14 Utopia Darren 15 Utopia Sean 16 Utopia MRRU 17 Utopia MRRU 18 Utopia MRRU 19 Utopia MRRU 20 Utopia MRRU 21 Utopia MRRU 22 Utopia Alex 23 Utopia Alex 24 Utopia Alex 25 Utopia Alex 26 Japan MRRU 27 Japan MRRU 28 Japan MRRU 29 Japan Alex .. ... ... 128 Japan MRRU 129 Japan MRRU 130 Indonesia Darren 131 Indonesia Alex 132 Indonesia Darren 133 Indonesia Darren 134 Indonesia Sean 135 Indonesia MRRU 136 Indonesia MRRU 137 Indonesia MRRU 138 Indonesia MRRU 139 Indonesia MRRU 140 Indonesia MRRU 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 152 Indonesia Darren 153 Cebu Darren 154 Cebu Darren 155 Cebu Sean 156 Cebu Alex 157 Cebu MRRU [158 rows x 2 columns]

my desire result should contains Alex only.

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

pandas filter not working

User Panel Messages

Announcements