<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[spiral1221的博客]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/spiral1221</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; spiral1221]]></copyright><item><title><![CDATA[python处理指针类的问题]]></title><link>https://blog.youkuaiyun.com/spiral1221/article/details/81739041</link><guid>https://blog.youkuaiyun.com/spiral1221/article/details/81739041</guid><author>spiral1221</author><pubDate>Thu, 16 Aug 2018 11:52:50 +0800</pubDate><description><![CDATA[最近在刷leetcode上的题，因为本身不懂C所以第一次看到ListNode类型一脸懵逼。首先，ListNode的定义：


class ListNode:
    def __init__(self, x):
        self.val = x
        self.next = None

就两个属性 value 和 next，因为单节点默认next是没有值的。

现在创建一个单链条...]]></description><category></category></item><item><title><![CDATA[python模块导入]]></title><link>https://blog.youkuaiyun.com/spiral1221/article/details/81565413</link><guid>https://blog.youkuaiyun.com/spiral1221/article/details/81565413</guid><author>spiral1221</author><pubDate>Fri, 10 Aug 2018 16:27:24 +0800</pubDate><description><![CDATA[之前一直搞不清楚什么时候用 import module from path， 什么时候用 import module 。最近看到一个例子好像有点儿明白


from math import sqrt
sqrt(4)
&amp;gt;&amp;gt;&amp;gt; 2

from cmath import sqrt
sqrt(4)
&amp;gt;&amp;gt;&amp;gt; (2+0j)

import module from path ...]]></description><category></category></item><item><title><![CDATA[【leetcode】601. 体育馆的人流量]]></title><link>https://blog.youkuaiyun.com/spiral1221/article/details/81457003</link><guid>https://blog.youkuaiyun.com/spiral1221/article/details/81457003</guid><author>spiral1221</author><pubDate>Mon, 06 Aug 2018 16:50:00 +0800</pubDate><description><![CDATA[ 

 

 

解决思路：

 

 

代码实现：


SELECT a.*
FROM Leetcode_stadium a,
  (SELECT id - rownum AS TYPE,
          group_concat(id) idlist
   FROM
     (SELECT @rn := @rn+1 AS rownum, t.id,
                  ...]]></description><category></category></item><item><title><![CDATA[【leetcode】177. 第N高的薪水]]></title><link>https://blog.youkuaiyun.com/spiral1221/article/details/81451910</link><guid>https://blog.youkuaiyun.com/spiral1221/article/details/81451910</guid><author>spiral1221</author><pubDate>Mon, 06 Aug 2018 14:16:07 +0800</pubDate><description><![CDATA[

这题其实和177思想比较接近，排序就行了

代码：


CREATE FUNCTION getNthHighestSalary(N INT) RETURNS INT
BEGIN
  RETURN (
      # Write your MySQL query statement below.
  select Salary from (SELECT a.Salary, (SELECT cou...]]></description><category></category></item><item><title><![CDATA[【leetcode】178 分数排名]]></title><link>https://blog.youkuaiyun.com/spiral1221/article/details/81449376</link><guid>https://blog.youkuaiyun.com/spiral1221/article/details/81449376</guid><author>spiral1221</author><pubDate>Mon, 06 Aug 2018 11:11:39 +0800</pubDate><description><![CDATA[描述如下：



实现思路：

实质就是要统计全表小于某一个score数值的个数。如果并列排名的话可以直接：


SELECT a.score,
  (SELECT count(1)
   FROM leetcode_scores
   WHERE score &amp;gt; a.score)+1 AS rank
FROM leetcode_scores a
ORDER BY rank

但是这里多了一...]]></description><category></category></item><item><title><![CDATA[正则表达式 去掉字符串后面所有的内容]]></title><link>https://blog.youkuaiyun.com/spiral1221/article/details/81358745</link><guid>https://blog.youkuaiyun.com/spiral1221/article/details/81358745</guid><author>spiral1221</author><pubDate>Thu, 02 Aug 2018 14:46:59 +0800</pubDate><description><![CDATA[例如 ：`last_lyq_zhima_verify_time` bigOMMENT '' ,  只保留`last_lyq_zhima_verify_time`]]></description><category></category></item><item><title><![CDATA[superset安装部署]]></title><link>https://blog.youkuaiyun.com/spiral1221/article/details/77199152</link><guid>https://blog.youkuaiyun.com/spiral1221/article/details/77199152</guid><author>spiral1221</author><pubDate>Tue, 15 Aug 2017 19:50:38 +0800</pubDate><description><![CDATA[superset可以理解为一种开源版本的Tableau，后端基于Python实现的。最近正好有个需求是把做好的数据分析表用网页展现可以用上这个。
看了一些资料都推荐在虚拟环境部署，我选择了miniconda （安装包链接），下载好后运行：
$ chmod 777 Miniconda2-latest-MacOSX-x86_64.sh 
$ ./Miniconda2-latest-MacOSX-x]]></description><category></category></item><item><title><![CDATA[理解pandas的groupby().apply()]]></title><link>https://blog.youkuaiyun.com/spiral1221/article/details/76152002</link><guid>https://blog.youkuaiyun.com/spiral1221/article/details/76152002</guid><author>spiral1221</author><pubDate>Wed, 26 Jul 2017 16:13:53 +0800</pubDate><description><![CDATA[如何理解《利用Python进行数据分析》第2章1880-2010年间全美婴儿姓名例子中的names.groupby(['year', 'sex']).apply(add_prop)]]></description><category></category></item></channel></rss>