Lecture: How to use Pivot Table in Excel
mishouI. A sample data file (CSV) 2023localWelfareQnn1Download II. Creating a pivot table and a pie chart in Excel You can see the Excel sheets here: 2023localWelfareQnn1
Lecture: Reading a table in a PDF and merging data frames using Excel or Python, vlookup, tabula-py
I. The data 各都道府県の検査陽性者の状況 (PDF) 第2表 都道府県、男女別人口及び人口性比―総人口、日本人人口（2022年10月1日現在)（エクセル：20KB） II. Using Python (positive cases) You can see all the script here on Google Colaboratory: https://colab.research.google.com/drive/1E4AUtEXN4QJH4lh4v_FLKFj6EszIPJKo?usp=sharing III. Excel (deaths) Using VLOOKUP What the VLOOKUP…
Excel: How to ask ChatGPT ver. 3
I. If you don't know how to ask ChatGPT about Excel usage, why don't you ask ChatGPT? I typed: I want to ask you about how to use Excel but…
Applications: How to use Vim key bindings in Google Colaboratory
I. Setting ups for Vim keybindings Select "vim" at Tools>Settings>Editor>Key bindings>vim II. Using Vim keybindings 1. Create or select a cell Create a new code cell belowCtrl + m, b…
Lectures: How to use Google Sheets
I. Google Sheets tips You can learn Google Sheets tips here: 40 Advanced Google Sheets Tips for Marketing Pros I have created some sheets using the tips above and add…
Neovim: How to use Buffers, Windows and Tabs
I. Buffers, Windows and Tabs Now suppose you have four files in the current directory: Run the following command in the terminal: nvim sample1.txt sample2.txt sample3.txt sample4.txt You can see…
Neovim: Get started with Bob
I. What is Bob? Bob is a cross-platform and easy-to-use Neovim version manager, allowing for easy switching between versions right from the command line. https://github.com/MordechaiHadad/bob II. Installation Build prerequisites rustup…
Neovim: Learning Neovim Configuration using bob
I. Let's learn Neovim Configuration Configuring Neovim can be a time-consuming task, but I believe that practicing is the best way to master it. In this post, I’ll share some…
Neovim: Installing Sniprun to run code interactively
I. Sniprun Sniprun is a code runner plugin for neovim written in Lua and Rust. It aims to provide stupidly fast partial code testing for interpreted and compiledlanguages. Sniprun blurs the…
R: Running R codes in Neovim with Nvim-R
I. What is Nvim-R? See the the following tutorial linked below : https://github.com/jamespeapen/Nvim-R/wiki/Use II. Installing Nvim-R with Pucker Add the following line to the plug.lua file. use { 'jalvesaq/Nvim-R', branch…