• STYLE. COMMUNITY. GREAT CLOTHING.

    Bored of counting likes on social networks? At Styleforum, you’ll find rousing discussions that go beyond strings of emojis.

    Click Here to join Styleforum's thousands of style enthusiasts today!

Statistics, Data Science, and Data Mining Discussion Thread (Business Intelligence, Analytics, etc)

amathew

Distinguished Member
Joined
Nov 4, 2011
Messages
1,570
Reaction score
232
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.
 

clee1982

Stylish Dinosaur
Joined
Feb 22, 2009
Messages
12,021
Reaction score
1,602
kind off topic question, but somewhat related.

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.
 

OccultaVexillum

Distinguished Member
Joined
Aug 1, 2013
Messages
8,470
Reaction score
6,217
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.
eg/

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....
 

otc

Stylish Dinosaur
Joined
Aug 15, 2008
Messages
17,236
Reaction score
6,853
No idea, but have you tried googling for actionscript help/solutions rather than Flex?
 

OccultaVexillum

Distinguished Member
Joined
Aug 1, 2013
Messages
8,470
Reaction score
6,217
I have not. I just searched SQL Server, PL/SQL and Flex SQL.
I'll search for that now. thanks!
 

otc

Stylish Dinosaur
Joined
Aug 15, 2008
Messages
17,236
Reaction score
6,853
Oh sorry, nevermind then.

I thought you were talking about Apache ( formerly Adobe) Flex which is based on actionscript. I don't think actionscript has anything to do with the Flex you are talking about.
 

Featured Sponsor

What's your favorite type of loafer?

  • Tassel loafers

  • Penny loafers

  • Horsebit loafers

  • Kiltie loafers

  • I hate loafers


Results are only viewable after voting.

Related Threads

Forum statistics

Threads
421,202
Messages
9,056,205
Members
190,633
Latest member
robj83

Styleforum is proudly sponsored by

Top