Using python to build a program

Question

Hello, I recently started to learn python because I read that it's a good programming language for data analytics. I was wondering if it would be possible to develop a program using python where it would automatically retrieve data online for me and then input the data into an excel spreadsheet with a predetermined format and subsequently make computations and visual charts in excel. I wanted to ask ahead of time because I'm still new to programming and I wanted to make sure that I was learning the right programming language for my intended purpose.

Answer 1

You can certainly do all of these and more using Python.

You don't even have to use Excel charts; you can use a library like matplotlib which has much more functionality in visualizing data.

If you plan on doing data analysis, there's also a super powerful library called pandas to help you out there

Answer 2

you can use pandas to do your work ,you don't need excelsheet to do that and you can also use matplotlib to visualize data in pie chart ,3D graph or you can do lots of thing in Python.

Answer 3

Yeah, you are learning the right one, but you should search about before start learning something...

Answer 4

you can do anything and everything using python as it has many modules and libraries which will help to build applications and the synatx is simple.

Answer 5

Thank you for the answers! I'll certainly look into matplotlib and pandas while I'm learning the python course. I only made reference to excel since I also wanted to store the data in it since I'm quite accustomed to its interface. :)

Answer 6

If you want to write or read xlsx Excel files to/from python then I suggest trying out openpyxl. A library designed just for that. If you're interested in the calculations and visualisations of data then try matplotlib and pandas as mentioned.

Answer 7

please can someone explain to me what a library is?

Answer 8

Py is a great tool for ML and whatever, but one should break own addiction to Excel and all that crap. Go Linux or OSX, use real things! download Anaconda, learn keras, tensorflow, theano, torch.. actually not Python, nympy, scipy, matplotlib for visalisation, search for Deep Learning AZ with Python course