Create and Setup Python Development Environment

Introduction

GitHub Codespaces is nothing but Visual Studio Code running on Linux hosted in Azure using your GitHub account. This means you can open your Project code directly from GitHub repository page in your favorite development environment (VSCode IDE) with all necessary dependencies to start working/testing/running. This is cool because there is nothing to install or mess with your local computer configuration as it completely runs in the browser.

If you like to start with Visual Studio Codespaces instead, see my previous article. Most of the customization described in this article works on both Visual…


Read/Write Google Sheet using Pandas DataFrame

In this article, I would like to explain the options to read and write google sheets using python. The Google Sheets API lets us read and modify any aspect of a spreadsheet. Accessing this functionality using Python and linking to Python DataFrames helps us to automate and do more data analysis.

Install Required Software and Libraries:

Before jumping into the steps to achieve this, we need to have the following:


Setup Codespace with VNC server in Visual Studio Code

Introduction

Visual Studio Codespaces is a cloud based development environment. As this is completely in the cloud, we can connect to it either using Visual Studio Code or any browser from anywhere. Codespaces is subscription based environment if you are creating the cloud-hosted Codespace in Azure, which is charged as per the usage. You can also setup Self-hosted Codespace on your machine, which is free of charge.

Install and Set Up VS Code on Windows 10, if you don’t have it

Instructions to install VS Code on Windows 10 and integrate MobaXterm terminal can be found in my previous article.

Install Codespaces Plugin in VS Code

Open Extensions Marketplace using Ctrl+Shift+X keyboard…


Setup VS Code on Windows 10 to connect to Linux using Remote-SSH

Introduction

Visual Studio Code is my favorite Integrated Developer Environment (IDE) because of it’s clean design, large selection of plugins and cross-platform support. In this article, let’s setup VS Code on Windows 10 laptop to connect to Linux using one of it’s plugin: Remote-SSH.

Install and Set Up VS Code on Windows 10, if you don’t have it

Instructions to install VS Code on Windows 10 and integrate MobaXterm terminal can be found in my previous article.

Generate SSH Key Pair, skip if you already have it

Open a new Terminal in VS Code (Terminal > New Terminal), this will open integrated MobaXterm Terminal. …


Develop in Windows with Linux Terminal

MobaXterm Teminal in VS Code and MobaXterm

In this post, let’s see how to set up a clean environment in Windows using Visual Studio Code.

First, we need to download VS Code Installer from official site. As I prefer to try everything as non-admin user, download the 64 bit User Installer 1.46.0 version. Run the downloaded “VSCodeUserSetup-x64–1.46.0.exe”, install with these options: location - “C:\Users\UserName\Apps\VSCode”, No Start Menu folder, Select all Additional Tasks. Launch VS Code, we have a nice, clean editor for our development.

If you prefer not to share all your data usage and errors to Microsoft, open settings File

Naga Sanka

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store