Hi I'm seeking help to create an if statement in python

Three problems

1. if the cell in column B contains a dash '-', and the adjacent cells in columns 'C', 'D', 'E', have values then, I wanted to replace the dash with an average from the three cells.

Example from picture.
Row 2 Column B contains a dash, but data is present in Columns C, D and E


2. If the cell is populated with a number and not a formula then I wanted to append the cell, and add an additional three zeros

Example from picture.
 Row 2 Column B now contains a formula, but data is present in Columns C, D and E
 The number in Row 2, Column C is 42,746,000. I would like to update the value with an extra three zeros e.g. ',000'.
 This will update the value in Row 2, Column C  is 42,746,000,000

3. In Columns B, C, D and E, Rows 3, 4 and 5. I wanted to format the number according to either a positive or negative number
 If a positive number then the cell format is updated to [<999950] 0.0,"K";[<999950000]0.0,,"M";0.0,,,"B"
 If a negative number then the cell format is updated to [>-999950]0.0,"K";[>-999950000]0.0,,"M";0.0,,,"B"

from openpyxl import Workbook
from openpyxl.styles import Color, PatternFill, Font, Border
from openpyxl.styles import colors
from openpyxl.cell import Cell
import os

xlfile = "/Users/User1/Documents/NewFolder/Test.xlsx"
if os.path.exists(xlfile):
    os.remove(xlfile)

wb = Workbook()
filepath = "Test.xlsx"

Select all Open in new window

Screen-Shot-2019-04-19-at-12.13.14.png

ValueError: "port" must be None or a string, not <type 'int'>

Select all Open in new window

keep getting this error when I run my python 2.7  code to find and connect with my port which I have a gps tracker connected ... I'm using 2.7 ... I figured once I get this working I can translate it into python3..

this is the error .. as I try is tell my laptop what port my GPS trackers in connected to

  File "C:\Users\clayr\Anaconda3\envs\maps.py\lib\site-packages\serial\serialutil.py", line 264, in port
    raise ValueError('"port" must be None or a string, not {}'.format(type(port)))
ValueError: "port" must be None or a string, not <type 'int'>

Select all Open in new window

this code I am starting with

import serial

#####Global Variables######################################
#be sure to declare the variable as 'global var' in the fxn
ser = 0

#####FUNCTIONS#############################################
#initialize serial connection 
def init_serial():
    COMNUM = 3 #set you COM port # here
    global ser #must be declared in each fxn used
    ser = serial.Serial()
    ser.baudrate = 9600
    ser.port = COMNUM - 1 #starts at 0, so subtract 1
    #ser.port = '/dev/ttyUSB0' #uncomment for linux

    #you must specify a timeout (in seconds) so that the
    # serial port doesn't hang
    ser.timeout = 1
    ser.open() #open the serial port

    # print port open or closed
    if ser.isOpen():
        print 'Open: ' + ser.portstr
#####SETUP################################################
#this is a 

Select all Open in new window

…

Parsing nested json. I am looking for help to parsing the nested json elements.

I attached a json file I need to output all of the data fields, however some are nested and I don't know the HOW-TO output the nested values. Can you help ?

I also include the start a python script
parser.py
file.json

I am trying to track a player and object in the same frame/video/camera...ultimately camera only ... using KCF for now to track the player and work ok ...unless the player leaves the frame completely ...long term that will not be a problem see code below

import cv2
import sys
import imutils
 
if __name__ == '__main__' :
 
    # Set up tracker.
    # Instead of MIL, you can also use
    
	
    
   
    tracker_types = ['KSF ']
    tracker_type = tracker_types[0]
    tracker = cv2.TrackerKCF_create()
   
 
    # Read video
    video = cv2.VideoCapture("tennisVid_Trim_Trim.mp4")
 
    # Exit if video not opened.
    if not video.isOpened():
        print ("Could not open video")
        sys.exit()
 
    # Read first frame.
    
    ok, frame = video.read()
    frame = imutils.resize(frame, width= 720)
	#frame = imutils.resize(frame, height= 720)
    if not ok:
        print ('Cannot read video file')
        sys.exit()
     
    # Define an initial bounding box
    bbox = (320, 230, 230, 320)
 
    # Uncomment the line below to select a different bounding box
    #bbox = cv2.selectROI(frame, False)
 
    # Initialize tracker with first frame and bounding box
    ok = tracker.init(frame, bbox)
 
    while True:
        # Read a new frame
        ok, frame = video.read()
        if not ok:
            break
         
        # Start timer
        timer = cv2.getTickCount()
 
        # Update tracker
        ok, bbox = tracker.update(frame)
 
        # Calculate Frames 

Select all Open in new window

…

HI

I've asked other questions about Javascript,
but I saw that one advice page said that I must get a special eclipse IDE for web development.... but I already have eclipse Kepler. Is that not enough?

...down at Getting Eclipse IDE for JavaScript and Web Developers

here

That's quite a surprise...
Thanks

Hi ..
I need to run some commands on a remote machine using ssh . What is the best way to automate this in Python?
I need to log in with a (known) password to the remote machine, so I can't just use ssh user@remotehost.
I'm wondering if there's a built-in module in python I could use or I need to install one.
If you have a sample script is highly appreciated.

Thank you for your help.

i spent 6 hours yesterday trying to figure out sorting in python.


i get that:
for k in sorted(djTime.items(), key=lambda x(-x[1], x[0])):
should take every instance of k in djTime and perform something on something else.
i've understood the same of
for line in sorted(djTime):
should take a logfile previously broken into lines by the rstrip('\n') method and see the items as lines
i understand *line* or *k* in any circumstance can be any variable (i.e.) for JohnDoe in sorted(djTime):

i don't understand how or what python is looking for to differentiate between items either in a list or in a dictionary

i believe if you say:
for k, v in sorted(djTime.items())
...and this is a tuple, the k is representative of the key, and the v is representative of the value? but i'm not really clear

do you have to specify 2 variables/objects to sort a tuple? is a single non nested dictionary always a tuple? (i.e. for k, v in sorted(djTime)
do you have to use .items? what if i want to sort by key? can i sort like this:  for k, v in sorted(djItems.keys())  can i do it by values? : for k, v in sorted(djItems.values()

as for the remainder of the command up there :     x(-x[1], x[0])
i have no idea what the first x is, but the second seems to me to denote the position in the tuple? where counting begins with 0 so x[1] is the second item and x[0] is the first item? kinda backwards?? and the - negative in front of the main -x[1] mean sort from bottom to top



what i'm …

using telnetlib in python to configure a router. i'm using cgi to display the python script to a browser.
i'm having trouble troubleshooting the code because cgi just display's an error screen 'internal server error'
so, i really don't see where i'm making the mistake. i can run the python script through the python interpreter, but that's just a hassle.

any suggestions on how to troubleshoot the output? i've tried using
print "Content-type:text/plain\n" as opposed to "Content-type:text/html\n" so as to just display the unformatted output without html formatting, but i still am not seeing where i'm making mistakes.

i know i can cat /var/log/httpd/error_log

but i guess what i'm asking is if anyone can give me some more specifics about what is actually going on.
i understand this:
telnetlib is a module that'll open a socket to the router or switch.  the physical and data link connection we're not going to see, the network layer is addressed by the ip which i have set to a variable and is here
host = "192.168.1.1"
tn = telnetlib.Telnet(HOST, timeout=TIMEOUT)
any further specifics of communication is held within the actual module telnetlib -- socket or transport layer tcp settings.

the server 'sends' the message, encapsulated at what? layer 7 down through layer 2 as the data communications model/osi specifies.. it goes over the wire and over to the client which decapsulates the packet and sends it back up to the telnet application.

i understand i can't see…

For my Android Phone I need to be able to quickly turn on or turn off wifi calling.
The Problem:
When a call comes in and the phone is set to my home office to WiFi calling. The quality and sound of the call is better.
However if you need to record the call for business purposes it is difficult to switch the WiFi calling off for the recording app to work.
The apps I have require WiFi to be off in order to record both sides of the call.
Two way calling is not possible as I only hear my side of the call & not my clients.

Is it possible or am I dreaming as I know nothing of apps but learning Python lately. Can a single button (like an app on my phone screen)  be made that performs like a macro.
Which will allow me to touch one button instead of 4 switching screens each time to turn on or off wifi calling?

Hi Experts,

I get the following error for python application.

django.db.utils.OperationalError: FATAL:  remaining connection slots are reserved for non-replication superuser connections

Select all Open in new window

I use dj_database_url.py for configuring database.   I am using Postgres as a database

I had set connection_max_age to 0 in the config. dj_database_url.py

Still, I get this error.

I had checked the entire source code by using grep there is no connection in the source code.

I getting this error from inside docker container.  the database is outside the docker container.

the connection string I use to connect is DATABASE=postgres://test:*****@172.17.0.1/test where 172.17.0.1 is docker gateway.

max_connection =100 in postgresql.conf which located inside /etc/postgresql/9.5/main/

Any help is greatly appreciated.

Can I create code in Python that will allow me to build a list of records that I can them import into Excel or a database that will do the following.
1. Generate Names or Words for a field. Say the name Robert or the words 205 Walnut Lane
2. Modify existing records in order to change and existing name in a field Say First Name from Mary to Frances? Having it modify randomly each name.
3. Finally. How can I Generate a list of records for a currency field to generate random values set between a range. Say $20,000 to millions of dollars?

Can python do that and if so any ideas on what the code would look like or how to get examples of it. I could play around with.
The goal is to build a fictitious dataset for this excel file or to add to a DB.

how to make python pyqt5 qtableview cell like excel conditional formatting? the greater the value, deeper color. lesser the value, lighter color

Android Phone I need to be able to quickly turn on or turn off wifi calling.
When a call comes in and the phone is set to my home office to WiFi calling. The quality and sound of the call is better. However if you need to record the call for business purposes it is hard to switch the WiFi calling off for the recording app to work. Apparently the ones I have both require WiFi to be off in order to record both sides of the call.
Two way calling is not possible. All you hear is me saying um hum.

Is it possible or am I dreaming as I know nothing of apps but learning Python lately. Can a single button (like an app on my phone screen)  be made that performs like a macro.
Which will allow me to touch one button instead of trying to listen to the client and going in and selecting all those choices. I have hung up on people trying to turn off wifi.