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. 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/ |