- 博客(8)
- 收藏
- 关注
RSS订阅原创 np.percentile()函数超详解
官方文档入口：https://docs.scipy.org/doc/numpy/reference/generated/numpy.percentile.html函数：np.percentile(a, q, axis=None, out=None, overwrite_input=False, interpolation='linear', keepdims=False)作用：找到一...
2018-11-29 19:43:10
54252
原创 sqlzoo_Self join
1.How many stops are in the database.select count(id) from stops2.Find the id value for the stop 'Craiglockhart'select id from stops where name = 'Craiglockhart'3.Give the id and the name ...
2018-09-18 17:05:07
711
原创 notebook_pyaotugui
原本是想写个阴阳师脚本的，但是发现手机模拟器早已自带一些简单的脚本录制功能，只能以后学学图片识别了再深入写一下进阶的脚本了。本文为从pyaotugui官网https://pyautogui.readthedocs.io/en/latest/进行模块学习时所做的一些简单的笔记，模块本身的内容不多，后续学习再慢慢添加内容。 导入模块import pyautogui#基本操作pyau...
2018-09-17 15:27:03
403
原创 sqlzoo_Using Null
1.List the teachers who have NULL for their department.select name from teacher where dept IS NULL 2.Note the INNER JOIN misses the teachers with no department and the departments with no t...
2018-07-22 23:09:50
305
原创 sqlzoo_More JOIN operations
1.List the films where the yr is 1962 [Show id, title]SELECT id, title FROM movie WHERE yr=19622.Give year of 'Citizen Kane'.select yrfrom moviewhere title = 'Citizen Kane'3.List all o...
2018-07-22 21:13:19
269
原创 sqlzoo_The JOIN operation
1.The first example shows the goal scored by a player with the last name 'Bender'. The * says to list all the columns in the table - a shorter way of saying matchid, teamid, player, gtime.Modify it to...
2018-07-22 17:30:28
443
原创 sqlzoo_SUM and COUNT
1.Show the total population of the world.SELECT SUM(population) FROM world2.List all the continents - just once each.select distinct continent from world3.Give the total GDP of Africase...
2018-07-21 16:36:31
249
原创 sqlzoo_SELECT within SELECT Tutorial
1.List each country name where the population is larger than that of 'Russia'.SELECT name FROM world WHERE population > (SELECT population FROM world WHERE name='Russia')2.Show t...
2018-07-21 13:47:51
291
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人