더쿨라이프

ImportError: No module named xlsxwriter

C:\Python27\Lib\site-packages

XlsxWriter-0.8.7-py2.7.egg

>>> a = [ ]

>>> a

[ ]

>>> a.append(1)

>>> a

[1]

>>> a.append("ABC")

>>> a

[1, 'ABC']

>>> a += "DEF"

>>> a

[1, 'ABC', 'D', 'E', 'F']

>>> a += ["GHI"]

>>> a

[1, 'ABC', 'D', 'E', 'F', 'GHI']

>>> a.insert(2, 'TEST')

>>> a

[1, 'ABC', 'TEST', 'D', 'E', 'F', 'GHI']

>>> a.remove('DEF')

Traceback (most recent call last):

  File "<stdin>", line 1, in <module>

ValueError: list.remove(x): x not in list

>>> a.remove('D')

>>> a

[1, 'ABC', 'TEST', 'E', 'F', 'GHI']

>>> a.pop()

'GHI'

>>> a

[1, 'ABC', 'TEST', 'E', 'F']

>>> a.pop(2)

'TEST'

>>> a

[1, 'ABC', 'E', 'F']

>>> a.pop(2)

'TEST'

>>> a

[1, 'ABC', 'E', 'F']

>>> a

[1, 'ABC', 'E', 'F']

>>> len(a)

4

>>> a

[1, 'ABC', 'E', 'F']

>>> a.index('E')

2

>>> a.count('A')

0

>>> a.count('ABC')

1

>>> a.reverse()

>>> a

['F', 'E', 'ABC', 1]

>>> a.sort()

>>> a

[1, 'ABC', 'E', 'F']

>>> a.extend("TEST")

>>> a

[1, 'ABC', 'E', 'F', 'T', 'E', 'S', 'T']

>>> a.append("TEST")

>>> a

[1, 'ABC', 'E', 'F', 'T', 'E', 'S', 'T', 'TEST']

#!/usr/bin/python

import sys

import os.path

ext = None

def convert_wave_to_pcm(filename):

file = open(filename, 'rb')

byteBuffer = bytearray(file.read())

file.close()

fn_ext = os.path.splitext(filename)

if fn_ext[1] == '.wav':

out_filename = fn_ext[0] + '.pcm'

else:

out_filename = fn_ext[0] + fn_ext[1] + '.pcm'

print 'Out file name: %s' % out_filename

out_file = open(out_filename, 'wb')

for x in range(44, byteBuffer.len(),4):

out_file.write(byteBuffer[x:x+1])

out_file.close()

if len(sys.argv) is 1:

YesNo = raw_input('Do you want to convert *.wav to *.pcm? (Yes or No): ') # There is no option.

if 'yes' in YesNo:

filename = '.wav'

print('Convert *.wav to *.pcm !!!')

else:

print('Please try it again with a filename or .wav !!!')

exit(0)

else:

filename = sys.argv[1]

while True:

fn_ext = os.path.splitext(filename)

if (not fn_ext[1]) & fn_ext[0].count('.'):

if fn_ext[0] == '.':

print 'Input file name is invalid!!!'

exit(0)

else:

print 'Input file name has the only ext!!!'

ext = fn_ext[0]

break

else:

try:

convert_wave_to_pcm(filename)

break

except:

print '[Error] No such file: %s' % filename

filename = raw_input('Please type file name: ')

if ext is not None:

folder = os.getcwd()

print 'folder: %s' % folder

for path, dirs, files in os.walk(folder):

convert_wave_to_pcm(os.path.join(path, filename)) for filename in files if filename.endswith(ext)

raw_input('Press Enter to exit')

exit(0)

2015/07/21 - [파이썬] - [파이썬, Python] Wave 파일을 PCM 파일로 바꿔 저장하는 예제 3.

2015/07/21 - [파이썬] - [파이썬, Python] Wave 파일을 PCM 파일로 바꿔 저장하는 예제 2.

2015/07/21 - [파이썬] - [파이썬, Python] Wave 파일을 PCM 파일로 바꿔 저장하는 예제 1.

2015/07/14 - [오디오 음성] - Wave 파일 포맷

#-*- coding: utf-8 -*-

import sys

reload(sys)

sys.setdefaultencoding('utf-8')

import os.path

byteBuffer = bytearray([1,0,0,0,255,255,0,0])

out_file = open('binaryfile.dat', 'wb')

for x in range(0,40000):

out_file.write(byteBuffer)

out_file.close()

import os.path

import struct

#byteBuffer = bytearray([1,0,0,0,255,255,0,0])

byteBuffer = struct.pack('hhhh',1,0,-1,0)

out_file = open('binaryfile.dat', 'wb')

for x in range(0,40000):

out_file.write(byteBuffer)

out_file.close()

http://www.py2exe.org/

from distutils.core import setup

import py2exe, sys, os

includes  = [

 "encodings",

 "encodings.utf_8",

]

options = {

 "bundle_files": 1,                 # create singlefile exe

 "compressed": 1,                 # compress the library archive

 "optimize": 2,                 # do optimize

 "includes": includes,

}

setup(

 options = {"py2exe" : options},

 console = [{'script': "test.py"}],

 zipfile = None,

)

python setup.py py2exe

*** binary dependencies ***

Your executable(s) also depend on these dlls which are not included,

you may or may not need to distribute them.

Make sure you have the license if you distribute any of them, and

make sure you don't distribute files belonging to the operating system.

   WSOCK32.dll - C:\Windows\system32\WSOCK32.dll

   USER32.dll - C:\Windows\system32\USER32.dll

   ADVAPI32.dll - C:\Windows\system32\ADVAPI32.dll

   SHELL32.dll - C:\Windows\system32\SHELL32.dll

   KERNEL32.dll - C:\Windows\system32\KERNEL32.dll

from distutils.core import setup

import py2exe, sys, os

includes  = [

"encodings",

"encodings.utf_8",

]

options = {

 "bundle_files": 1,                 # create singlefile exe

 "compressed"  : 1,                 # compress the library archive

 "optimize"    : 2,                 # do optimize

 "dll_excludes": ["WSOCK32.dll", "USER32.dll", "ADVAPI32.dll", "SHELL32.dll", "KERNEL32.dll"],

 "includes": includes,

}

setup(

 options = {"py2exe" : options},

 console = [{'script': "test.py"}],

 zipfile = None,

)

Using "bundle_files" and "zipfile"

An easier (and better) way to create single-file executables is to set bundle_files to 1 or 2, and to set zipfile to None. This approach does not require extracting files to a temporary location, which provides much faster program startup.

Valid values for bundle_files are:

If zipfile is set to None, the files will be bundle within the executable instead of library.zip. Note: you will still be required to include the MSVC runtime DLL with your application, which should be located in the dist directory along side the executable (named MSVCRXX.dll, where XX = revision number).

Here is a sample setup.py:

   1 from distutils.core import setup
   2 import py2exe, sys, os
   3 
   4 sys.argv.append('py2exe')
   5 
   6 setup(
   7     options = {'py2exe': {'bundle_files': 1}},
   8     windows = [{'script': "single.py"}],
   9     zipfile = None,
  10 )

#!/usr/bin/python

import os.path

folder = os.getcwd()

print 'Current folder : %s' % folder

for path, dirs, files in os.walk(folder):

    print '\nFolder: ', path

    if files:

    sub_path = path[len(folder)+1:]

        for filename in files:

            print ' Files: ', os.path.join(sub_path, filename)

exit(0)

D:\myPython>python filelist2.py

Current folder : D:\myPython

Folder:  D:\myPython

 Files:  example.py

 Files:  fileList2.py

Folder:  D:\myPython\folder1

 Files:  folder1\1.wav

Folder:  D:\myPython\folder1\folder11

 Files:  folder1\folder11\11.wav

 Files:  folder1\folder11\111.wav

Folder:  D:\myPython\folder1\folder12

Folder:  D:\myPython\folder2

 Files:  folder2\2.wav

https://github.com/jmcnamara/XlsxWriter

C:\XlsxWriter-master>python setup.py install