Python Forum
Advice about Python - Printable Version

+- Python Forum (https://python-forum.io)
+-- Forum: Python Coding (https://python-forum.io/forum-7.html)
+--- Forum: General Coding Help (https://python-forum.io/forum-8.html)
+--- Thread: Advice about Python (/thread-32966.html)



Advice about Python - pythonman13 - Mar-20-2021

Hi everybody;

I'm new at Python and this Forum. I'm a great user of Excel but now time to be more quick. In Excel I analize
stock prices and get some effective results for BUY and SELL. Now, to be more quick I started Pyhton to reach more effective results. I want to ask some questions to reach the target in a short time. If you answer I will appreciate it.
I did the same thing using V.Basic and I used there DataGridView and DataFrame, if I want to make the same cells like in Excel, what must I do? To import daily prices Python from Excel (because I get prices somewhereelse and I omit unnnecessary parts) how I can do the connection? Thanks a lot. LOL


RE: Advice about Python - damian0612 - Mar-20-2021

If I am reading your question right, you might want to check out pandas https://realpython.com/pandas-python-explore-dataset/


RE: Advice about Python - snippsat - Mar-20-2021

Look at Common Excel Tasks Demonstrated in Pandas, part 2.

So Pandas is a powerful tool that like like Excel if use it in a Notebook eg JupyterLab or online Colab.
Has has import to and from Excel, pandas.read_excel, df.to_excel
A example NoteBook take in some stock data and here i use Altair to plot with.


RE: Advice about Python - pythonman13 - Mar-20-2021

(Mar-20-2021, 01:41 PM)damian0612 Wrote: If I am reading your question right, you might want to check out pandas https://realpython.com/pandas-python-explore-dataset/
Thank you good information


RE: Advice about Python - jefsummers - Mar-21-2021

I just heard of this today. For someone coming from the excel world this may be just what you are looking for. Apparently a bridge between Excel and Python/Pandas dataframes

https://trymito.io/