Table Editor in Python with pandastable

Today we learn how to easily build a simple table editor in Python using the pandastable package.
◾◾◾◾◾◾◾◾◾◾◾◾◾◾◾◾◾
📚 Programming Books & Merch 📚
🐍 The Python Bible Book: www.neuralnine.com/books/
💻 The Algorithm Bible Book: www.neuralnine.com/books/
👕 Programming Merch: www.neuralnine.com/shop
💼 Services 💼
💻 Freelancing & Tutoring: www.neuralnine.com/services
🌐 Social Media & Contact 🌐
📱 Website: www.neuralnine.com/
📷 Instagram: / neuralnine
🐦 Twitter: / neuralnine
🤵 LinkedIn: / neuralnine
📁 GitHub: github.com/NeuralNine
🎙 Discord: / discord

[@peterkosjr]

This is outstanding content. Thank you!

[@dipeshsamrawat7957]

Nice! Thank you.

[@golmatol6537]

Seems like it might really come in handy some day.

[@stansuen8072]

Great video! Thanks. When you resize and make the window bigger, can you config it so that more rows and columns are brought into the viewport? Also free to header rows and first columns? I have tried it with a big dataframe and I cannot resolve this issue.

[@lizzybennet5726]

Thanks! Is it possible to use Pandastable on Google Colab?

[@vishnubalaji9500]

hiw use this in kivy or flet

[@sadameer6058]

Hello, can u please make a video on how to read text files with massive speed, i have a folder full of text files with +1Gb each file to search query in. what i can do?

[@evanpendergraft]

try loading the text files lines as a dictionary. it should increase the speed of search querys.

[@sadameer6058]

@@evanpendergraft wdym? what is the key and what is the value?

[@trevoreguitar]

Either use mmap (this example shows line by line but you could just perform a re search over the full content if reading the big file into memory isn't a concern):
import mmap
with open("FILE", "r+b") as f:
mm = mmap.mmap(f.fileno(), 0)
for line in iter(mm.readline, b""):
print(line)
Or if multirow operations aren't as big of an issue/don't need special code to perform on & you need to perform a ton of queries, you can just dump the contents (make a table, column_name = filename, new line in file = new row in column) into some sqlite/duckdb database & perform SQL queries over the top of them. If you REALLY need to go further you could theoretically do multiprocessing & with os.fork() + mmap start applying operations as the file is being read given the current location of the pointer, but if you're dealing with parent/child processes you might want to take this as an opportunity to just learn a lower level language for both your own benefit & understanding + better control

[@y2ksw1]

Use the operating system directly. For huge amounts of data scraping, all languages but C are deficient. grep would be your friend.

[@jelsonnervar7715]

Can U do other programming languages content, like C#?

[@murphygreen8484]

Kinda cool. Though why would anyone use this over Excel?

[@philtoa334]

Thx_.

[@uchiha_sasuke_48]

I have a question. I know how things go and how they happen. But I don't know how to code on my own without taking help from GPT, Bard etc.
Can I actually make a project using those and place them in my resume?

[@NikolazLopes]

Using AI to learn isn't bad; searching for how to use a function you forgot or help with some tasks is okay, and everyone does it. But if you can only code with it, it's a problem. Try to code a project without AI, as long as it takes, searching on your own. If you struggle too much it shows you must learn other things before or pratice what you already know. I think.

[@uchiha_sasuke_48]

@@NikolazLopes thanks bro
I'll try your approach

[@user-bf2io2ou5e]

first

[@xkolm49]

useless but good to know it exists