[PYTHON] I tried to expand the database so that it can be used with PES analysis software

We will automate the data analysis of PES! Part7

■ Introduction

■ Contents of this article

The software in this article is written in python. ■ Reference URL

▼ List of extended functions of analysis application

  1. Player authentication function
  2. Data reading function from database
  3. A function to output metric data in CSV from the match result image
  4. Ability to add CSV metrics data to the database

■ Background to database management

It's too annoying!

So move on to database management! Master data will grow even if it is left unattended if a mechanism is created in which the analysis results of each player are aggregated in a database.

■ Introduction for each extension

▼ What is the database like?

● When you actually move, it looks like this ↓

▼ Read data from database

● Data manipulation from user authentication looks like this

▼ CSV file output from image data

● From user authentication to CSV output like this

● Contents of the specified folder after image processing

▼ Add to database

● Database after addition

■ Remaining tasks

I think it's a bug. .. In my opinion, bug fix is the most growing experience, so I would like to take it positively.

■ Prospect

Personally, who will win if XX players and XX players are played against each other! ?? I want to let you do something like that softly! Lol For that purpose, this analysis software is necessary as a mechanism for collecting data.

■ End

This article ends here! Please look forward to the next time ♪

■ Reference URL

Recommended Posts

I tried to expand the database so that it can be used with PES analysis software
I tried to make OneHotEncoder, which is often used for data analysis, so that it can reach the itch.
I tried to summarize the operations that are likely to be used with numpy-stl
I tried to automatically extract the movements of PES players with software
I tried to publish my own module so that I can pip install it
I tried to predict the horses that will be in the top 3 with LightGBM
It seems that cancelall childorders can be used to cancel all parent orders (special orders) with the bitflyer API
I tried to scrape YouTube, but I can use the API, so don't do it.
I investigated the pretreatment that can be done with PyCaret
I tried to expand the size of the logical volume with LVM
[Flask] I tried to summarize the "docker-compose configuration" that can be created quickly for web applications
I tried to make a calculator with Tkinter so I will write it
File types that can be used with Go
I tried to save the data with discord
When I tried to change the root password with ansible, I couldn't access it.
I tried using the Python library "pykakasi" that can convert kanji to romaji.
Moved Raspberry Pi remotely so that it can be LED attached with Python
I made a familiar function that can be used in statistics with Python
Read the image posted by flask so that it can be handled by opencv
I didn't understand the Resize of TensorFlow so I tried to summarize it visually.
I wanted to quickly create a mail server that can be used freely with postfix + dovecot on EC2
In IPython, when I tried to see the value, it was a generator, so I came up with it when I was frustrated.
I wanted to know the number of lines in multiple files, so I tried to get it with a command
I tried to learn the sin function with chainer
List of tools that can be used to easily try sentiment analysis of Japanese sentences in Python (try with google colab)
Convert images from FlyCapture SDK to a form that can be used with openCV
I tried to touch the CSV file with Python
I tried to predict the J-League match (data analysis)
I tried to solve the soma cube with python
Python knowledge notes that can be used with AtCoder
[Python] Introduction to web scraping | Summary of methods that can be used with webdriver
I tried to make a memo app that can be pomodoro, but a reflection record
I tried to solve the problem with Python Vol.1
I wanted to operate google spread sheet with AWS lambda, so I tried it [Part 2]
It's getting cold, so I tried to make it possible to turn on / off the AC heater automatically with Raspberry Pi!
I don't like to be frustrated with the release of Pokemon Go, so I made a script to detect the release and tweet it
I tried to check with the help of neural networks whether "Japanese" only "unreadable fonts" can really be read only by Japanese.
Install Mecab and CaboCha on ubuntu16.04LTS so that it can be used from python3 series
I want to see something beautiful, so I tried to visualize the function used for benchmarking the optimization function.
Sentiment analysis with natural language processing! I tried to predict the evaluation from the review text
[Atcoder] [C ++] I made a test automation tool that can be used during the contest
There was a doppelganger, so I tried to distinguish it with artificial intelligence (laughs) (Part 1)
I tried to predict the sales of game software with VARISTA by referring to the article of Codexa
How to set variables that can be used throughout the Django app-useful for templates, etc.-
I tried to find the entropy of the image with python
I tried to simulate how the infection spreads with Python
It seems that Skeleton Tracking can be done with RealSense
I tried to analyze the whole novel "Weathering with You" ☔️
I tried to find the average of the sequence with TensorFlow
Goroutine (parallel control) that can be used in the field
I tried to summarize the code often used in Pandas
Goroutine that can be used in the field (errgroup.Group edition)
I tried to summarize the commands often used in business
I tried to divide the file into folders with Python
[For IT beginners] What to do when the rev command cannot be used with Git Bash
I made it because I want JSON data that can be used freely in demos and prototypes
When I tried to use pip with python, I was told that XML_SetHashSalt could not be found.
I tried hitting the Google API with Ruby and Python-Make the database a Spreadsheet and manage it with Google Drive
I bought and analyzed the year-end jumbo lottery with Python that can be executed in Colaboratory
Understand the probabilities and statistics that can be used for progress management with a python program
A story that didn't work when I tried to log in with the Python requests module