Percentage of LIKE for pymysql

python3.x Using the library pymysql connection = pymysql.connect (...) I wanted to move the partial match LIKE statement ``` with connection.cursor() as cursor: cursor.execute("SELECT c1 FROM

GPU check of PC on jupyter notebook

# memorandum By adding the "!" Symbol, you can execute the command on cmd even on notebook, so as follows ``` !nvidia-smi ``` ``` (base) C:\Users\user>nvidia-smi Sun Nov 15 00:00:00 2020 +----

Summary of situations where plotly express can be used [When can you use it from matplotlib? ]

## Introduction Speaking of drawing graphs, matplotlib + serborn is the major one. Beyond these ** Plotly express has the potential to create interactive graphs. ** ** I would like to focus on the

AtCoder Beginner Contest 183 Note

# Preface I tried Atcoder, so it's a memo for myself. I plan to add and correct it later. # problem https://atcoder.jp/contests/abc183 A #### **`Q_A.go`** ```go package main import ( "f

Mask RCNN Object Measurement Package (Measurement of object diameter with Mask RCNN)

# About this ROS package I made something like this Using an RGBD sensor such as RealSense, deep learning distinguishes and infers multiple arbitrary objects, and calculates the maximum and minimum d

I made an anomaly detection model that works on iOS

## background I want to create an application for agriculture x deep learning! Based on this motive, I think we can create an app that diagnoses the health condition of crops by inputting images o

Shell variables, environment variables

# [Shell variables, environment variables] ## Shell variables -Variables that the shell has (programs that convey input from people) -Variables that are valid only for the shell that is currently

Mahjong winning judgment algorithm

# Mahjong winning judgment algorithm It is not an algorithm to find the number of listenings, which checks whether the completion of 14 Tehai is completed. ## data form ONE-HOT is used for the til

[PyTorch Tutorial ⑧] Torch Vision Object Detection Finetuning Tutorial

# Introduction This is the 8th installment of PyTorch [Official Tutorial](https://pytorch.org/tutorials/) following [Last time](https://qiita.com/sudominoru/items/975b9d222e5fcdf7bf4c). This time, w

Broadcast on LINE using python

# Introduction Since the information was broadcast from the system on LINE, I will leave the procedure at that time. LINE has separate LINE @ and LINE official accounts, but they seem to have been

1. Statistics learned with Python 2-1. Probability distribution [discrete variable]

* ** Discrete random variable ** is a variable that takes discrete values like a dice, for example, "1" is followed by "2", "2" is followed by "3", and so on. In the meantime, there are no continuous

Limit public symbols in shared libraries

# Introduction When developing a shared library, You will want to limit public symbols to prevent misuse and to improve performance. If you simply set it to file scope, you cannot call it from ano

Take a closer look at the Kaggle / Titanic tutorial

# Introduction I tried [Tutorial](https://www.kaggle.com/alexisbcook/titanic-tutorial) in [Kaggle's Titanic](https://www.kaggle.com/c/titanic). Random by copy and paste I was able to make predictions

Reinforcement learning 1 introductory edition

[Aidemy](https://aidemy.net/) 2020/11/15 # Introduction Hello, it is Yope! I am a liberal arts student, but I was interested in the possibilities of AI, so I went to the AI-specialized school "Aidemy

Hard links and symbolic links

# Notes on studying hard links and symbolic links Environment: CentOS7 ## Terms that appear - File A unit of information recorded and managed on a computer Regular files and link files are now

AtCoder devotion memo (11/12)

It is a memo of devotion in AtCoder. I'm sorry that there is a mixture of tones and tones. [AGC008B - Contiguous Repainting](https://atcoder.jp/contests/agc008/tasks/agc008_b) diff:1821 Result:

[Python] Easy introduction to machine learning with python (SVM)

# Introduction When I look at the introductory site about machine learning, I get the impression that it is difficult for people with zero knowledge to get along with it because it says something dif

[MariaDB] Install MariaDB on Linux and create a DB and an operating user.

This is a memo when MariaDB is installed to use EC2 of Linux2 as a DB server on AWS. (Overwhelmingly for myself) First of all ``` sudo yum update -y ``` installation of mariaDB ``` sudo yum -

[Super Introduction to Machine Learning] Learn Pytorch tutorials

This is a compilation of what the author wrote instead of a memo, which the author has not yet grasped the whole picture. I will summarize the contents of the Pytorch tutorial + the contents examin

Get html from element with Python selenium

# Task I am using selenium and want to get the source HTML for the elements obtained by find_element_by_〇〇 such as find_element_by_class_name. I try to get the source with .page_source, but ``` At

Solved the problem that sqlite3 got undefined error when cross-compiling Golang

# What I tried to do I tried to cross-compile Golang scripts to run on Amazon Linux # What happened When I build it for Mac, I can build it normally and it works, but when I build it for linux, I ge

I tried to implement multivariate statistical process management (MSPC)

* Articles sent by data scientists from the manufacturing industry * This time, we have implemented and organized anomaly detection methods that can be used in the manufacturing industry. ## Intro

From preparation for morphological analysis with python using polyglot to part-of-speech tagging

## Preparation Use polyglot ([Document](https://polyglot.readthedocs.io/en/latest/index.html)). The following has been confirmed to work with Python 3.8.5. First, ```terminal pip install numpy

Golang api get

I'm studying Golang. ## things to do --Hit Rakuten Rapid Api with Golang --Set APIKey in config.ini and call it from main.go file. --Furthermore, separate the function into another file and call

Bootstrap sampling with Pandas

# A little script for Bootstrap sampling in Pandas Bootstrap sampling is used to randomly retrieve data from a sample, allowing duplication, to create a slightly different population. For example, I

I want to get custom data attributes of html as elements using Python Selenium

In HTML documents, id is unique in the document but class is not, so if there are multiple identical class names in the document, you may need to turn the result of find_elements_by_class_name () (el

Import error even though python is installed

I'm installing python with VScode, but I'm getting an import error. ![スクリーンショット 2020-11-14 22.52.07.png](https://qiita-image-store.s3.ap-northeast-1.amazonaws.com/0/849608/5a0260a6-b622-133a-5de1-f

How to install and use pandas_datareader [Python]

In this article How to install and use pandas_datareader I will write. ## What is pandas_datareader? pandas_datareader is a Python library that can collect economic data and price data of financi

The meaning of self

Without self, it becomes indistinguishable from local variables (variables initialized inside the function). ``` class Sample: num = 100 def show_num(self): num = 200 print(s

Import Error: libffi.so.6: cannot open shared object file: No such file or directory

TL;DR This is the solution when Jupyter notebook fails to start because the file `libffi.so.6` could not be imported. In my environment, `pyenv` was used to manage the version of python, so it is fo