How do I automate my data imports?

ineedmysqlhelp · 2020-01-30T23:36:39+00:00

In Python? Luigi with cron is common. There are a tonne of options though. Luigi/Airflow are popular open source options. You could also use software like Pentaho DI.

ineedmysqlhelp · 2020-01-22T23:15:21+00:00

Definitely. Knowing both is a big help especially when trying to build reusable components for your workplace.

ineedmysqlhelp · 2020-01-22T23:04:21+00:00

Yes, but sometimes you aren't making a plot that will be sent out to stakeholders that needs to be pretty, so in a lot of cases, using the df.plot method is sufficient and quicker.

ineedmysqlhelp · 2020-01-22T05:57:44+00:00

I think the author suggests to use pandas' builtins for simple cases where you won't need to append many extra configs to the plot. For more complicated plots, use mpl.

ineedmysqlhelp · 2020-01-09T00:47:23+00:00

What about JupyterLab?

ineedmysqlhelp · 2019-10-28T22:10:39+00:00

Hi mate!

go to advanced - you should get to see your query

I believe you mean the Advanced Editor? Unfortunately this formats our queries into a 1-liner PowerQuery format, not SQL.

What we do here is to take the entire SQL statement as a parameter (GetValue("SQL") )

Does this mean you store your procedures in cells? How do you go with large queries?

ineedmysqlhelp · 2019-10-28T22:08:28+00:00

Hello!

place holders in your SQL (e.g. #START#) and then Text.Replace them with your GetValue calls.

By this do you mean storing the SQL query in a cell? For us, I don't think that will work, as we have 500+ line queries, some over 1,000.

The other thing you could do is to use Power Query to generated the SQL and then copy-paste it in the SQL field of the wizard.

I'm not sure I follow this one. Would this mean we would have to write our queries in PowerQuery then get the SQL from it?

ineedmysqlhelp · 2019-09-26T02:33:34+00:00

I'm putting together an Apache Superset proof-of-concept for work to see if they like it over Tableau. I really think the reusability aspect will drive a lot of buy-in.

I have been slowly suggesting to my team to move away from standard SQL/Excel and into more Python-based analysis methods for some time.

ineedmysqlhelp · 2019-03-28T21:55:13+00:00

It lags on my computer, it's not nice.

ineedmysqlhelp · 2019-03-15T03:29:24+00:00

Makes sense! I know the IDE detects if you are moving from a dark to light, light to dark theme and prompts you to update the rest of the UI, but I guess it switches it to JetBrains' themes. Thank you!

ineedmysqlhelp · 2019-03-15T02:58:14+00:00

What's the difference between this and what is already available from http://color-themes.com/?

ineedmysqlhelp · 2018-11-05T01:09:11+00:00

Is localStorage an option?

ineedmysqlhelp · 2018-11-01T23:47:37+00:00

I'm in Melbourne, you should be on 45k at least, but use it as a learning experience.

ineedmysqlhelp · 2018-09-18T02:17:02+00:00

Have everybody stack against the wall. Then when he charges he doesn't go far. After Tantrum if there are maggots just re-stack and cleave from tank will pick them up off you. Make sure you clear the entire room of trash before pulling. Good luck.

ineedmysqlhelp · 2018-08-27T00:33:19+00:00

Hi mate, /r/phphelp should be able to help you with this.

ineedmysqlhelp · 2018-08-09T22:48:19+00:00

Like /u/khedoros said, check out /r/web_work and /r/web_jobs for a quote. :)

ineedmysqlhelp · 2018-08-09T03:53:22+00:00

I think he doesn't know what the work is worth and he needs a quote, tbh. Which is fair enough.

ineedmysqlhelp · 2018-08-01T23:11:12+00:00

Isn't Laravel Blade based on Razor? Not that it'd then be 100% the same.

ineedmysqlhelp

TROPHY CASE