The Data Science job market seems to be getting flooded. Doesn't matter if it's Minneapolis or some other place, the competition has increased substantially.
I ended up taking another role in the Bay Area at a tech company as a Sr Data Scientist.
any way used xlwings before? This was one of the better (and free) python to excel package I could find. The problem is it's really slow, not in computation sense, but in the writing to Excel (i.e. computation is quick but writing results to cell is slow) part. Right now my get around is right everything as Sub instead of UDF. Alternatively I could still use UDF but make array input and array output, though I really dislike that idea as the input/output cannot be dynamic enough...
p.s. when I say slow I mean you can do smething simple, say column A=rand() and column B=rand(), columnC= coulmn A+ column B, in excel you can do this for 10,000 rows, it will come back more less right away after F9, if you do this in xlwings as UDF you can count the # of seconds before it comes back... (i.e. implement column C as udf as simple sum that takes two variables).
I'm not part of IT, so due to licence issue (and internal bureaucracy...) can't really use something like C#, otherwise I was thinking C# route, then use Excel DNA, right now the computation is relatively simple, it's more less a lot pulling from a dev SQL db (which IT agree to semi support), then use query/stored prod or dataframe kind of query to get results (none of the computation is really that bad save a few). That's why I see using C# with linq or data table can probably get same results.
n00b question but does anybody have a good resource that explains how to write Flex?
I have a basic, but workable SQL knowledge but have never written a flex more complicated than a simple 'set this field = this field where x != null'.
I'm supposed to be writing a Flex that pulls 3 fields from 3 separate tables and enters them into 3 other fields on a newly created table.
set field 1 on table X = field 1 on table A
set field 2 on table X = field 1 on table B
set field 3 on table X = field 1 on table C
But I don't understand the syntax for cursors, rowid=:rowid, exceptions etc.
I generally go through tech on the net for SQL questions but couldn't find anything helpful for flex and google only seems to have specific questions. I'm just looking for an introduction to how to write a flex.
Sorry if this the wrong place or if the answer is too complicated/detailed for a place like this....