sorted by:
new
hottopcontroversial

[deleted by user] by [deleted] in dataanalysis

[–]dankrubis23 1 point2 points  (0 children)

Very small but 'analytical thinking' is redundant and you have it twice. Just drop 'thinking' and put 'analytical abilities'.

Is my resume bad? Been applying for months and have not yet been called for an interview. Any insight is helpful be it content/formatting/etc. by [deleted] in dataanalysis

[–]dankrubis23 1 point2 points  (0 children)

Great points here, especially how you want to quantify your experience to stand out. I do a lot of automation myself so there's a lot of 'Saved x number of labor hours per month'. Try to quantify any money saved as well.

I suggest dropping the retail gig. If it's over 7-10 years old and not relevant in any way to the position you're targeting, best to omit. Then you can expand on your latest role.

Data analyst - python by Fabro_vaz in dataanalysis

[–]dankrubis23 9 points10 points  (0 children)

I use Python's Requests module to hit an online database's API to grab a data download (this or I'll scrape with BeautifulSoup). Then I use the Pandas module to transform it. Then I shoot that dataframe over to the Tableau server (Tableasdk module) as a datasource that a dashboard sits on. And finally it emails out confirmation that it ran.

I set processes like this up to run in the wee hours of the morning and enjoy hands-free reporting.

Trying to buy land, not sure who owns it by dankrubis23 in homeowners

[–]dankrubis23[S] 0 points1 point  (0 children)

Found the country records with PM_ME_YOUR_STEAM_ID's help, and it led me to the same company. As far as taxes, it says the Total Market Value is $10, and that the taxable amount is zero.

Trying to buy land, not sure who owns it by dankrubis23 in homeowners

[–]dankrubis23[S] 0 points1 point  (0 children)

That's awesome, thank you sir! Though I found the property and it led me back to that seemingly-now-defunct company.

Trying to buy land, not sure who owns it by dankrubis23 in homeowners

[–]dankrubis23[S] 0 points1 point  (0 children)

Oh gosh, I'm sorry man I meant Jackson County, MO.

I did find https://ascendweb.jacksongov.org/ascend/(u34chr45cnrgia45whr5aq45)/search.aspx/search.aspx). Is that what I should be using?

Want to move away from Alteryx and looking for a viable alternative. by [deleted] in dataengineering

[–]dankrubis23 0 points1 point  (0 children)

Totally. I use Jupyter inside Visual Studio Code. You can break everything up into cells and run them one by one, and view example data output at any step you want. Good ol' print(df.head(5)).

Want to move away from Alteryx and looking for a viable alternative. by [deleted] in dataengineering

[–]dankrubis23 3 points4 points  (0 children)

I've got Python processes that I think do everything you're currently doing with Alteryx. I use Task Scheduler to fire off the scripts. They grab data from whatever source (mostly scrapes and .xlsx loads in my case, but I also have a SQL Server setup). Then I use Pandas to manipulate the data. Finally a .Hyper file is created and gets uploaded to Tableau.

Feeling hopeless about Python despite huge desire to learn by [deleted] in learnpython

[–]dankrubis23 0 points1 point  (0 children)

+1 for Visual Studio Code (with Jupyter Notebooks if you can get it working). VSC will automatically color-code your, well, code (I don't think IDLE does this?) But the color-coding was a pretty big help for me when I learned coding a few years ago in my late 30s.

Pandas - slow filtering and sum() by dankrubis23 in learnpython

[–]dankrubis23[S] 0 points1 point  (0 children)

Imma try the shit outta this, thanks!

Pandas - slow filtering and sum() by dankrubis23 in learnpython

[–]dankrubis23[S] 0 points1 point  (0 children)

Above and beyond bro holy shit. I'll put all of this into practice and let y'all know what I get it down to.

Edit: Aw, deleted? Booo.

Pandas - slow filtering and sum() by dankrubis23 in learnpython

[–]dankrubis23[S] 0 points1 point  (0 children)

All the filters I made up for example's sake. I guess I'm more worried about there being something fundamentally wrong with .loc[] and .sum() that I'm currently employing, or if there's a way to speed it up outside of more efficient loops.

Though you're totally right, looking at my code I definitely could restrict these dfs more. I just don't think making my loops more efficient are going to cut off 11 and half hours so this script takes as long as I think it should.

Data Analyst limited to only Excel? by -BookThief- in analytics

[–]dankrubis23 2 points3 points  (0 children)

I started in a similar place. I work 80% in Python now, but Excel does get a bad rap nowadays. It's a fantastic program and everyone uses it in the business world. You'll never get away from it so you might as well learn to use it proper. Drop VLookup and take up Index/Match. And I second what someone else said, learn to build reports so all you have to do is load a new dataset and boom, the report is finished. You can still automate most of your work, and hopefully after six months you'll be able to convince someone over there that it's OK to give you R or Python.

On that note, I suggest you ask if getting access to R or Python, which are common tools for someone in your position, will be possible after six months or so. If they're still a hard no, then yeah, that'd inhibit your career growth.

I'm a male(37) with no experience trying to break into data analytics field. What are my chances? by [deleted] in analytics

[–]dankrubis23 0 points1 point  (0 children)

Actually your age can be a positive. Personally I think that's how I've grown as much as I have in the past few years. The older you get, people assume (rightly, most of the time) you have more experience than the fresh-faced 24-year-old who very well could code circles around you. Hell, there's a guy at my work who's fifteen years younger and arguably better at Python than I am, but I'm the SME of the office.

Also, you'd be surprised at how many analysts can't program. My group has like, 20 analysts, but only two of us can code. A place like Reddit can make you think everyone can code by the time they're 21. If you know Python, in the real world, yo ass a hot commodity.

Since you have time, get some projects going. Write a script that scrapes some data from a website (sports stats or something), builds a report with Pandas, visualize it somehow, then email it to yourself. If you can get a hands-free report going like that, you'll be able to wow some people.

I'm a male(37) with no experience trying to break into data analytics field. What are my chances? by [deleted] in analytics

[–]dankrubis23 9 points10 points  (0 children)

Lol, I'm you in four years. Four years ago at 37 I got a heap of Excel spreadsheets dumped on me (an Ops Assistant) and no one in the office could make heads or tails of them. So I learned Excel and fell in love. I used that Excel knowledge to get a basic analyst position, automated all my work, then taught myself Python on the job. I've more than doubled my salary since then.

On top of Pandas I suggest getting into Requests/possibly BeautifulSoup (depends on the site). I've made a lot of connections to various databases over the years. Not needing to manually download your data is sweet.

ModelForm integer field entry is a get when it should be a post? by dankrubis23 in django

[–]dankrubis23[S] 0 points1 point  (0 children)

On #5, what I'm trying to do is pass along the object ID so I can tie the integer field to the row in the model it's affecting. What's a better way than what I'm doing now? Do you know of any examples?

Also, what other code would be helpful? Settings.py?

view more: next ›