Hi Guys

I'm using Python 3.8.1 and below is a script I use

import glob
import numpy as np # for numerical operations
from moviepy.editor import VideoFileClip, concatenate

clip = VideoFileClip (print(glob.glob("*.mp4")))
cut = lambda i: clip.audio.subclip(i,i+1).to_soundarray(fps=22000) 
volume = lambda array: np.sqrt(((1.0*array)**2).mean())
volumes = [volume(cut(i)) for i in range(0,int(clip.audio.duration-2))]
averaged_volumes = np.array([sum(volumes[i:i+10])/10
                             for i in range(len(volumes)-10)])

increases = np.diff(averaged_volumes)[:-1]>=0
decreases = np.diff(averaged_volumes)[1:]<=0
peaks_times = (increases * decreases).nonzero()[0]
peaks_vols = averaged_volumes[peaks_times]
peaks_times = peaks_times[peaks_vols>np.percentile(peaks_vols,90)]

final_times=[peaks_times[0]]
for t in peaks_times:
    if (t - final_times[-1]) < 60:
        if averaged_volumes[t] > averaged_volumes[final_times[-1]]:
            final_times[-1] = t
    else:
        final_times.append(t)

final = concatenate([clip.subclip(max(t-5,0),min(t+5, clip.duration))
                     for t in final_times])
final.to_videofile('iFLY - Cut.mp4') # low quality is the default

Select all Open in new window

When I run the script, I get an error, see below

['movie.mp4']
Traceback (most recent call last):
  File "C:\Highlights\soccer_cuts.py", line 16, in <module>
    clip = VideoFileClip (print(glob.glob("*.mp4")))
  File "C:\Python38\lib\site-packages\moviepy\video\io\VideoFileClip.py", line 88, in __init__
    self.reader = FFMPEG_VideoReader(filename, pix_fmt=pix_fmt,
  File "C:\Python38\lib\site-packages\moviepy\video\io\ffmpeg_reader.py", line 32, in __init__
    infos = ffmpeg_parse_infos(filename, print_infos, check_duration,
  File "C:\Python38\lib\site-packages\moviepy\video\io\ffmpeg_reader.py", line 245, in ffmpeg_parse_infos
    is_GIF = filename.endswith('.gif')
AttributeError: 'NoneType' object has no attribute 'endswith'

Select all Open in new window

Looking through the error I found line 16 to be the issue

clip = VideoFileClip (print(glob.glob("*.mp4")))

Select all Open in new window

What I'm trying to do with line 16 is set a variable, the file name movie may be called movie1 or movie 2 though there will always be just the 1 mp4 file within the folder called Highlights. I'm hoping you can assist me with this.

Any help is greatly appreciated.

Hi,
I got 2 files i.e File1 and File2, as shown below

File1
A | APPLE
B | ORANGE
C | GRAPES

File2
A | 10
B | 15
D | 20

I need following 2 outputs,
Output 1
A | APPLE | 10
B | ORANGE | 15

Output 2
C | GRAPES | NA

I got the output1 using below below script.
Script1

for line1 in file1:
Data1 = line1.split("|")
Data10 = Data1[0]
Data11 = Data1[1]
 for line2 in file2:
 Data2 = line2.split("|")
 Data20 = Data2[0]
 Data21 = Data2[1]
  If Data10 == Data20:
  Print ( Data10, "|", Data11, "|", Data21)

My question is, how can I get my output2. I tired putting if data10 != data 20, i tired break and continue function but still I am not getting my output. Can advice what is best way to get my output2.

How would you code for this problem?

Define the function check(s). The function returns 1 when string 's' contains at least one digit and returns 0 otherwise.

I'm very new to Python but I've learned enough to print out the data in a specified range on Sheet 1 in a specified Excel workbook. The current code below will do that but in the Terminal window, each 5 column row is printed vertically in one long column so to speak. How would I modify the code to get it to print out with each 5 column row spread out horizontally as it is in Excel? I'm interested in doing that because 1) it would be easier to read, and 2) just to see if Python will do that.

path = r'C:\Users\t0122059\Documents\ACDetails.xlsx'

f = open(path, 'rb')
print(f.read())

# https://openpyxl.readthedocs.io/en/stable/usage.html

from openpyxl import load_workbook
wb = load_workbook(path)

for row in range(1, 12):
    for col in range(1, 6):
        print(wb.worksheets[0].cell(row, col).value)
print('inspect')

Select all Open in new window

Thanks,
John

I have a column which contains geometry values (maps) like 01030009777700000000BCA142E2ABD08A2C0CA9466D8B4B4CC. I wanted to convert it into latitude and longitude coordinates. I tried using geopandas but didn't click for me. Any help is appreciated.

I remotely connect to Linux virtual box from secure shell (ssh).  I have smallest bitbake project.

I type bitbake from shell prompt.  
The output is as follows:
Nothing to do.  Use 'bitbake world' to build everything, or run 'bitbake --help' for usage information.

Bitbake document says default build task will be executed.
build default task is in Base.bbclass file.

How can I be sure this task actually executed?  How do I print something to the screen from this task?
base.bbclass
bblayers.conf
bitbake.conf
layer.conf

Hi Bash experts,

Trying to parse multiple xml files in a directory.
Extract an attribute value from available xml files. e.g liferay-version="20.0.1.5"
sort them and get the greatest value from the identified list. e.g "20.0.1.8" and store them in a variable

Was trying using python, but due to restriction on my work server. couldn't install additional packages, so couldn't use python.

Is it possible using sed/awk/bash or any way please.

file1.txt

<?xml version="1.0" encoding="utf-8"?>
<package date-created="26/11/2019" liferay-version="20.0.1.5" patch-version="5.0">
  <description />
  <system />
</package>

Select all Open in new window

file2.txt

<?xml version="1.0" encoding="utf-8"?>
<package date-created="26/11/2019" liferay-version="20.0.1.6" patch-version="6.0">
  <description />
  <system />
</package>

Select all Open in new window

file3.txt

<?xml version="1.0" encoding="utf-8"?>
<package date-created="26/11/2019" liferay-version="20.0.1.7" patch-version="7.0">
  <description />
  <system />
</package>

Select all Open in new window

file4.txt

<?xml version="1.0" encoding="utf-8"?>
<package date-created="26/11/2019" liferay-version="20.0.1.8" patch-version="8.0">
  <description />
  <system />
</package>

Select all Open in new window

Understanding Python Functions

I have this Python code :

import random
class Dice:
    def Roll(self):
     first=random.randint(1,6)
     second=random.randint(1,6)
     return  first,second


dice=Dice()
print(dice.Roll())

Select all Open in new window

I would like to know the meaning of Self in : the function Roll. is it a parameter that needs an argument passed to it ? if so what argument was it passed to it in the above example?

I also want to understand the Return keyword.  in the example above the result from variables first and second will be returned but where does it get stored ?
it should be store in the function Roll, but where ? in the Self parameter ?

Any clarification will be very much appreciated.


Thank you

Trying to display just the "From" and "Subject" items from all unread emails. What I've got in the code reads
<code>
          def getmail(server):
               select_info = server.select_folder(MAILBOX)
               messages  = server.search(['UNSEEN'])
               print("getting mail")
               for uid, message_data in server.fetch(messages, 'RFC822').items():
                    print("number of messages %d" % len(messages))
                    email_message = email.message_from_bytes(message_data[b'RFC822'])
                    print(email_message.get('From'), email_message.get('Subject'))
          return messages
</code>

However, what's happening is an error is occurring. Output listing is

getting mail
number of messages 1
"Rob PL" <rob@xxxxxxxxx.com> test
number of messages 1
Exception triggered: b'RFC822'

Just can't find a way of getting rid of the error.

Can anyone help here?

I have a dataframe with the customer Id, first name, address1, address2 etc and I would like to merge all the address columns into one single address column.

How do I skip columns that have an empty string or None in their address1 column?

I use the following function but somehow but it looks like the loop enters the else part of the loop even though I add a break statement:

for index, row in customers_df.iterrows():
    if customers_df['address1'][index] != "None":
        customers_df['complete_address'] = customers_df["address1"].map(str) + ", " + customers_df["address2"].map(str) + ", " + customers_df["zip"].map(str) + ", " + customers_df["town"].map(str) + ", Switzerland"
        break
    else:
        customers_df['complete_address'] = np.nan

Select all Open in new window

Hi Python experts

this is reference to this conversation

https://www.experts-exchange.com/questions/29167463/python-convert-currency.html?anchor=a42998667¬ificationFollowed=242733822#a42998667

how to convert "float(amount)" from USD to AUD please :)

#!/usr/bin/env python2.7

import argparse
import boto3
import datetime
from currency_converter import CurrencyConverter

parser = argparse.ArgumentParser()
parser.add_argument('--days', type=int, default=30)
args = parser.parse_args()


now = datetime.datetime.utcnow()
start = (now - datetime.timedelta(days=args.days)).strftime('%Y-%m-%d')
end = now.strftime('%Y-%m-%d')
dtemplate="{:10} {:14} {:40} {:16.10f} {:6} {:10}"
htemplate="{:10} {:14} {:40} {:16} {:6} {:10}"

cd = boto3.client('ce', 'ap-southeast-2')

results = []

token = None
while True:
    if token:
        kwargs = {'NextPageToken': token}
    else:
        kwargs = {}
    data = cd.get_cost_and_usage(TimePeriod={'Start': start, 'End':  end}, Granularity='DAILY', Metrics=['UnblendedCost'], GroupBy=[{'Type': 'DIMENSION', 'Key': 'LINKED_ACCOUNT'}, {'Type': 'DIMENSION', 'Key': 'SERVICE'}], **kwargs)
    results += data['ResultsByTime']
    token = data.get('NextPageToken')
    if not token:
        break

print(htemplate.format("TimePeriod", "LinkedAccount", "Service", "Amount", "Unit", "Estimated"))

for result_by_time in results:
    for group in result_by_time['Groups']:
        amount = group['Metrics']['UnblendedCost']['Amount']
        unit = 

Select all Open in new window

…