Advice about Python

[pythonman13]

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.

[damian0612]

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

[snippsat]

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.

[pythonman13]

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

[jefsummers]

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/