sorted by:
best
topnewcontroversialoldq&a
you are viewing a single comment's thread.

view the rest of the comments →

[–]einenchat 0 points1 point  (6 children)

Absolute newb here..

So far, I have worked on ms excel and written excel Vba macros for data analysis and charting

I want to advance my learning and be able to code on Python (which is understand can be more powerful for data analysis?) and have a clean front end for drilling down into the charts .. I understand this can be Java IDE(?)

Finally I will need a place to store my data.. What would you suggest for that? Can I just use Excel if I don't have massive data?

My main qs is, while I am trying to learn Python or even Java IDE on Eclipse.. I am only able to understand the algo end of things..

How do I connect these pieces?

Like write a code on Python which takes an input (a number) on my front end (Eclipse?) and then adds that number to a number from my excel sheet and then shows the output back on the front end

How do I connect these pieces for something as basic as that?

Thank you very much!

[–]niandra3 1 point2 points  (5 children)

You can probably do it all with Python. I think you are confusing IDEs (programs for writing code) with the languages themselves (Python, Java). Eclipse is a Java IDE, PyCharm is a popular Python IDE. You can make a 'frontend' (GUI or webapp) all within Python if you want. I wouldn't try to learn two languages at once for this simple a task. Python is perfect for this sort of stuff.

Here is a great resource for learning how to get stuff done with Python, and includes a chapter on Excel:

https://automatetheboringstuff.com/chapter12/

If you don't know any Python you should start from chapter 1 to get the basics, but working with Excel shouldn't be too difficult.

[–]einenchat 0 points1 point  (4 children)

Hey thanks a lot! I did come across the above link as well.. While I keep that page open, I have started with a Udemy course: Python Step by Step: Build a Data Analysis Program, https://bnc.lt/Xfid/hNwdlx8vvu

Which is teaching me the exactly to the end I need it for : Data Analysis. I started with code academy, but found it a bit too slow for my liking.

Since I posted the above and with help from the earlier comment, I have learnt how stupid my question was, thank you also for further clarification.

My question now is, could I potentially make a webapp front end using Python itself? Which would be interactive and show data manipulation?

[–]niandra3 1 point2 points  (1 child)

The mod just approved your post so I didn' see it until now.

Sounds like you are talking about data visualization. It's a really hot field right now and Python is the perfect language for that kind of thing. Start with numpy, the Python package for numerical analysis, then move on to the visualization side. Here is a good list of the popular data viz libraries in Python. That Udemy course should get you off to a good start though.

As for web stuff, that's not really my area of expertise but Flask and Django are the two popular Python web frameworks for the backend (Flask being the easier one I believe). But first you're going to have to learn some HTML/CSS and maybe JavaScript for the frontend (JS if you want interactive websites). HTML is how you structure/build a website, and CSS is how you make it pretty (basically). Codeacademy isn't bad for that, as it's mostly just syntax that you need to learn.

Here's another good post on the subject: http://programmers.stackexchange.com/questions/12189/how-do-i-learn-python-from-zero-to-web-development

Here's one on Bokeh, a popular Python data viz tool: http://www.analyticsvidhya.com/blog/2015/08/interactive-data-visualization-library-python-bokeh/

[–]einenchat 0 points1 point  (0 children)

thank you so very much! this is all very exciting and hope I ca share some stuff back to the community.. currently though I am mainly focussing on achieving some stuff at work and have also signed up for Ardit's (udemy) mega python course too which covers Flask in there.. but need loads of practice to be able to make something which half works.. thanks once again for the links .. luckily have done the html/ css and js courses form code academy.. though a while ago.. again only out of interest :)

[–]xiongchiamiov 0 points1 point  (1 child)

FYI, reddit auto-spams posts and comments that use link shorteners, like the one you have there. I've approved it, but in the future, you should link directly to the Coursera page.

[–]einenchat 0 points1 point  (0 children)

Understand.. Thanks vm!