{"id":1048,"date":"2023-03-24T09:47:07","date_gmt":"2023-03-24T01:47:07","guid":{"rendered":""},"modified":"2023-03-24T09:47:07","modified_gmt":"2023-03-24T01:47:07","slug":"Python \u6587\u6863\u64cd\u4f5c","status":"publish","type":"post","link":"https:\/\/bianchenghao6.com\/1048.html","title":{"rendered":"Python \u6587\u6863\u64cd\u4f5c"},"content":{"rendered":"
\n
\u641e\u61c2Python\u5bf9\u56fe\u7247\u548c\u6587\u6863\u7684\u57fa\u672c\u64cd\u4f5c<\/span>\n <\/div>\n left\uff1a\u4e0e\u5de6\u8fb9\u754c\u7684\u8ddd\u79bb<\/span>\u64cd\u4f5c\u56fe\u50cf<\/h2>\n
\u8ba1\u7b97\u673a\u56fe\u50cf\u76f8\u5173\u77e5\u8bc6<\/h3>\n
\n\n
\n \u540d\u79f0<\/td>\n RGBA\u503c<\/td>\n \u540d\u79f0<\/td>\n RGBA\u503c<\/td>\n<\/tr>\n \n White<\/td>\n (255, 255, 255, 255)<\/td>\n Red<\/td>\n (255, 0, 0, 255)<\/td>\n<\/tr>\n \n Green <\/td>\n (0, 255, 0, 255)<\/td>\n Blue<\/td>\n (0, 0, 255, 255)<\/td>\n<\/tr>\n \n Gray<\/td>\n (128, 128, 128, 255)<\/td>\n Yellow<\/td>\n (255, 255, 0, 255)<\/td>\n<\/tr>\n \n Black<\/td>\n (0, 0, 0, 255)<\/td>\n Purple<\/td>\n (128, 0, 128, 255)<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n \u7528Pillow\u64cd\u4f5c\u56fe\u50cf<\/h3>\n
pip install pillow
<\/span><\/code><\/pre>\n<\/p><\/div>\n >>> from <\/span>PIL import <\/span>Image
>>>
>>> image = Image.open<\/span>('.\/uploads\/1.jpg'<\/span>)
>>> image.format, image.size, image.mode
('JPEG'<\/span>, (500, 750), 'RGB'<\/span>)
>>> image.show<\/span>()
<\/span><\/code><\/pre>\n<\/p><\/div>\n\u526a\u88c1\u56fe\u50cf<\/h3>\n
>>> image = Image.open<\/span>('.\/uploads\/1.jpg'<\/span>)
>>> rect = 80, 20, 310, 360
>>> image.crop<\/span>(rect).show<\/span>()
<\/span><\/code><\/pre>\n<\/p><\/div>\n
\n up\uff1a\u4e0e\u4e0a\u8fb9\u754c\u7684\u8ddd\u79bb<\/span>
\n right\uff1a\u8fd8\u662f\u4e0e\u5de6\u8fb9\u754c\u7684\u8ddd\u79bb<\/span>
\n below\uff1a\u8fd8\u662f\u4e0e\u4e0a\u8fb9\u754c\u7684\u8ddd\u79bb<\/span> <\/p>\n\u751f\u6210\u7f29\u7565\u56fe<\/h3>\n
>>> image = Image.open<\/span>('.\/uploads\/1.jpg'<\/span>)
>>> size = 128, 128
>>> image.thumbnail<\/span>(size)
>>> image.show<\/span>()
<\/span><\/code><\/pre>\n<\/p><\/div>\n\u7f29\u653e\u548c\u9ecf\u8d34\u56fe\u50cf<\/h3>\n
>>> image1 = Image.open<\/span>('.\/uploads\/1.jpg'<\/span>)
>>> image2 = Image.open<\/span>('.\/uploads\/2.jpg'<\/span>)
>>> rect = 80, 20, 310, 360
>>> guido_head = image2.crop<\/span>(rect)
>>> width, height = guido_head.size
>>> image1.paste<\/span>(guido_head.resize<\/span>((int(width \/ 1.5), int<\/span>(height \/ 1.5))), <\/span>(172, 40))
<\/span><\/code><\/pre>\n<\/p><\/div>\n\u65cb\u8f6c\u548c\u7ffb\u8f6c<\/h3>\n
>>> image = Image.open<\/span>('.\/res\/guido.png'<\/span>)
>>> image.rotate<\/span>(180).show<\/span>()
>>> image.transpose<\/span>(Image.FLIP_LEFT_RIGHT).show<\/span>()
<\/span><\/code><\/pre>\n<\/p><\/div>\n\u64cd\u4f5c\u50cf\u7d20<\/h3>\n
>>> image = Image.open<\/span>('.\/res\/guido.jpg'<\/span>)
>>> for <\/span><\/span>x in <\/span>range(80, 310):
... for <\/span><\/span>y in <\/span>range<\/span>(20, 360):
... image.putpixel<\/span>((x, y), (128, 128, 128))
...
>>> image.show<\/span>()
<\/span><\/code><\/pre>\n<\/p><\/div>\n\u6ee4\u955c\u6548\u679c<\/h3>\n
>>> from <\/span>PIL import <\/span>Image, ImageFilter
>>>
>>> image = Image.open<\/span>('.\/res\/guido.jpg'<\/span>)
>>> image.filter<\/span>(ImageFilter.CONTOUR).show<\/span>()
<\/span><\/code><\/pre>\n<\/p><\/div>\n\u5904\u7406Excel\u7535\u5b50\u8868\u683c<\/h2>\n
\u5199\u5165excel<\/h3>\n
import <\/span>xlwt
# \u521b\u5efa\u4e00\u4e2aworkbook \u8bbe\u7f6e\u7f16\u7801
<\/span> workbook = xlwt.Workbook<\/span>(encoding = 'utf-8'<\/span>)
# \u521b\u5efa\u4e00\u4e2aworksheet
<\/span> worksheet = workbook.add_sheet<\/span>('animal'<\/span>)
# \u5199\u5165excel
<\/span> # \u53c2\u6570\u5bf9\u5e94 \u884c, \u5217, \u503c
<\/span> worksheet.write<\/span>(1,0, label = 'cat'<\/span>)
# \u4fdd\u5b58
<\/span> workbook.save<\/span>('test.xlsx'<\/span>)
<\/span><\/code><\/pre>\n<\/p><\/div>\n\u8bfb\u53d6excel<\/h3>\n
from <\/span>openpyxl import <\/span>load_workbook
wb = load_workbook(filename = 'test.xlsx'<\/span>)
sheet_ranges = wb['range names'<\/span>]
print(sheet_ranges['D18'<\/span>].value)
<\/span><\/code><\/pre>\n<\/p><\/div>\ncat<\/span><\/code><\/pre>\n<\/p><\/div>\n
\u8bbe\u7f6e\u5355\u5143\u683c\u5bbd\u5ea6<\/h3>\n
import <\/span>xlwt
workbook = xlwt.Workbook<\/span>()
worksheet = workbook.add_sheet<\/span>('animal'<\/span>)
worksheet.write<\/span>(0, 0,'cat'<\/span>)
# \u8bbe\u7f6e\u5355\u5143\u683c\u5bbd\u5ea6
<\/span> worksheet.col<\/span>(0).width = 3333
workbook.save<\/span>('test.xlsx'<\/span>)
<\/span><\/code><\/pre>\n<\/p><\/div>\n\u8f93\u5165\u4e00\u4e2a\u65e5\u671f\u5230\u5355\u5143\u683c<\/h3>\n
import <\/span>xlwt
import <\/span>datetime
workbook = xlwt.Workbook<\/span>()
worksheet = workbook.add_sheet<\/span>('animal'<\/span>)
style = xlwt.XFStyle<\/span>()
style.num_format_str = 'M\/D\/YY'<\/span> # Other options: D-MMM-YY, D-MMM, MMM-YY, h:mm, h:mm:ss, h:mm, h:mm:ss, M\/D\/YY h:mm, mm:ss, [h]:mm:ss, mm:ss.0
<\/span> worksheet.write<\/span>(0, 0, datetime.datetime.now<\/span>(), style)
workbook.save<\/span>('test.xlsx'<\/span>)
<\/span><\/code><\/pre>\n<\/p><\/div>\n\u5411\u5355\u5143\u683c\u6dfb\u52a0\u4e00\u4e2a\u516c\u5f0f<\/h3>\n
import <\/span>xlwt
workbook = xlwt.Workbook<\/span>()
worksheet = workbook.add_sheet<\/span>('animal'<\/span>)
worksheet.write<\/span>(0, 0, 5) # Outputs 5
<\/span> worksheet.write<\/span>(0, 1, 2) # Outputs 2
<\/span> worksheet.write<\/span>(1, 0, xlwt.Formula<\/span>('A1*B1'<\/span>)) # Should output \"10\"<\/span> (A1[5] * A2[2])
<\/span> worksheet.write<\/span>(1, 1, xlwt.Formula<\/span>('SUM(A1,B1)'<\/span>)) # Should output \"7\"<\/span> (A1[5] + A2[2])
<\/span> workbook.save<\/span>('test.xlsx'<\/span>)
<\/span><\/code><\/pre>\n<\/p><\/div>\n\u6dfb\u52a0\u8d85\u94fe\u63a5<\/h3>\n
import <\/span>xlwt
workbook = xlwt.Workbook<\/span>()
worksheet = workbook.add_sheet<\/span>('animal'<\/span>)
worksheet.write<\/span>(0, 0, xlwt.Formula<\/span>('HYPERLINK(\"<\/span>http:\/\/www.baidu.com\";\"<\/span>baidu\")'<\/span>)) # Outputs the text \"Google\"<\/span> linking to http:\/\/www.baidu.com
<\/span> workbook.save<\/span>('test.xlsx'<\/span>)
<\/span><\/code><\/pre>\n<\/p><\/div>\n\u5408\u5e76\u5217\u548c\u884c<\/h3>\n
import <\/span>xlwt
workbook = xlwt.Workbook<\/span>()
worksheet = workbook.add_sheet<\/span>('animal'<\/span>)
worksheet.write_merge<\/span>(0, 0, 0, 3, 'First Merge'<\/span>) # Merges row 0's columns 0 through 3.
<\/span> font = xlwt.Font<\/span>() # Create Font
<\/span> font.bold = True<\/span> # Set font to Bold
<\/span> style = xlwt.XFStyle<\/span>() # Create Style
<\/span> style.font = font # Add Bold Font to Style
<\/span> worksheet.write_merge<\/span>(1, 2, 0, 3, 'Second Merge'<\/span>, style) # Merges row 1 through 2's columns 0 through 3.
<\/span> workbook.save<\/span>('test.xlsx'<\/span>)
<\/span><\/code><\/pre>\n<\/p><\/div>\n\u5185\u5bb9\u5bf9\u5176\u65b9\u5f0f<\/h3>\n
import <\/span>xlwt
workbook = xlwt.Workbook<\/span>()
worksheet = workbook.add_sheet<\/span>('animal'<\/span>)
alignment = xlwt.Alignment<\/span>() # Create Alignment