Recherche avancée

Sur d’autres sites (7751)

• 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/general : move contents into a separate file.

  22 août 2020, par Nicolas George

  doc/general : move contents into a separate file.
  It will allow to include it.
  

  • [DH] doc/general.texi
  • [DH] doc/general_contents.texi

• General outline for how to code a YouTube to MP4 converter that allows the user to trim the video according to time stamps they put in ? [closed]

  16 mai 2023, par Vdog22

  I just need a general outline of how to do this.

  


  I haven't started yet, but I'm not so experienced so I'm not sure how to go about this.

  


  N/A
‏‏‎ ‏‏‎ ‏‏‎ ‏‏‎ ‏‏‎ ‏‏‎