krakowi

1

votes
1

answer
172

views

How to change vector to bullet point list for htmlOutput?

How can I change vector to bullet point list for htmlOutput? After clicking on data table row, I would like to have a detailed characteristics of each character where vehicle, starship and movie should be listed starting from bullet point. Here is my code, apologize that it is a little bit messy, I...
krakowi
1

votes
1

answer
629

views

Why am I getting ValueError: too many values to unpack (expected 3)?

I found this RGB Image Analysis and tried to play with it on some of random pics. http://marksolters.com/programming/2015/02/27/rgb-histograph.html import numpy as np import mpl_toolkits.mplot3d.axes3d as p3 import matplotlib.pyplot as plt import colorsys from PIL import Image # (1) Import the file...
krakowi
1

votes
1

answer
18

views

set conditional formatting - bottom edge

I would like to set conditional formatting for the range when $B2$B3. Here is my code: Sub AddBorders() Dim rng As Range If ActiveSheet.Name Sheet1.Name Then Exit Sub End If Set rng = Range(Range('A2').End(xlToRight), Range('A2').End(xlDown)) 'rng.Activate rng.FormatConditions.Delete With rng.Form...
krakowi
1

votes
1

answer
18

views

Convert string into float for multiple columns in data frame

I am playing with the data set from FIFA 19 and currently trying to convert string value, wage and release clauses into float values e.g. €110.5M into 110500000. Here is my function which takes text as an argument and returns float value: def text_to_num(text): d = {'K': 3, 'M': 6, 'B': 9} new_tex...
krakowi
1

votes
1

answer
41

views

how to pass a variable from one sub to another?

I am struggling to pass a srcFile variable from one sub to another. I would like to do the following: 1) load source file from my local path in loadFile() sub 2) Set srcFile as my source data workbook 3) I would like to call processWorkbook in my Main program so that it will take my srcFile, pass it...
krakowi
2

votes
1

answer
84

views

Which variable type should be chosen type for .Find(LookAt: = xlPart/xlWhole)?

Here is my problem. I would like my function to return a cell object which can be considered as the data start, depending if you look at the part of the string or at the whole word. Function lookForDataStart(sht, word, searchtype as Variant) Set wordLocation = sht.Range('A1:D150').Find(word, LookAt...
krakowi