importnumpyasnp,pandasaspd,os,matplotlib.pyplotasplt,seabornassnsimportjson,re,gc#garbage collectorfromsklearn.preprocessingimportLabelEncoderfromastimportliteral_evalfromsklearn.model_selectionimportKFoldfromsklearn.metricsimportmean_squared_errorfromsklearn.model_selectionimportGridSearchCV#Experimented hyperparams a bit with thisfromcatboostimportCatBoostRegressorfromxgboostimportXGBRegressorimportlightgbmaslgbfordirname,_,filenamesinos.walk('/home/masaru/data/kaggle_google_analytics'):forfilenameinfilenames:print(os.path.join(dirname,filename))passgc.enable()sns.set(style='whitegrid',palette='deep',font_scale=1.1,rc={'figure.figsize':[8,6]})pd.set_option('float_format','{:f}'.format)#to display full numbers in dataframe and not just exponentiated form
# -*- coding: utf-8 -*-
import psycopg2
import pandas as pd
import plotly as py
import plotly.graph_objs as go
from plotly.offline import iplot, init_notebook_mode
init_notebook_mode()
# IPv4 local connections:
host all all 127.0.0.1/32 md5
host all all 192.168.100.1/24 md5
ユーザーの作成
postgres=# create role masaru with superuser login;
select * from pg_shadow;
usename | usesysid | usecreatedb | usesuper | userepl | usebypassrls | passwd | valuntil | useconfig
----------+----------+-------------+----------+---------+--------------+--------+----------+-----------
postgres | 10 | t | t | t | t | | |
masaru | 16384 | f | t | f | f | | |
(2 rows)
postgres=# alter role masaru with password 'xxxxxxxxxxx';
ALTER ROLE
masaru@ASUS-TUF-Gaming:~$ sudo add-apt-repository -y -n ppa:graphics-drivers/ppaPPA publishes dbgsym, you may need to include 'main/debug' component
Repository: 'deb http://ppa.launchpad.net/graphics-drivers/ppa/ubuntu/ hirsute main'
Description:
Fresh drivers from upstream, currently shipping Nvidia.
## Current Status
Current long-lived branch release: `nvidia-430` (430.40)
Dropped support for Fermi series (https://nvidia.custhelp.com/app/answers/detail/a_id/4656)
Old long-lived branch release: `nvidia-390` (390.129)
For GF1xx GPUs use `nvidia-390` (390.129)
For G8x, G9x and GT2xx GPUs use `nvidia-340` (340.107)
For NV4x and G7x GPUs use `nvidia-304` (304.137) End-Of-Life!
Support timeframes for Unix legacy GPU releases:
https://nvidia.custhelp.com/app/answers/detail/a_id/3142
## What we're working on right now:
- Normal driver updates
- Help Wanted: Mesa Updates for Intel/AMD users, ping us if you want to help do this work, we're shorthanded.
## WARNINGS:
This PPA is currently in testing, you should be experienced with packaging before you dive in here:
Volunteers welcome!
### How you can help:
## Install PTS and benchmark your gear:
sudo apt-get install phoronix-test-suite
Run the benchmark:
phoronix-test-suite default-benchmark openarena xonotic tesseract gputest unigine-valley
and then say yes when it asks you to submit your results to openbechmarking.org. Then grab a cup of coffee, it takes a bit for the benchmarks to run. Depending on the version of Ubuntu you're using it might preferable for you to grabs PTS from upstream directly: http://www.phoronix-test-suite.com/?k=downloads
## Share your results with the community:
Post a link to your results (or any other feedback to): https://launchpad.net/~graphics-drivers-testers
Remember to rerun and resubmit the benchmarks after driver upgrades, this will allow us to gather a bunch of data on performance that we can share with everybody.
If you run into old documentation referring to other PPAs, you can help us by consolidating references to this PPA.
If someone wants to go ahead and start prototyping on `software-properties-gtk` on what the GUI should look like, please start hacking!
## Help us Help You!
We use the donation funds to get the developers hardware to test and upload these drivers, please consider donating to the "community" slider on the donation page if you're loving this PPA:
http://www.ubuntu.com/download/desktop/contribute
More info: https://launchpad.net/~graphics-drivers/+archive/ubuntu/ppa
Adding repository.
Adding deb entry to /etc/apt/sources.list.d/graphics-drivers-ubuntu-ppa-hirsute.list
Adding disabled deb-src entry to /etc/apt/sources.list.d/graphics-drivers-ubuntu-ppa-hirsute.list
Adding key to /etc/apt/trusted.gpg.d/graphics-drivers-ubuntu-ppa.gpg with fingerprint 2388FF3BE10A76F638F80723FCAE110B1118213C
masaru@ASUS-TUF-Gaming:~/Downloads$ bash ./Anaconda3-2020.11-Linux-x86_64.sh
Welcome to Anaconda3 2020.11
In order to continue the installation process, please review the license
agreement.
Please, press ENTER to continue
...
masaru@ASUS-TUF-Gaming:~/anaconda3/bin$ ./conda init
no change /home/masaru/anaconda3/condabin/conda
no change /home/masaru/anaconda3/bin/conda
no change /home/masaru/anaconda3/bin/conda-env
no change /home/masaru/anaconda3/bin/activate
no change /home/masaru/anaconda3/bin/deactivate
no change /home/masaru/anaconda3/etc/profile.d/conda.sh
no change /home/masaru/anaconda3/etc/fish/conf.d/conda.fish
no change /home/masaru/anaconda3/shell/condabin/Conda.psm1
no change /home/masaru/anaconda3/shell/condabin/conda-hook.ps1
no change /home/masaru/anaconda3/lib/python3.8/site-packages/xontrib/conda.xsh
no change /home/masaru/anaconda3/etc/profile.d/conda.csh
modified /home/masaru/.bashrc
(base) masaru@ASUS-TUF-Gaming:~$ conda update --all
Collecting package metadata (current_repodata.json): done
Solving environment: done
## Package Plan ##
environment location: /home/masaru/anaconda3
The following packages will be downloaded:
package | build
---------------------------|-----------------
_anaconda_depends-2020.07 | py38_0 6 KB
...
