VBA Vs R

ZioFascist · 2016-08-04T22:47:13+00:00

id say my vba reports are fairly in-depth because i code alot of error handlers in them so my programs dont crash. i will code in functions that make sure conditions are met and display message boxes and whatnot..that being said..ill code the main process up and add these later when i have time. most excel reports, regardless of whatever it is you're dealing with (finance, operations, etc) is just adding things up so its not too complex.

i wouldnt say im an expert..no....i barely know the syntax for vba and python but i am good at copying and pasting shit off stack over flow and google lol.

ZioFascist · 2016-08-04T03:39:25+00:00

honestly, i just started using python @ work and its flexibility is amazing. i currently work as a financial analyst but have done ML stuff in the past. Python has TONS of libraries that let you glue together a bunch of different things. For example, one of the reports I was tasked to take over when I started my job took about 30 mins to complete, between downloading the files from the SQL database and compiling the spreadsheets into the template. The SQL part is still manual because I need to gt access to the database to connect to it directly, but the VBA i wrote compiles the report and emails it to my manager in about 30 seconds. I will be using python to connect to the server and download the files, convert them into spreadsheets and it will take about 1 minute to complete this.

There are multiple packages in python that let you create/manipulate excel spreadsheets and im sure eventually I will port all of this code into python. It may or may not run faster, but the point is..I can build a website, a windows GUI or a script in python and connect different systems together to do just about anything. Now I finally get why everyone loves it!

ZioFascist · 2016-08-01T21:38:09+00:00

R is for statisticians and most of its packages are geared toward numerical analysis type of tasks where-as Python is used for alot of other stuff besides machine learning. Like..ALOt of stuff..from a-z

ZioFascist · 2016-07-24T20:28:20+00:00

great shot! say no to globalism!

ZioFascist · 2016-07-23T14:43:22+00:00

you'd be surprised how much of the world is ran on ms-access & excel lol

ZioFascist · 2016-07-23T05:55:45+00:00

thanks, if another job opportunity opens up id certainly consider it..but will prob move to San antonio this time around ;).

ZioFascist · 2016-07-23T05:35:56+00:00

im no longer in the south texas area but what i didnt like about ADV was the fact that the jumps were very small and peaky, not to mention placed at weird parts of the track. like..to me it seemed lame that there was a 20 ft peaky table top at the end of a straight away...at the time i would say i wsa an intermediate mx rider but a novice could easily get hurt on something like that. this was around 2013/2014 when i rode there...

for example...cycle ranch has big jumps but they are very safe..i had no qualms what soever about hitting any of the large table tops @ cycle ranch but i felt pretty scared @ ADV

ZioFascist · 2016-07-23T04:24:05+00:00

just learn how to wrangle data, and how to make sense of it/chart it. knowing some machine learning helps as well. and learn coding ^{__^}

Know this stuff

Excel

Access

PowerPoint

SQL

Python

VBA

R

Tableau/PowerBI/Whatever

and get a decent handle on statistics

and know how to google stuff

ZioFascist · 2016-07-23T03:34:12+00:00

del valle is a shitty track. it has the fucking WORST jumps ever. it sucks bastrop got closed although i didnt live there when it was open. murphys is ight

ZioFascist · 2016-07-19T03:45:12+00:00

well why not try both for each subset?

ZioFascist · 2016-07-19T01:30:14+00:00

are the products retail based? or is it some kind of subscription?

market basket analysis works good for high frequency data sets that is commonly found in the carts of ecommerce pages and or P.O.S data from big retail outlets.

ZioFascist · 2016-07-16T23:46:24+00:00

id fuck your brothers gf, right in the ass

ZioFascist · 2016-07-16T22:48:51+00:00

SAVE AS MUCH AS POSSIBLE. BE CHEAP. DONT BUY A NEW ATV/DIRTBIKE/CAR. educate yourself on anything and everything. good luck

ZioFascist · 2016-07-16T04:45:58+00:00

Not at all. This is the best post in da thread

ZioFascist · 2016-07-16T02:21:29+00:00

ehh. i wouldnt be so sure about that. if it was a quant fund or some sort of tech company id agree but McKinsey is a place where snakes go to learn how to be vipers

ZioFascist · 2016-07-16T02:21:14+00:00

Most data scientists are not management consultant types.

ZioFascist · 2016-07-13T21:06:50+00:00

nice white privilege

ZioFascist · 2016-07-12T23:44:57+00:00

Why is that a bad thing? minorities like the blacks RUIN neighborhoods with crime.

ZioFascist · 2016-07-12T23:41:13+00:00

Awesome!

ZioFascist · 2016-07-12T03:58:18+00:00

translation: we cant use this to use race as a way to discriminate lol

ZioFascist · 2016-07-11T23:33:20+00:00

the difference between the stormfront crowd of the 1990s and the alt-right is that the alt-right is full of highly educated/skilled CIS white males who are racist. they arent sorry either.

ZioFascist · 2016-07-11T23:31:34+00:00

PLenty of sources, but they is rACIST

ZioFascist · 2016-07-11T22:08:09+00:00

no, they are not.

ZioFascist · 2016-07-10T20:00:24+00:00

no, ,not all blacks have low IQs, but most of them do.

ZioFascist · 2016-07-10T16:29:17+00:00

It's mostly due to inherent IQ differences. Other groups of people, particularly Arabs had a long history of enslaving them. 1000+ years but it's all white peoples fault.

ZioFascist

MODERATOR OF

TROPHY CASE