derrick-sherrill / derricksherrill.com Goto Github PK

Is it Also possible to control the Philips Hue Smart with this libary?
If yes, what do i have to do?

Thanks for your help.

comment of issue

when you set the coin_list = [ 2,5,10] as if you run out some and you need give 3cents change,while the program runs out :2 rather than an error or return ......

Hi error with pykeyboard saying it’s not install when I’ve install the module using this command Pip install pykeyboard so this doesn’t run is there another way you can this or no

Please i am new to pandas python .i have this issue trying to drop all rows with numbers in an excel document.
I have [5 rows x 3 columns].I am trying to drop every row except Pepsi and fruit.!I keep getting the wrong result.Can anyone help?

drinks | cost | places
coke | | New york 
fanta |   | Ontario
beer | |  Germany
pepsi|   4.5 | New Jersy
Fruit | 3.0 |  Vancouver

import pandas as pd

import numpy as np

excel_file_1 = 'DRINKS.xlsx'
df = pd.read_excel(excel_file_1)

#df.dropna(axis=0,how='all')

print (df)

delete after

this is comment data

Hi Derrick,

I have a scenario :

I have some records where a filed contain values like

8t @ 12.8mtr
8T @ 17.3MTR
[email protected]
[email protected]
12t @ 16.9mtr
3t @ 22.7mtrs
300 cfm
400 cfm
430 cfm
450 CFM
450 CFM
600 CFM

Now i want these to be split into two columns and standardized like:

Capacity UOM
8t @ 12.8 mtr
8T @ 17.3 mtr
[email protected] mtr
[email protected] mtr
12t @ 16.9 mtr
3t @ 22.7 mtr
300 cfm
400 cfm
430 cfm
450 cfm
450 cfm
600 cfm