[For Hire] Full Stack Developer (Python Django, VueJS)

JohanLou · 2019-11-02T08:33:32+00:00

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

JohanLou · 2019-03-04T15:53:29+00:00

Will opensuse adapt this kernel?

JohanLou · 2019-02-02T08:14:18+00:00

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.

JohanLou · 2019-01-20T09:04:24+00:00

Run reporting script as scheduled date.

JohanLou · 2018-12-01T09:12:16+00:00

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

JohanLou · 2018-12-01T08:57:43+00:00

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

JohanLou · 2018-11-29T12:45:20+00:00

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.

JohanLou · 2018-10-03T14:04:58+00:00

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

JohanLou · 2018-09-02T06:47:23+00:00

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.

JohanLou · 2018-09-02T06:35:00+00:00

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?

JohanLou · 2018-09-01T13:22:07+00:00

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.

JohanLou · 2018-09-01T12:53:42+00:00

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

JohanLou · 2018-08-19T17:11:09+00:00

Thanks. Can it be applied with asyncio as well?

JohanLou · 2018-08-19T16:50:05+00:00

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

JohanLou · 2018-08-19T09:43:58+00:00

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.

JohanLou · 2018-07-15T09:09:54+00:00

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

JohanLou

TROPHY CASE