Recherche avancée

Sur d’autres sites (9589)

• How do I timestamp an excel document using Pandas ?

  16 juillet 2015, par Andy Do

  I have a script that uses FFMPEG and CMD to cut video files based off of an excel document row by row. I would like python to add a timestamp after it is done with a row. Can you guys please help ?

  import subprocess as sp, pandas as pd
  
  
  
  ffmpeg = 'C:/FFMPEG/bin/ffmpeg.exe' # on Windows
  
  datafile = r'C:\Users\A_Do\Dropbox\1. Projects\2. Python\TM Creator\tm_creator_test1.xlsx'
  
  
  
  xl = pd.ExcelFile(datafile,index = False)
  
  df = xl.parse('Sheet1')
  
  
  
  def create_tm():
  
      row_iterator = df.iterrows()
  
       # take first item from row_iterator
  
      for i, row in row_iterator:
  
          infile = row['filename']
  
          outputfile = row['outputfilename']
  
          timein = row['timein']
  
          duration = row['duration']
  
          decision = row['Create TM?']
  
          if decision == "Y":
  
              sp.call(ffmpeg + " -y -i " + infile + " -map 0:0 -map 0:1 -map 0:2 -acodec copy -ss " + str(timein) + " -codec copy -t " + str(duration) + " " + outputfile,shell=True) #this works
  
  
  
          elif decision != decision: #this gets rid of the NaN
  
              break
  
          else:
  
              print "You said you didn't want to make a TM for " + str(infile)
  
  
  
  create_tm()

  Thanks !

  My final code :

  import subprocess as sp, pandas as pd
  
  # (1) new import
  
  from openpyxl import load_workbook
  
  # (2) new import
  
  from datetime import datetime
  
  
  
  ffmpeg = 'D:/FFMPEG/bin/ffmpeg.exe' # on Windows
  
  datafile = r'D:\Dropbox\1. Projects\2. Python\TM Creator\tm_creator_test1.xlsx'
  
  
  
  # (3) open the file in openpyxl first:
  
  book = load_workbook(datafile)
  
  
  
  xl = pd.ExcelFile(datafile,index = False)
  
  df = xl.parse('Sheet1')
  
  
  
  def create_tm():
  
      row_iterator = df.iterrows()
  
       # take first item from row_iterator
  
      for i, row in row_iterator:
  
          infile = row['filename']
  
          outputfile = row['outputfilename']
  
          timein = row['timein']
  
          duration = row['duration']
  
          decision = row['Create TM?']
  
          if decision == "Y":
  
              sp.call(ffmpeg + " -y -i " + infile + " -map 0:0 -map 0:1 -acodec copy -ss " + str(timein) + " -codec copy -t " + str(duration) + " " + outputfile,shell=True) #this works
  
              # (4) Wherever in the code you want to put the timestamp:
  
              df.loc[i, 'Timestamp'] = str(datetime.now())
  
              # (5) This saves the sheet back into the original file, without removing
  
              # any of the old sheets.
  
              writer = pd.ExcelWriter(datafile)
  
              writer.book = book
  
              writer.sheets = dict((ws.title, ws) for ws in book.worksheets)
  
              df.to_excel(writer, index=False)
  
              writer.save()
  
          elif decision != decision: #this gets rid of the NaN
  
              break
  
          else:
  
              print "You said you didn't want to make a TM for " + str(infile)

• doc : Explain that the default RTMP user agent is different when publishing

  10 août 2013, par Martin Storsjö

  doc : Explain that the default RTMP user agent is different when publishing
  The fact that a different user agent is used is cruicial for getting
  
  publishing authentication working. (When using librtmp, this other
  
  user agent has to be specified manually, but that’s not needed
  
  with the libavformat internal RTMP support.)
  Signed-off-by : Martin Storsjö <martin@martin.st>
  

  • [DH] doc/protocols.texi

• Podcast Producer 2 tip - running xgrid jobs as logged in user

  19 octobre 2009

  So I’ve been playing with an interesting "feature" in PCP2 - the "chapterize" command generates different results when it can talk to the window server versus when it can’t. In my case, it generates much better results in the case of the former.

  "But," you say, "my PCP2 xgrid jobs can’t talk to the window server !"

  Very true. However, you can change the user that PCP2 uses to submit Xgrid jobs, and Xgrid will run the job with that user’s permissions if everyone is single signon’d to the same kerberos domain.

  So, now we’ve got PCP2 jobs running as a real user. Next, log into the GUI as that user.

  Now, when PCP2 workflows run, they’ll be able to talk to the window server, and at least in the case of "chapterize," use what appears to be the "Good" code path. Faster, more accurate, more delightful.