Thank you for this great tutorial! I had two problems after running the code. When i double clicked the dropped file i had a utf-8 decode error. My solution for this: I added this to your code in line 95: df = pd.read_csv(path, encoding='cp1252', delimiter=';') Second problem, the code was breaking when in the column_value pairs. There were NaN values in the csv data. Solution for this was adding some code to line 54: query_string = f"{col}.str.contains('{value}', na=False)" This solved this problem!
Thank you for your superb efforts. I had fun and learned a lot. Yes, there were problems. Some in your code, some in my following along. But solving hiccups is where the learning lies. If you had provided a flawless copy-and-paste text, and I had gotten lazy in following, I would have learned far less. And you provided a foundation so I will try to expand and add additional functionality for my project. I'm subscribed now. Cheers!
how are you coping the csv file to the viewer.? im doing a cntrl-c to copy and cntrl-v to paste but nothing is happening. i see you half to drag the file over to the grey box
hi friend i left some comment in your git... it seems that there are some bugs in function : search_table (1)the name of the column can not contain space ,like "AA BBB" will throw error (2)if there is #N/A in a column , it will throw error (3)if the column only contain number instead of str , it will throw error the errors i got : AttributeError: Can only use .str accessor with string values! ValueError: Cannot mask with non-boolean array containing NA / NaN values
Thank you for this great tutorial!
I had two problems after running the code.
When i double clicked the dropped file i had a utf-8 decode error.
My solution for this:
I added this to your code in line 95:
df = pd.read_csv(path, encoding='cp1252', delimiter=';')
Second problem, the code was breaking when in the column_value pairs. There were NaN values in the csv data.
Solution for this was adding some code to line 54:
query_string = f"{col}.str.contains('{value}', na=False)"
This solved this problem!
Thank you for your superb efforts. I had fun and learned a lot. Yes, there were problems. Some in your code, some in my following along. But solving hiccups is where the learning lies. If you had provided a flawless copy-and-paste text, and I had gotten lazy in following, I would have learned far less. And you provided a foundation so I will try to expand and add additional functionality for my project. I'm subscribed now. Cheers!
Thanks for the series. It was fun to follow!
how are you coping the csv file to the viewer.? im doing a cntrl-c to copy and cntrl-v to paste but nothing is happening. i see you half to drag the file over to the grey box
hi friend i left some comment in your git...
it seems that there are some bugs in function : search_table
(1)the name of the column can not contain space ,like "AA BBB" will throw error
(2)if there is #N/A in a column , it will throw error
(3)if the column only contain number instead of str , it will throw error
the errors i got :
AttributeError: Can only use .str accessor with string values!
ValueError: Cannot mask with non-boolean array containing NA / NaN values
line 91 has an error, _tkinter.TclError: bad listbox index "": must be active, anchor, end, @x,y, or a number
SUPER ........ MAY FREND
Program only accepts headers with one word. Cant figure out how to use the filter with headers of more than one word
👍👍👍
You r awesome
this program dont work