1. Pandas In Visual Studio Code
2. Using Pandas In Visual Studio
3. Visual Studio Code Pandas Autocomplete
4. Install Pandas Visual Studio Code
5. Unable To Import Pandas Visual Studio Code

My beloved Spyder IDE suddenly stopped working on me, and I needed to install Python + Pandas on a new computer anyway, so I decided to explore installing Python (and various packages I use with it such as Pandas) out of the Windows Store, executing code in VSCode as an IDE. The Windows installation of Python is pretty stripped down, like that of Miniconda, and similarly doesn’t require. The easiest way to install pandas is to install it as part of the Anaconda distribution, a cross platform distribution for data analysis and scientific computing. This is the recommended installation method for most users. Instructions for installing from source, PyPI, ActivePython, various Linux distributions, or a development version are also provided. Nebula Pandas Theme for VS Code. The lovely Nebula Theme by ChirtleLovesDolls with a little touch of pandas. It basically colorizes.loc,.iloc, and some other pandas methods and functions in order to fully enjoy this wonderful theme with pandas! All the functionality of the original is there, as mentioned, it's just modified to be compatible with pandas.

In this tutorial, you use Python 3 to create the simplest Python 'Hello World' application in Visual Studio Code. By using the Python extension, you make VS Code into a great lightweight Python IDE (which you may find a productive alternative to PyCharm).

This tutorial introduces you to VS Code as a Python environment, primarily how to edit, run, and debug code through the following tasks:

• Write, run, and debug a Python 'Hello World' Application
• Learn how to install packages by creating Python virtual environments
• Write a simple Python script to plot figures within VS Code

This tutorial is not intended to teach you Python itself. Once you are familiar with the basics of VS Code, you can then follow any of the programming tutorials on python.org within the context of VS Code for an introduction to the language.

If you have any problems, feel free to file an issue for this tutorial in the VS Code documentation repository.

Prerequisites

前提・実現したいことVSCode初心者です。Anacondaで仮想環境をつくって、それを使っています。Excelファイルを操作するためにpandasを使おうとしましたが、xlrdのバージョンを注意されました。(xlrd = 1.0.0) 発生している問題・エラーメッセー. Python pandas visual-studio-code. Follow edited Mar 16 at 11:27. 1,840 3 3 gold badges 20 20 silver badges 41 41 bronze badges. Asked Feb 6 '20 at 14:19. Christina Zhou Christina Zhou. 767 1 1 gold badge 2 2 silver badges 11 11 bronze badges.

To successfully complete this tutorial, you need to first setup your Python development environment. Specifically, this tutorial requires:

• VS Code
• VS Code Python extension
• Python 3

Install Visual Studio Code and the Python Extension

1. If you have not already done so, install VS Code.

2. Next, install the Python extension for VS Code from the Visual Studio Marketplace. For additional details on installing extensions, see Extension Marketplace. The Python extension is named Python and it's published by Microsoft.

Install a Python interpreter

Along with the Python extension, you need to install a Python interpreter. Which interpreter you use is dependent on your specific needs, but some guidance is provided below.

Windows

Install Python from python.org. You can typically use the Download Python button that appears first on the page to download the latest version.

Note: If you don't have admin access, an additional option for installing Python on Windows is to use the Microsoft Store. The Microsoft Store provides installs of Python 3.7, Python 3.8, and Python 3.9. Be aware that you might have compatibility issues with some packages using this method.

For additional information about using Python on Windows, see Using Python on Windows at Python.org

macOS

The system install of Python on macOS is not supported. Instead, an installation through Homebrew is recommended. To install Python using Homebrew on macOS use brew install python3 at the Terminal prompt.

Note On macOS, make sure the location of your VS Code installation is included in your PATH environment variable. See these setup instructions for more information.

Linux

The built-in Python 3 installation on Linux works well, but to install other Python packages you must install pip with get-pip.py.

Other options

• Data Science: If your primary purpose for using Python is Data Science, then you might consider a download from Anaconda. Anaconda provides not just a Python interpreter, but many useful libraries and tools for data science.

• Windows Subsystem for Linux: If you are working on Windows and want a Linux environment for working with Python, the Windows Subsystem for Linux (WSL) is an option for you. If you choose this option, you'll also want to install the Remote - WSL extension. For more information about using WSL with VS Code, see VS Code Remote Development or try the Working in WSL tutorial, which will walk you through setting up WSL, installing Python, and creating a Hello World application running in WSL.

Verify the Python installation

To verify that you've installed Python successfully on your machine, run one of the following commands (depending on your operating system):

• Linux/macOS: open a Terminal Window and type the following command:

• Windows: open a command prompt and run the following command:

If the installation was successful, the output window should show the version of Python that you installed.

Note You can use the py -0 command in the VS Code integrated terminal to view the versions of python installed on your machine. The default interpreter is identified by an asterisk (*).

Start VS Code in a project (workspace) folder

Using a command prompt or terminal, create an empty folder called 'hello', navigate into it, and open VS Code (code) in that folder (.) by entering the following commands:

Note: If you're using an Anaconda distribution, be sure to use an Anaconda command prompt.

By starting VS Code in a folder, that folder becomes your 'workspace'. VS Code stores settings that are specific to that workspace in .vscode/settings.json, which are separate from user settings that are stored globally.

Alternately, you can run VS Code through the operating system UI, then use File > Open Folder to open the project folder.

Select a Python interpreter

Python is an interpreted language, and in order to run Python code and get Python IntelliSense, you must tell VS Code which interpreter to use.

From within VS Code, select a Python 3 interpreter by opening the Command Palette (⇧⌘P (Windows, Linux Ctrl+Shift+P)), start typing the Python: Select Interpreter command to search, then select the command. You can also use the Select Python Environment option on the Status Bar if available (it may already show a selected interpreter, too):

The command presents a list of available interpreters that VS Code can find automatically, including virtual environments. If you don't see the desired interpreter, see Configuring Python environments.

Note: When using an Anaconda distribution, the correct interpreter should have the suffix ('base':conda), for example Python 3.7.3 64-bit ('base':conda).

Selecting an interpreter sets the python.pythonPath value in your workspace settings to the path of the interpreter. To see the setting, select File > Preferences > Settings (Code > Preferences > Settings on macOS), then select the Workspace Settings tab.

Note: If you select an interpreter without a workspace folder open, VS Code sets python.pythonPath in your user settings instead, which sets the default interpreter for VS Code in general. The user setting makes sure you always have a default interpreter for Python projects. The workspace settings lets you override the user setting.

Create a Python Hello World source code file

From the File Explorer toolbar, select the New File button on the hello folder:

Name the file hello.py, and it automatically opens in the editor:

By using the .py file extension, you tell VS Code to interpret this file as a Python program, so that it evaluates the contents with the Python extension and the selected interpreter.

Note: The File Explorer toolbar also allows you to create folders within your workspace to better organize your code. You can use the New folder button to quickly create a folder.

Now that you have a code file in your Workspace, enter the following source code in hello.py:

When you start typing print, notice how IntelliSense presents auto-completion options.

IntelliSense and auto-completions work for standard Python modules as well as other packages you've installed into the environment of the selected Python interpreter. It also provides completions for methods available on object types. For example, because the msg variable contains a string, IntelliSense provides string methods when you type msg.:

Feel free to experiment with IntelliSense some more, but then revert your changes so you have only the msg variable and the print call, and save the file (⌘S (Windows, Linux Ctrl+S)).

For full details on editing, formatting, and refactoring, see Editing code. The Python extension also has full support for Linting.

Run Hello World

It's simple to run hello.py with Python. Just click the Run Python File in Terminal play button in the top-right side of the editor.

The button opens a terminal panel in which your Python interpreter is automatically activated, then runs python3 hello.py (macOS/Linux) or python hello.py (Windows):

There are three other ways you can run Python code within VS Code:

• Right-click anywhere in the editor window and select Run Python File in Terminal (which saves the file automatically):

• Select one or more lines, then press Shift+Enter or right-click and select Run Selection/Line in Python Terminal. This command is convenient for testing just a part of a file.

• From the Command Palette (⇧⌘P (Windows, Linux Ctrl+Shift+P)), select the Python: Start REPL command to open a REPL terminal for the currently selected Python interpreter. In the REPL, you can then enter and run lines of code one at a time.

Configure and run the debugger

Let's now try debugging our simple Hello World program.

First, set a breakpoint on line 2 of hello.py by placing the cursor on the print call and pressing F9. Alternately, just click in the editor's left gutter, next to the line numbers. When you set a breakpoint, a red circle appears in the gutter.

Next, to initialize the debugger, press F5. Since this is your first time debugging this file, a configuration menu will open from the Command Palette allowing you to select the type of debug configuration you would like for the opened file.

Note: VS Code uses JSON files for all of its various configurations; launch.json is the standard name for a file containing debugging configurations.

These different configurations are fully explained in Debugging configurations; for now, just select Python File, which is the configuration that runs the current file shown in the editor using the currently selected Python interpreter.

The debugger will stop at the first line of the file breakpoint. The current line is indicated with a yellow arrow in the left margin. If you examine the Local variables window at this point, you will see now defined msg variable appears in the Local pane.

A debug toolbar appears along the top with the following commands from left to right: continue (F5), step over (F10), step into (F11), step out (⇧F11 (Windows, Linux Shift+F11)), restart (⇧⌘F5 (Windows, Linux Ctrl+Shift+F5)), and stop (⇧F5 (Windows, Linux Shift+F5)).

The Status Bar also changes color (orange in many themes) to indicate that you're in debug mode. The Python Debug Console also appears automatically in the lower right panel to show the commands being run, along with the program output.

To continue running the program, select the continue command on the debug toolbar (F5). The debugger runs the program to the end.

Tip Debugging information can also be seen by hovering over code, such as variables. In the case of msg, hovering over the variable will display the string Hello world in a box above the variable.

You can also work with variables in the Debug Console (If you don't see it, select Debug Console in the lower right area of VS Code, or select it from the ... menu.) Then try entering the following lines, one by one, at the > prompt at the bottom of the console:

Select the blue Continue button on the toolbar again (or press F5) to run the program to completion. 'Hello World' appears in the Python Debug Console if you switch back to it, and VS Code exits debugging mode once the program is complete.

If you restart the debugger, the debugger again stops on the first breakpoint.

To stop running a program before it's complete, use the red square stop button on the debug toolbar (⇧F5 (Windows, Linux Shift+F5)), or use the Run > Stop debugging menu command.

For full details, see Debugging configurations, which includes notes on how to use a specific Python interpreter for debugging.

Tip: Use Logpoints instead of print statements: Developers often litter source code with print statements to quickly inspect variables without necessarily stepping through each line of code in a debugger. In VS Code, you can instead use Logpoints. A Logpoint is like a breakpoint except that it logs a message to the console and doesn't stop the program. For more information, see Logpoints in the main VS Code debugging article.

Install and use packages

Let's now run an example that's a little more interesting. In Python, packages are how you obtain any number of useful code libraries, typically from PyPI. For this example, you use the matplotlib and numpy packages to create a graphical plot as is commonly done with data science. (Note that matplotlib cannot show graphs when running in the Windows Subsystem for Linux as it lacks the necessary UI support.)

Return to the Explorer view (the top-most icon on the left side, which shows files), create a new file called standardplot.py, and paste in the following source code:

Tip: If you enter the above code by hand, you may find that auto-completions change the names after the as keywords when you press Enter at the end of a line. To avoid this, type a space, then Enter.

Next, try running the file in the debugger using the 'Python: Current file' configuration as described in the last section.

Unless you're using an Anaconda distribution or have previously installed the matplotlib package, you should see the message, 'ModuleNotFoundError: No module named 'matplotlib'. Such a message indicates that the required package isn't available in your system.

To install the matplotlib package (which also installs numpy as a dependency), stop the debugger and use the Command Palette to run Terminal: Create New Integrated Terminal (⌃⇧` (Windows, Linux Ctrl+Shift+`)). This command opens a command prompt for your selected interpreter.

A best practice among Python developers is to avoid installing packages into a global interpreter environment. You instead use a project-specific virtual environment that contains a copy of a global interpreter. Once you activate that environment, any packages you then install are isolated from other environments. Such isolation reduces many complications that can arise from conflicting package versions. To create a virtual environment and install the required packages, enter the following commands as appropriate for your operating system:

Note: For additional information about virtual environments, see Environments.

1. Create and activate the virtual environment

   Note: When you create a new virtual environment, you should be prompted by VS Code to set it as the default for your workspace folder. If selected, the environment will automatically be activated when you open a new terminal.

   For Windows

   If the activate command generates the message 'Activate.ps1 is not digitally signed. You cannot run this script on the current system.', then you need to temporarily change the PowerShell execution policy to allow scripts to run (see About Execution Policies in the PowerShell documentation):

   For macOS/Linux

2. Select your new environment by using the Python: Select Interpreter command from the Command Palette.

3. Install the packages

4. Rerun the program now (with or without the debugger) and after a few moments a plot window appears with the output:

5. Once you are finished, type deactivate in the terminal window to deactivate the virtual environment.

For additional examples of creating and activating a virtual environment and installing packages, see the Django tutorial and the Flask tutorial.

Next steps

You can configure VS Code to use any Python environment you have installed, including virtual and conda environments. You can also use a separate environment for debugging. For full details, see Environments.

To learn more about the Python language, follow any of the programming tutorials listed on python.org within the context of VS Code.

To learn to build web apps with the Django and Flask frameworks, see the following tutorials:

There is then much more to explore with Python in Visual Studio Code:

• Editing code - Learn about autocomplete, IntelliSense, formatting, and refactoring for Python.
• Linting - Enable, configure, and apply a variety of Python linters.
• Debugging - Learn to debug Python both locally and remotely.
• Testing - Configure test environments and discover, run, and debug tests.
• Settings reference - Explore the full range of Python-related settings in VS Code.

01 Oct 2020
💬 EN

Table of Contents

• Installing Windows-Store Python & running a Python program
  • Install Python from the Windows store
• IDEs
  • Using our IDE to program
• Modules
  • Installing a “module”
  • Updating Python itself

My beloved Spyder IDE suddenly stopped working on me, and I needed to install Python + Pandas on a new computer anyway, so I decided to explore installing Python (and various packages I use with it such as Pandas) out of the Windows Store, executing code in VSCode as an IDE.

The Windows installation of Python is pretty stripped down, like that of Miniconda, and similarly doesn’t require admin rights to one’s computer.

Therefore, I’ll cover hand-installing a few simple packages as in my older tutorial.

Note: This tutorial is aimed at non-programmers who just want to edit a few CSV files with Python. If you’re a serious data scientist, learn the nuts and bolts of Anaconda at Real Python’s “Setting Up Python for Machine Learning on Windows”

Did you get Python up and running?

Yay! I’m thrilled I could help.

If you’d like, I’d love a Ko-Fi. (Chai for me!) 🥰

Installing Windows-Store Python & running a Python program

Install Python from the Windows store

Click the Windows icon in the bottom-left corner of your screen, and then without clicking anything else, type the word “store.”

The Windows start menu should filter your list of available programs to suggest the Microsoft Store app. Click it.

In the upper right corner of the store window, click the text entry panel next to a magnifying glass and type the word “python” and press enter.

Available software to download should filter itself. Click the piece of Software named “Python #.#” but not “Python #.# (RC)” where “#.#” is some number. I suggest choosing the greatest non-RC number available to you (3.8 at the time of writing this tutorial, although as you can see in the screenshot, 3.7 is also available to me).

Verify the legitimacy of the software by checking that the Python Software Foundation is the publisher of the software, then click the big blue “Get” button.

The button will be replaced by a meter indicating your download and installation progress.

When finished, you can close the Store app.

Click the Windows icon in the bottom-left corner of your screen – at the top of your start menu, you should see “Python #.#” and “IDLE (Python #.#)” software added. (Alternatively, they should be under “P” and “I,” respectively, in your start menu’s main list of programs.)

If you’d like, you can click one of them and try running print('Hello') right from the Python command prompt windows they bring up, but personally, I don’t like interactive Python command lines. I usually need to write multiple-command script files and execute them.

Some tech details for nerds

Skip this little list if it doesn’t make any sense to you

1. The Windows Store seems to install copies of the Python interpreter (a.k.a. the program python.exe), which makes your computer understand code written in the Python programming language at both these two places – I’m not 100% sure which it’s really using, since using where python in the command line tells me one thing but various informational messages in VSCode tell me another:
   • C:UsersYOUR_USERNAMEAppDataLocalMicrosoftWindowsApps
   • C:UsersYOUR_USERNAMEAppDataLocalMicrosoftWindowsAppsPythonSoftwareFoundation.Python.#.#_LONGWEIRDTEXT
2. The Windows Store seems to install PIP, which helps you install and upgrade Python “modules” (extensions to the programming language) , into the same 2 folders as pip.exe.
3. The Windows Store installer seems to do a pretty good job of putting these two executables in your operating system’s PATH environment variable, so that when you simply open a Windows command line and type a command beginning with python such as python --version, or one beginning with pip such as pip --version, they run properly.

Hello World: running a Python program

Open up a nice text editor like Notepad++.

Create a new file. In it, type the following text, using the apostrophe key on your keyboard for the single quotes:

Do “File -> Save As.”

Pick a nice folder for your program (personally, I’m going to save mine under C:example, but you might want to put it on your desktop) and save it there with a filename of “hello.py,” being sure to change the “Save as type” option to “Python file” or to “All Types (.).”

Once you’ve done that, open a “command-line prompt” by hitting the Windows key on your keyboard, typing “cmd,” and hitting “enter.”

At the prompt, type something along the following lines, only changing the file paths to be where your “python.exe” lives and where your “hello.py” lives, and hit your enter key:

You should see “Hello World” right below your command.Go you! You just wrote a program in Python and executed it!

IDEs

Setting up an IDE for pleasant programming

That wasn’t a particularly fun way to code, was it?

If you’ve practiced coding in an online “IDE” like Repl.it or CodeBunk, you know that coding can be as easy as clicking a big “run” button every time you type enough text that you wonder what it does.

To get the same experience, we need to install an “IDE” on our PC.

A popular one is Microsoft’s VSCode.

Install VSCode

Installing VSCode is a straightforward process of downloading the software from Microsoft’s web site and double-clicking the installer file, then following directions as prompted.

I don’t have screenshots because it was already installed on my computer. I have admin rights to the computer I was working on, so please let me know in the comments if this tutorial doesn’t work for you in a pure no-admin-rights context – I suspect I installed VSCode for the whole computer when I installed it.

Once you’ve installed VSCode, run it.

Python-ifying VSCode with a plugin

At the far left of VSCode, click the bottom icon that looks like a square joining 3 other squares to make a bigger square. This will bring you to the Extensions section of VSCode.

In the search box at the top of the left-hand control for Extensions, type “python” and click the official Python plugin published by Microsoft itself.

Click the green Install button.

When your extension finishes installing, it might let you know that there’s a way to change which Python interpreter VSCode uses to facilitate executing code written in the Python programming language.

Go ahead and click “Got it!” if so.

Just for fun, click “Python #.#.# 64-bit” in the bottom-left corner of VSCode.

VSCode’s command pallet will open toward the top center of VSCode and give you an option to choose which python.exe installation on your computer you’d like it to treat at the Python interpreter on your computer.

(Programmers sometimes keep multiple versions of Python installed on their computer all at once.)

Click anywhere outside this command pallet menu to get rid of it. I just wanted to show you around in case you were curious.

Using our IDE to program

Close VSCode and fire it up again. You might not see Python #.#.# 64-bit in the bottom-left corner of VSCode anymore.

That’s okay – you can bring it back by navigating through the top menu to File > Open File and opening the file you saved at, for example, c:examplehello.py.

(Note: I closed out of the tip that popped up telling me I hadn’t yet installed a “linter.”)

You should see that hello.py contains the following code:

To run this code, click the green right-facing triangle (the “play button” / “run button”) toward the top right corner of VSCode.

In the “Terminal” tab of a panel below your code, you should see the words:

It should appear between “command prompts” that say:

Now erase the entire contents of the file, and on line 1, type:

Then click the big green “run” button.

In the “Terminal” output below, do you see the following output text?

Congratulations – you’ve set up VSCode and you’re almost ready to write bigger programs!

In the top menu, click “File” -> “Save” because why not be proud of this working code? It’s good to get used to saving your work as soon as you like it.

Some tech details for nerds

VSCode should have filled in the command prompt before “Hello World” with something along the lines of & python c:/example/hello.py.

The command prompt after “Hello World” should be available for you to type commands into.

Pandas In Visual Studio Code

Try typing “python --version” and hitting enter to confirm that you have a working command prompt to your computer through this panel of VSCode.)

You’ll be using the Terminal’s command prompt when you need to update extensions to Python, so you might as well try your first command in it.

Modules

Checking whether “modules” are installed

Now you need to learn what it looks like when a given extension to the Python language, also known as a “library” or “package” or, particularly in Python, a “module,” is installed.

Backspace out the entirety of your code and on line 1, type:

Click the “run” button.

If you get a dump of text in your console, saying the following, you now know that you don’t have the module called “pandas” installed:

If you do have “pandas” installed, nothing special happens.

If you have “pandas” installed, when you run this code, you just get a new command prompt (“PS C:UsersYOUR_USERNAME>”) in the Terminal pane below.

Let’s fix things and install Pandas so our code runs.

Installing a “module”

When using the Windows Store installation of Python, you’ll use the “pip installer” to install extended Python commands (“modules”) onto your computer so that you can run Python code written with these extended commands.

PIP is just a command-line program that works in the command prompts of the Terminal pane of VSCode. It goes out and downloads things from the internet and installs them on your computer for you.

In the command prompt in your Terminal pane in VSCode, type the following and hit “enter” to execute:

You may notice that PIP downloaded a lot more than just “pandas.” There’s another package that’s highly intertwined with “pandas” called “numpy” that it’s going to download for us … we’ll check after we’re all done that it installed, too.

The download and install takes a few minutes.

The installation process is completete when you see a new command prompt (“PS C:UsersYOUR_USERNAME>”) at the bottom of your the Terminal pane in VSCode.

Run your code again, which, as a reminder, looks like this:

Now you should get the boring “nothing happens except the command prompt incrementing” thing.

Note: If you’d like to see that the “numpy” module also installed, add a 2nd line of code to your program at left and click “Run” again, with the full code being:

Using Pandas In Visual Studio

Installing another module

The same process works for other Python modules, like Simple Salesforce, which makes it easier to download and update data in a Salesforce database.

Running the following code will produce an error if Simple Salesforce is not installed, but will do nothing if it is installed:

To install Simple Salesforce on your computer, just run this command in the VSCode Terminal command prompt:

Note: in pip commands, this module is “simple-salesforce” with a hyphen. When doing an “import” in Python code, it’s an underscore. Not sure why … that’s just how the author packaged it up.

Updating a “module”

Has it been a year, and you’ve heard there are newer & greater versions of Pandas?

At your prompt in the VSCode Terminal, run the following command:

Updating Python itself

If you have, say, version 3.8.0 and you want to bring your system up to the latest version offered in the Microsoft Store (for me today, that’s 3.8.6), you might be able to do so as described in “How to manually update apps and games from the Microsoft Store” by Ciprian Adrian Rusen for Digital Citizen.

If, on the other hand, you chose version 3.7 of Python and want to switch to version 3.8, I think the easiest way to ensure you keep your installation simple would be to simply uninstall Python the way you’d install any program from Windows, then reinstall it.

The only catch is that this will likely uninstall all the modules you’ve installed with pip. Maybe you want a clean start, but for this tutorial, we’ll take a backup of the list of those modules before we begin and reinstall them when done.

1. In your VSCode Terminal panel, type the command pip freeze > c:exampleinstalled-modules.txt(changing the path of the filename to the right of > if you like) and press Enter to execute it.
   • Check out the file you just created – it should list out the Python modules installed on your computer.
2. Click the Windows icon in the bottom-left corner of your screen, and then without clicking anything else, type the words “add or remove programs.”
3. The Windows start menu should filter your list of available programs to suggest the Add or remove programs system configuration area. Click it.
4. In the “Search this list” box, type “python,” click your version of Python that you no longer want, and click the Uninstall button.
5. You’re now in a bit of a weird nowhere-land, where executing a VSCode Terminal command of python --version neither gives you a version number nor denies that python is a legitimate Windows command. If you have a .py file open in VSCode, the bottom right corner also probably gives you a yellow warning message of “Select Python interpreter.” Hopefully we can move past that in a moment.
   • Nerd reason: The uninstall left behind python.exe in C:UsersYOUR_USERNAMEAppDataLocalMicrosoftWindowsApps, so it’s still a valid Windows program.
   • However, that program’s job seems to be to simply call the python.exe from a sub-folder (e.g. PythonSoftwareFoundation.Python.#.#_LONGWEIRDTEXT) with an actual versioned installation of Python in it, so executing python just kind of … does nothing.
6. Once the Windows Store finishes installing your new version of Python, close out any .py files you have open in VSCode.
7. Re-open a .py file such as hello.py that we wrote earlier. VSCode should automatically find your new Python interpreter and put your latest version number into the bottom-left corner.
8. Run your Python file to make sure it works.
   • Tip: Choose a Python file that doesn’t do anything dangerous. Don’t, for example, choose a Python file you once wrote whose job is to delete a bunch of files. Use a simple Hello World script.
9. To restore your old module installations, run the following code in the VSCode Terminal: pip install -r c:exampleinstalled-modules.txt(alter the file path if you saved it somewhere else)
10. Run a Python file containing import statements in the code to verify that your expected modules are now in place, as done above with import pandas and import numpy and import simple_salesforce.

After updating Python, you might also want to update all of your modules at once to their latest versions.

You can do so with the following command suggested in this blog post by ActiveState:

Updating all modules at once

Updating PIP

Funnily, pip itself doesn’t get upgraded when you “update everything,” so if you’re seeing nastygrams that it’s out-of-date, you can also run:

Happy Programming

You now have a working environment for editing CSV files in Python!

1. You have an “IDE,” or as I like to think of it, a “text editor with a run button,” called VSCode, that runs code you type into it as you see fit.
2. You know how to install & update “modules” that you hear might be useful.
   (Be careful and don’t trust any old module you find on the internet. It’s nothing more than “custom code that you’re running on your computer. Make sure it’s not from someone sketchy. Big names like pandas are fine, though.)

Visual Studio Code Pandas Autocomplete

Door Prize

Install Pandas Visual Studio Code

Here’s a “door prize script” to get you started: try copying & pasting it into hello.py in VSCode and running it.

You should see the following output in your console at right:

Unable To Import Pandas Visual Studio Code

Now you’ve opened a CSV spreadsheet file with Python – you’re off to the races! Head here to learn new skills and put them in action on your computer.