0
I made a Python code that takes an excel spreadsheet with data from all over Brazil and creates several files separated by states. Ex: spreadsheet contains data from SP, RJ, BH, RS and etc...
Python takes this parent spreadsheet and separates all states, creating a separate file for each state with its respective acronym. Ex: RJ Spreadsheet, SP Spreadsheet, BH Spreadsheet and etc.
So far blz. Except it’s on the colab. Since it is something of the company, I wanted to do this inside the company PC and I installed python and IDLE but I do not know how to run this code inside the IDLE.
In colab we import pandas among other libraries. Someone can help me to do this using the company PC that contains python and IDLE?
Note: I did not put the code because the code meets me. My problem is to put this to run in python and idle.
Got it. So I already downloaded and installed pycharm and anaconda. I already have the . py file I used in colab. I haven’t touched it yet using the tools I downloaded. As I’m crawling, it still beats a bit of fear. I’m looking for some tutorial to see happen and go doing little by little. Today this parent spreadsheet is on the network and I have to figure out how to run this code whenever I need to update the information. Type create a button with macro vba or some function that opens the file, update and close. If you know how to do and can guide me, I will be grateful.
– Alexandre Spindola