Python将Excel数据转为insert语句

from ntpath import joinimport pandas as pddf = pd.read_excel(r'XXX.xlsx',sheet_name='sheet1')height,width = df.shape# SQL文件file = open('test.sql','a')


Scala集合函数笔记

sorted、sortBysorted:按照元素自身进行排序;sortBy: 按照应用函数 f 之后产生的元素进行排序;scala> val list = List(1,4,2,3,5)list: List[Int] = List(1, 4, 2, 3, 5)// 按照自身元素排序scala&


剑指 Offer 38. 字符串的排列 Scala解法

解题思路参考:剑指 Offer 38. 字符串的排列(回溯法,清晰图解)object Solution { def permutation(s: String): Array[String] = { var res = new scala.collection.mutable.A