Qfyilyi

up vote 1 down vote favorite I am using openpyxl for parsing .xlsm files, and pytest for testing. When I open a file, I get the: OpenPyxl -> UserWarning: Data Validation extension is not supported and will be removed That is not really a problem bcs. program works and I can't change the .xlsm file to fix that. But... When I run pytest with something like: def test_wrong_file_format(): assert check_excel(open_excel('file.xlsm')) == True I will get the warning i mentioned altought check_excel(open_excel('file.xlsm')) returns True and the test should suceed... Is there a nice way to tell the pytest that "It's not a bug it's a feature" and tests should pass even when they get this warning? Is there other way than using something like: with pytest.warns(UserWarning): ...

0 I have column SubToBind that shows current year ratio and column PY SubToBind which shows previous year ratio. How can I simply create a card that would be displaying them both in a nice way? Something like that: I cannot achieve that with regular card, I also tried Card with States by OKViz but also unable to see both values. In KPI visual - I dont like the word "Goal", it will confuse end users. Are there any cards or other visuals that would do the job? Thanks powerbi dax powerbi-embedded share | improve this question edited Jun 11 '18 at 20:11 Oleg ...

up vote -2 down vote favorite I need to write a script that will look through a folder and strip out the text from a string of an image. image-w-inch-bob-bob-bob-bob-8820-AV1.jpg image-w-inch-bob-bob-bob-bob-8820-AV2.jpg image-w-inch-bob-bob-bob-bob-8820-AV3.jpg image-w-inch-bob-bob-bob-bob-8820-AV4.jpg image-w-inch-bob-bob-bob-bob-8820-AV5.jpg image-w-inch-bob-bob-bob-bob-8820-AV6.jpg I need this to be renamed to 8820-AV1.jpg 8820-AV2.jpg 8820-AV3.jpg 8820-AV4.jpg 8820-AV5.jpg 8820-AV6.jpg Does anyone know of a script like this? python linux bash share | improve this question edited Nov 21 at 22:22 ...