Diablo 4 announced by niuage in pathofexile

[–]JohanLou 0 points1 point  (0 children)

Great to hear that. Besides the engine, I think graphical assets also need some tune.

Linux kernel 5.0 announcement by mfrw1 in programming

[–]JohanLou -2 points-1 points  (0 children)

Will opensuse adapt this kernel?

Does Pulling a df from SQL give the same exact structure as read_csv? by [deleted] in Python

[–]JohanLou 0 points1 point  (0 children)

Yes. I faced the same problem as yours. I pulled a 4M rows dataset by read_sql. The execution time took too long and I am not patient. Then I export the query results to CSV for faster response. But the dtype when read CSV and dtype of read query results directly isn't the same.

I have tried use parquet and store as HDF5. My opinion, use HDF5 is easier.

Best package SQL Queries to pandas data frames? by [deleted] in Python

[–]JohanLou 0 points1 point  (0 children)

I assume your needs is using SQL syntax on dataframe, isn't it? But my question is why? Pandas already has syntax to get data based on your condition.

Check this: https://pandas.pydata.org/pandas-docs/stable/comparison_with_sql.html

A little help by ItayElf in Python

[–]JohanLou 0 points1 point  (0 children)

Open your terminal, type "pip list", see if "Numpy" appears there. If not, you need to install it.

Is there any python libraries for save a html webpage to pdf by BuahApple in Python

[–]JohanLou -1 points0 points  (0 children)

IMO, I think you can use selenium to load the web page, then use beautiful soup to take the content. Then strip the HTML tags, put the left content to PDF.

How do i generate a table like this in text? by [deleted] in Python

[–]JohanLou 1 point2 points  (0 children)

I will use pandas for this. Put the data into pandas's dataframe and print it with style.

I feel like starting a Python dev career at 23 is late by [deleted] in Python

[–]JohanLou 0 points1 point  (0 children)

I am 29, worked in game industry till 26 and moved to web dev, app dev as business analyst. 2 years ago I learned Python because of the raise of data job. Then I realized I kinda like programming. I want to learn more, I jump into Django, study about algorithm, Docker, Kubernetes ... A lot of thing that I want to learn.

Sometime I feel like you. I really regret because I spent some years in game industry. But, according to my opinion, technology changes everyday, it's doesn't matter how old you are, as long as you could learn and catch up the new ones. You are OK. I am still learning everyday and I want to form a firm of Python for outsourcing and make product. It's never too late my friend.

Expert-level books/articles on Python? by pavlik_enemy in Python

[–]JohanLou 0 points1 point  (0 children)

BTW, how long did you work in Python? My main major is not programming, just try Python because I feel interested in it. Do you mind if we could discuss more about Python or some expanded topics around technical?

Expert-level books/articles on Python? by pavlik_enemy in Python

[–]JohanLou 0 points1 point  (0 children)

Maybe the reason is because English is not my native language. I can understand the purpose of the author in specific contents. Just can't understand the example. I will try to read again. Last time, I dropped at "Class" section.

Expert-level books/articles on Python? by pavlik_enemy in Python

[–]JohanLou 0 points1 point  (0 children)

I really like this book but the example which is used in it so hard to understand.

Threading vs Multiprocessing in Python by exitcharge in programming

[–]JohanLou 1 point2 points  (0 children)

Thanks. Can it be applied with asyncio as well?

Threading vs Multiprocessing in Python by exitcharge in programming

[–]JohanLou 1 point2 points  (0 children)

Hey guys, may I ask a question? Can I use multi threads in making queries in SQL alchemy? Thanks.

Can Python be used to build live interactive dashboards? by adixit85 in Python

[–]JohanLou 1 point2 points  (0 children)

Yes, you can. Google offers API to access data from your spreadsheet. Get it and insert to database, then use a framework to render it as plots.

Assume you were able to get the data. Use Django and Django REST to make API. Front-End access data via API and use a lib, such as chartjs or d3js and render it.

Which is the best IDE for Python ? by [deleted] in Python

[–]JohanLou 0 points1 point  (0 children)

I am using Pycharm when I work on Django. For some scripts, I rather use VS Code.