Home  >  Article  >  Backend Development  >  Sharing of small cases applied in Python

Sharing of small cases applied in Python

黄舟
黄舟Original
2017-10-08 09:31:421669browse

1. Python counts the number of occurrences of each word in the text:

#coding=utf-8
__author__ = 'zcg'


import collections
import os

with open('abc.txt') as file1:#打开文本文件
    str1=file1.read().split(' ')#将文章按照空格划分开

print "原文本:\n %s"% str1
print "\n各单词出现的次数:\n %s" % collections.Counter(str1)
print collections.Counter(str1)['a']#以字典的形式存储,每个字符对应的键值就是在文本中出现的次数
__author__ = 'zcg'
#endcoding utf-8
import  string,random

field=string.letters+string.digits

def getRandom():
    return "".join(random.sample(field,4))

def concatenate(group):
    return "-".join([getRandom() for i in range(group)])

def generate(n):
    return [concatenate(4) for i in range(n)]
if __name__ =='__main__':
    print generate(10)

3. Traverse all data in the excel table:

__author__ = 'Administrator'

import xlrd


workbook = xlrd.open_workbook('config.xlsx')
print "There are {} sheets in the workbook".format(workbook.nsheets)
for booksheet in workbook.sheets():
    for col in xrange(booksheet.ncols):
        for row in xrange(booksheet.nrows):
            value=booksheet.cell(row,col).value
            print value
其中xlrd需要百度下载导入这个模块到python中
#coding=utf-8
__author__ = 'zcg'
#2017  9/26

import xlrd
fileOutput = open('Configs.lua','w')

writeData="--@author:zcg\n\n\n"

workbook = xlrd.open_workbook('config.xlsx')
print "There are {} sheets in the workbook".format(workbook.nsheets)

for booksheet in workbook.sheets():
    writeData = writeData+'AT' +booksheet.name+' ={\n'
    for col in xrange(booksheet.ncols):
        for row in xrange(booksheet.nrows):
            value = booksheet.cell(row,col).value
            if row ==0:
                writeData = writeData+'\t'+'["'+value+'"]'+'='+'{'
            else:
                writeData=writeData+'"'+str(booksheet.cell(row,col).value)+'", '
        else:
            writeData=writeData+'},\n'
    else:
        writeData=writeData+'}\n\n'
else :
    fileOutput.write(writeData)
fileOutput.close()

The above is the detailed content of Sharing of small cases applied in Python. For more information, please follow other related articles on the PHP Chinese website!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn