Python Forum

Full Version: Advice about Python
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
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
If I am reading your question right, you might want to check out pandas https://realpython.com/pandas-python-explore-dataset/
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.
(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
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/