Search Results
|
Post |
Author |
Forum |
Replies |
Views |
Posted
[asc]
|
|
|
Thread: openpyx (ValueError: Style Consolas exists already)
Post: openpyx (ValueError: Style Consolas exists already...
My code:
class Excel:
def __init__(self) -> None:
self.wb = xl.Workbook()
del self.wb['Sheet']
self.consolas = NamedStyle(name='Consolas')
self.consolas... |
|
Irv1n |
General Coding Help |
0 |
1,415 |
Feb-21-2022, 01:04 PM |
|
|
Thread: Find last filled column in openpyxl
Post: Find last filled column in openpyxl
I work with excel file and know filename and sheet name of this file. How i can search last filled column and insert my data in next column of this file? I work with openpyxl library. |
|
Irv1n |
General Coding Help |
2 |
12,836 |
Jan-14-2022, 06:22 PM |
|
|
Thread: handle the error
Post: RE: handle the error
just throw out this value |
|
Irv1n |
General Coding Help |
5 |
1,750 |
Nov-29-2021, 07:55 PM |
|
|
Thread: handle the error
Post: RE: handle the error
(Nov-29-2021, 06:34 PM)deanhystad Wrote: What is returned by receive()?returned values like: 1.0E3, 1.1E3 and so on., then I use this values for calculation.
The error occurs when the self.connector... |
|
Irv1n |
General Coding Help |
5 |
1,750 |
Nov-29-2021, 07:03 PM |
|
|
Thread: handle the error
Post: handle the error
I communicate with device and receive data with this function:
def get_dcv(self):
self.connector.send('DCV?')
return float(self.connector.receive())sometimes I can get broken data and I get "V... |
|
Irv1n |
General Coding Help |
5 |
1,750 |
Nov-29-2021, 06:20 PM |
|
|
Thread: Loop with choose
Post: RE: Loop with choose
if I change my acw list to dcv dictionary, how now I can use this loop?
val_list_err_dcv = []
for rang in dcv:
dmm.set_range(rng=str(rang))
fluke.set_output_volt("0")
fluke.switch_output(1... |
|
Irv1n |
General Coding Help |
5 |
3,241 |
Sep-16-2021, 07:38 PM |
|
|
Thread: openpyxl insert list with formulas
Post: RE: openpyxl insert list with formulas
Okey i rewrite my code and its work:
wb = Workbook()
ws = wb.active
listf = [[1,1,1,1], [2,2,2,2], [3,3,3,3]]
def col_writer(row_number, column_number, lst):
for c_index, col in enumerate(lst, s... |
|
Irv1n |
General Coding Help |
1 |
1,560 |
Sep-16-2021, 08:10 AM |
|
|
Thread: openpyxl insert list with formulas
Post: openpyxl insert list with formulas
Hello
I have this code:
wb = Workbook()
ws = wb.active
listf = [[1,1,1,1], [2,2,2,2], [3,3,3,3]]
calc_lst = [['=СЧЁТЕСЛИ(listf[x];"<>")'], ["=СРЗНАЧ(listf[x]"], ["=СТАНДОТКЛОН(listf[x])"], ['=СТ... |
|
Irv1n |
General Coding Help |
1 |
1,560 |
Sep-15-2021, 02:04 PM |
|
|
Thread: Loop with choose
Post: RE: Loop with choose
I have error:
rang = acw.get[index]"List[float]" has no attribute "get"
okey this may work:
rang = acw[index] |
|
Irv1n |
General Coding Help |
5 |
3,241 |
Aug-20-2021, 10:44 AM |
|
|
Thread: Loop with choose
Post: Loop with choose
Hello,
I have this script:
acw = [0.500, 0.750, 1.000, 1.500, 2.000, 3.000, 3.500, 4.000, 4.500, 5.000]
for rang in acw:
dmm.set_mode_acw(rang)
dmm.switch_output(1)
time.sleep(10)
val_... |
|
Irv1n |
General Coding Help |
5 |
3,241 |
Aug-12-2021, 03:50 PM |
|
|
Thread: Uncertainty Calculation
Post: Uncertainty Calculation
I have 3 list:
dcv_range = [0.1, 1, 10 ,100 ,1000] # range
# Accuracy is given as ± (% measurement +% of range)
dcv_accuracy_meas_90d = [0.0025, 0.0018, 0.0018, 0.0027, 0.0031] # measurement accuracy
... |
|
Irv1n |
General Coding Help |
1 |
1,581 |
Jul-29-2021, 07:21 AM |
|
|
Thread: Path to the desired value
Post: Path to the desired value
Hi I try to read text from path:
browser.find_element_by_xpath("//table[@class=' example display cell-border records_list']/tbody/tr/td[5]").textbut have empty string.
The value I need is circled in ... |
|
Irv1n |
Web Scraping & Web Development |
2 |
2,029 |
Jul-24-2021, 03:38 PM |
|
|
Thread: Dictionary generator
Post: RE: Dictionary generator
(Jul-20-2021, 04:30 PM)bowlofred Wrote: That depends on you and what you want. The code you have above needs some tweaks (Some of the "V" are not quoted and it looks like none of the "Hz" are quote... |
|
Irv1n |
General Coding Help |
5 |
2,751 |
Jul-20-2021, 04:56 PM |
|
|
Thread: Dictionary generator
Post: Dictionary generator
I need ideas how to implement such a dictionary, where the program will request data and ultimately get this kind of dictionary?
For example:
ac_voltage_multimeter = {(10, V): {(50, Hz): ((9, 'V'),),... |
|
Irv1n |
General Coding Help |
5 |
2,751 |
Jul-20-2021, 04:12 PM |
|
|
Thread: Derivative function
Post: Derivative function
import sympy as sym
def sens_coef(self, U_err, I_sd, I_err, I_dig):
U_err, I_sd, I_err, I_dig = sym.symbols('U_err I_sd I_err I_dig')
R = (U_err)/(I_sd + I_err + I_dig)
s... |
|
Irv1n |
General Coding Help |
1 |
1,896 |
May-01-2021, 06:49 AM |
|
|
Thread: Dictionary with ranges that have a float step value
Post: Dictionary with ranges that have a float step valu...
Hello to all!
I need to create dictionary like this:
rcd_curr = {'SOUR:SAF:RCDC': {0.025: (?????), 0.25: (???????), 2.5: (???????)}}
for key 0.025 I need generate values from 0.020 with step 0.0001
f... |
|
Irv1n |
General Coding Help |
2 |
2,122 |
Apr-21-2021, 07:35 PM |
|
|
Thread: transform result to DataFrame
Post: RE: transform result to DataFrame
Okey, I decided my question. Now I have another question:
How I can name column with two names, like this:
Range 0.1 Range 0.1
Point 0.1. Poin -0.1
0 0.099999 -0.099999
1 0.099998 -0.09... |
|
Irv1n |
Data Science |
1 |
2,089 |
Jan-29-2021, 10:08 PM |
|
|
Thread: transform result to DataFrame
Post: transform result to DataFrame
Hi to all! Can anyone help me with this:
My code:
ver_val = OrderedDict()
ver_val[0.1] = [0.1, -0.1]
ver_val[1] = [1, -1]
ver_val[10] = [1, 5, 10, -1, -5, -10]
ver_val[100] = [100, -100]
ver_val[1000... |
|
Irv1n |
Data Science |
1 |
2,089 |
Jan-28-2021, 06:47 PM |