Category: Python

Python -Create, write and read file -VS Code on Ubuntu No.35

Posted on by kumoman

How to create, write and read a file using Python in Visual Studio Code on Ubuntu is shown in this blog. Contents ▼1. Creating, write and read a file using Python▼2. Prerequisites▼3. Creating a JSON file and then reading it by Python3-1. Creating a JSON file3-2. Creating, writing and reading a JSON file using Python code3-3. Runnig writes.py▼4. Reference▼1. Creating, write and read a file using Python open() function is used to create a file or edit a file. there are 2 elementary parameters of open() Python function for specifying a file name and the mode of a file operation. There are some modes as below. Mode Description ‘r’ open … Continue reading “Python -Create, write and read file -VS Code on Ubuntu No.35”

Python – Using Visual Studio Code on Ubuntu No.34

Posted on by kumoman

How to run python code in Visual Studio Code on Ubuntu is shown in this blog. Contents ▼1. Let’s write python code in Visual Studio Code▼2. Prerequisites2-2. Installing Visual Studio Code2-3. Installing Python extension2-4. Installing Python interpriter2-5. Starting VS Code▼3. Showing Hello World using Python3-1. Creating python code3-2. Run the Python code3-3. How to debug the python code▼4. 参考情報▼1. Let’s write python code in Visual Studio Code In Visual Studio Code, there are many available programming languages. e.g) Java, C, C++, Python etc on Windows OS, Mac OS and Linux. in this case, I will try to use python. Python doesn’t require compile and it’s an interpreted language. Ref: Get … Continue reading “Python – Using Visual Studio Code on Ubuntu No.34”

Python – Creating sample data in SQL Server on Ubuntu No.62

Posted on by kumoman

How to create sample data in SQL Server on Ubuntu is shown in this blog. These steps are available for Windows OS, too. Contents ▼1. What is Microsoft SQL Server ?▼2. Prerequisites▼3. Creating sample data in bulk3-1. Preparation3-2. Developing “insertmultipledata.sql” to create sample data by python3-3. Executing the sql statement in “insertmultipledata.sql” by sqlcmd.exe3-4. Confirming the generated sample data using sqlcmd.exe▼4. Reference▼1. What is Microsoft SQL Server ? There are many kinds of SQL Server. for example, Azure SQL Database in cloud, Azure Synapse Analytics – SQL pool (SQL Data Warehouse) and on-premise SQL Server on Azure Virtual Machine (VM) etc We can find the version of SQL Server and hot … Continue reading “Python – Creating sample data in SQL Server on Ubuntu No.62”

Python – How to connect to SQL Server on Ubuntu  No.92

Posted on by kumoman

How to connect and run select query for a table in SQL Server on Ubuntu using Microsoft ODBC Driver for SQL Server by Python are shown in this blog. Contents ▼1. Connecting to SQL Server on Ubuntu▼2. Connecting to SQL Server and Select using Python2-1. Installing SQL Server on Linux2-2. Installing Microsoft ODBC Driver for SQL Server2-3. Creating a python code to connect to SQL Server on Linux and run Select2-4. Results of this python code when it work fine.▼3. Reference▼1. Connecting to SQL Server on Ubuntu In the past, how to connect and run queries using Java are shown in this blog as below. (As of 2022/12) ▼2. Connecting … Continue reading “Python – How to connect to SQL Server on Ubuntu  No.92”

Python – WordCloud in Japanese – VS Code on Ubuntu No.90

Posted on by kumoman

How to implement Word Cloud in Japanese using python in Visual Studio Code on Ubuntu is shown in this blog. Contents ▼1. What is WordCloud?▼2. Prerequisites2-1. Preparing for Python environment2-2. Installing WordCloud2-3. Downloading Japanese Font2-4. Copying Japanese text from Wiki2-5. Starting VS Code▼3. Let’s run WordCloud using Python 3-1. Creating Python code to run WordCloud3-2. Result▼4. Reference▼1. What is WordCloud? WordCloud is a visualization tool to show the valuable word using the size of a word based on the frequency. The wiki of 2022 FIFA Qatar world cup is used for the wordcloud in Japanese. 2022 FIFAワールドカップ ▼2. Prerequisites 2-1. Preparing for Python environment Python – Visual Studio Code の利用 … Continue reading “Python – WordCloud in Japanese – VS Code on Ubuntu No.90”