摘要: def shopping_procedure(): milk_tea_no = input('请选择您要购买的奶茶编号:') goods_dic={} while True: if milk_tea_no not in goods_dic.keys(): if int(milk_tea_no) <= 阅读全文
posted @ 2018-04-15 17:46 王大锤的百变小蜡笔 阅读(2252) 评论(0) 推荐(0) 编辑
摘要: 先贴一篇IBM沃森文本分析历届美国总统就职的演讲稿:http://36kr.com/p/5062661.html 2017年1月20日中午,唐纳德-特朗普在首都华盛顿宣誓就职,正式成为美国第45任总统。完成了从房地产老板直接到美国总统的华丽转身!今儿我们就对他的演讲稿进行文本分析,看看能不能翻出啥有 阅读全文
posted @ 2018-03-27 00:40 王大锤的百变小蜡笔 阅读(878) 评论(0) 推荐(0) 编辑
摘要: Given a table salary, such as the one below, that has m=male and f=female values. Swap all f and m values (i.e., change all f values to m and vice ver 阅读全文
posted @ 2018-03-03 22:43 王大锤的百变小蜡笔 阅读(153) 评论(0) 推荐(0) 编辑
摘要: X city opened a new cinema, many people would like to go to this cinema. The cinema also gives out a poster indicating the movies’ ratings and descrip 阅读全文
posted @ 2018-03-03 21:42 王大锤的百变小蜡笔 阅读(155) 评论(0) 推荐(0) 编辑
摘要: There is a table courses with columns: student and class Please list out all classes which have more than or equal to 5 students. For example, the tab 阅读全文
posted @ 2018-03-03 21:01 王大锤的百变小蜡笔 阅读(132) 评论(0) 推荐(0) 编辑
摘要: There is a table World A country is big if it has an area of bigger than 3 million square km or a population of more than 25 million. Write a SQL solu 阅读全文
posted @ 2018-03-03 20:39 王大锤的百变小蜡笔 阅读(152) 评论(0) 推荐(0) 编辑
摘要: Question: Given a Weather table, write a SQL query to find all dates' Ids with higher temperature compared to its previous (yesterday's) dates. + + + 阅读全文
posted @ 2018-03-03 19:55 王大锤的百变小蜡笔 阅读(128) 评论(0) 推荐(0) 编辑
摘要: Suppose that a website contains two tables, the Customers table and the Orders table. Write a SQL query to find all customers who never order anything 阅读全文
posted @ 2018-03-03 16:37 王大锤的百变小蜡笔 阅读(122) 评论(0) 推荐(0) 编辑
摘要: Write a SQL query to find all duplicate emails in a table named Person. For example, your query should return the following for the above table: Selec 阅读全文
posted @ 2018-03-03 14:36 王大锤的百变小蜡笔 阅读(97) 评论(0) 推荐(0) 编辑
摘要: The Employee table holds all employees including their managers. Every employee has an Id, and there is also a column for the manager Id. + + + + + | 阅读全文
posted @ 2018-03-03 01:02 王大锤的百变小蜡笔 阅读(186) 评论(0) 推荐(0) 编辑