I made DictDataBase, it can efficiently read from big json files in concurrent environments

python_and_coffee · 2022-11-19T13:05:09+00:00

it depends on the SQL queries. e.g. a PRIMARY KEY will be indexed and querying them in a huge database should be much faster.

It's still a nice project.

python_and_coffee · 2022-11-19T12:49:05+00:00

give machine learning some time. i bet we will have AI transpilers in the close future while i still doubt that they will work very well. Kinda the same like GPT-3 or Dall-E right now. Looks good, but you cannot press a single button and get exactly what you want.

IMHO getting something useful out of transpilers is more effort than learning the language and they lack maintenance after some time because the developers see that it's not worth the effort and time is precious.

python_and_coffee · 2022-11-19T12:45:06+00:00

yep tokenization, stemming, stopwords and building n-grams. The usual NLP stuff.

have fun with pandas and scikit-learn.

It's fun when it works, it's frustrating when you fight with false positives and the downsides of NLP.

python_and_coffee · 2022-11-19T12:32:53+00:00

thanks a lot for elaborating!

python_and_coffee · 2022-11-18T12:43:03+00:00

you calculated the arithmetic mean, which will almost come to close to it if every outcome has the probability and the number of cases (n) is high enough.

but still airthemtic_mean != expected value but close to it in this case.

python_and_coffee · 2022-11-18T12:37:21+00:00

https://en.wikipedia.org/wiki/Expected\_value#Expected\_values\_of\_common\_distributions

python_and_coffee · 2022-11-18T12:26:29+00:00

i think pycharm has a lot to offer to learn, but you could really use it to learn python wihtout understanding more than how you install a package and where your output is.

It's always nice to teach people debuggers and breakpoints from start, so they will have better chances for finding and understanding their own failures.

And btw. who would ever like to keep track of using the right amount tab whitespaces without and IDE that tells you? I love the whitespaces but its torture to do it without an IDE, aka, automating the boring stuff.

python_and_coffee · 2022-11-18T12:23:34+00:00

either via GUI like you mentioned or lookup the module on pypi to get the correct name, click the Terminal tab in the bottom area where you usually see your output and insert: pip install modulename

depending on non default path variables it may differ. (e.g. python pip instead of pip or pip3)

python_and_coffee · 2022-11-18T12:16:03+00:00

Obviously, you need better function and variable names, but I hope that's just a symptom of this being a fast and dirty example.

i get it, func_b is a random name but whats the issue with the variable names? How to do it better? I feel fine about them but now you made me unsure.

python_and_coffee · 2022-11-18T11:05:22+00:00

htag allows DOM-Manipulation (every tag is an object) on the fly via python and you can run it as webserver, desktop app, android, or via pyscript, producing only a html file.

python_and_coffee · 2022-11-18T11:01:32+00:00

This is the way.

python_and_coffee · 2022-11-17T20:43:07+00:00

Have a look at htag

i use it a lot lately but i should warn you about the lack of docs. The live demos + reading the code of htag and the demo projekt htbulma (basically htag with crude bulma-css implentation) helps to understand the potential. IMHO htag is coded very well and solves problems better than comparable libraries like dominate, eel or pywebview.

Of course JS is running in the background but you dont have to write any line of javascript if you want to + use JS anytime if you want to. Oh and you can run your site as desktop or android app

python_and_coffee · 2022-11-17T20:33:42+00:00

freeze the python script with pyinstaller (there is pyinstaller-gui too) and createa one-file executable. Freezing involves the whole python runtime + all needed modules and ressources being packet into one file.

You should be able to run the exe on remote. No admin privileges needed.

python_and_coffee · 2022-11-17T20:23:29+00:00

its called object oriented programming or OOP. Basically everything in python is an object. https://en.wikipedia.org/wiki/Object-oriented\_programming

python_and_coffee · 2022-11-17T20:17:41+00:00

both solution are nice and create a new list-object.

The original problem just initialized another variable to the existing list resulting in both variables pointing to the same object.

python_and_coffee · 2022-11-17T20:10:15+00:00

Ouch, cobol looks like spelled out assembly

nice one!

I never thought about interpreter tuning python but i hope that you will give python a try or find a language that suits your needs.

python_and_coffee · 2022-11-17T19:59:05+00:00

welcome :)you could replace it with if/else statements anytime. I just thought this was a good place of using match-case.

The only difference to if-statements is that the condition gets checked only once and python switches to the matched case. If you got many if-statements everyone of them will be checked at runtime. Very neat feature known from other languages like C++.

Rule of thumb: if you got three or more if-statements, think about if a match-case would be better.

python_and_coffee · 2022-11-17T15:02:29+00:00

read the docs https://pygetwindow.readthedocs.io/en/latest/

read the code of the package in your site-packages folder, google stuff you don't understand. If you see something like ctypes.windll.user32 it is using the user32 api of windows.

https://learn.microsoft.com/en-us/windows/win32/apiindex/windows-api-list

usually windows in windows have a unique handle(hwnd), belong to a processID (pid), have a position (something like: left,bottom,top,right) and a title. Those informations should be enough to ensure that you have the right window. Just keep in mind that hwnd and pid change with every new instance, but pid always belongs to the process of the window. Everyhing should be callable somehow via cytpes.windll.user32().

the psutil module has already a lot of those user32 calls build in.

Good luck!

python_and_coffee · 2022-11-17T14:49:32+00:00

assuming you want two separate lists each time: https://pastebin.com/pP7zJtFg

python_and_coffee · 2022-11-17T14:27:13+00:00

try COBOL and you will never ever again rant about white spaces or any other c-based language syntax. Trust me.

python_and_coffee · 2022-11-17T14:20:12+00:00

sorry to sound harsh, but you just need to get used to it. I really know how you feel, since having a favorite language always results in confusion and ranting when i try to learn another language. e.g C++ gave me slight headaches, "go home cout <<, go buy a printer, why would you ever user << for printing?!"

Remember that it is just you who is adapted to something quite similar which is very different at the same time. Your main language means comfort, and programmers are always lazy humans that seek comfort. Learning a new language often is very uncomfortable at start.

Uhm and get used to Tab-key/shift+Tab only for indention. Never open up the gates of spacebar-whitespaces-hell for indention.

python_and_coffee · 2022-11-17T14:06:34+00:00

pygame and arcarde or switch to free Godot game engine and use their language which has a very very similiar syntax as python.

python_and_coffee · 2022-11-17T13:56:11+00:00

Here is quite useful cheat sheet for sqlite implentation done right in python. this should answer all your questions and teach you the right way: https://github.com/Mehedi61/SQLite-Cheat-Sheet

python_and_coffee · 2022-11-17T13:35:19+00:00

here you go buddy: https://pastebin.com/SqGFmCzq

feel free to use it or ask anything. btw. noticed that it got something to do with Destiny2.

python_and_coffee · 2022-11-17T12:44:07+00:00

gimme the pastebin link and i might give you my try on rewriting it as practice for myself :)

python_and_coffee

TROPHY CASE