1. Hi, I'm the owner and main administrator of Styleforum. If you find the forum useful and fun, please help support it by buying through the posted links on the forum. Our main, very popular sales thread, where the latest and best sales are listed, are posted HERE

    Purchases made through some of our links earns a commission for the forum and allows us to do the work of maintaining and improving it. Finally, thanks for being a part of this community. We realize that there are many choices today on the internet, and we have all of you to thank for making Styleforum the foremost destination for discussions of menswear.

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

Discussion in 'Business, Careers & Education' started by amathew, Mar 8, 2014.

  1. brokencycle

    brokencycle Stylish Dinosaur Moderator

    Messages:
    14,571
    Likes Received:
    7,685
    Joined:
    Nov 21, 2008
    Location:
    The Old North State
    Looking at the official unemployment rates, not quite. 4% vs 3.3% unemployment right now.
     

  2. amathew

    amathew Distinguished Member

    Messages:
    1,570
    Likes Received:
    232
    Joined:
    Nov 4, 2011
    Location:
    KS => CO => MN => CA
    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.
     

  3. clee1982

    clee1982 Stylish Dinosaur

    Messages:
    11,852
    Likes Received:
    1,539
    Joined:
    Feb 22, 2009
    Location:
    New York City, NY, USA
    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.
     

  4. OccultaVexillum

    OccultaVexillum Distinguished Member

    Messages:
    8,184
    Likes Received:
    5,565
    Joined:
    Aug 1, 2013
    Location:
    Upstate NY
    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....
     

  5. otc

    otc Stylish Dinosaur

    Messages:
    16,789
    Likes Received:
    6,318
    Joined:
    Aug 15, 2008
    No idea, but have you tried googling for actionscript help/solutions rather than Flex?
     

  6. OccultaVexillum

    OccultaVexillum Distinguished Member

    Messages:
    8,184
    Likes Received:
    5,565
    Joined:
    Aug 1, 2013
    Location:
    Upstate NY
    I have not. I just searched SQL Server, PL/SQL and Flex SQL.
    I'll search for that now. thanks!
     

  7. otc

    otc Stylish Dinosaur

    Messages:
    16,789
    Likes Received:
    6,318
    Joined:
    Aug 15, 2008
    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.
     

Share This Page

Styleforum is proudly sponsored by

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies, our Privacy Policy, and Terms and Conditions.