Jump to content

Wikipedia:Reference desk/Archives/Computing/2020 November 22

From Wikipedia, the free encyclopedia
Computing desk
< November 21 << Oct | November | Dec >> November 23 >
Welcome to the Wikipedia Computing Reference Desk Archives
The page you are currently viewing is a transcluded archive page. While you can leave answers for any questions shown below, please ask new questions on one of the current reference desk pages.


November 22

[edit]

Artificial Intelligence to Modernize Video?

[edit]

Is anyone aware of any ongoing projects for using Artificial Intelligence/machine learning to edit older video clips (let's say, e.g., news footage from the 90's) such that they look like they were recorded with present day technology? Similar question: what about using AI to do essentially the same thing to, for example, portraits painted in the 18th century? TheRiseOfSkittlez (talk) 02:34, 22 November 2020 (UTC)[reply]

That seems like the sort of "Enhance" "There" "Identify" thing you see in NCIS and really crappy action films. but I'm no expert, it may well be possible. Fantastic username by the way. {{u|Squeeps10}} {Talk} Please ping when replying. 04:38, 22 November 2020 (UTC)[reply]
Applied to static images, at least two artists have done this: Bas Uterwijk[1][2] and Denis Shiryaev.[3] Earlier, AI technology has been used to create a 3D animation of the Mona Lisa,[4] but rather than looking modern it has a retro look, as if Da Vinci had painted this for his newest invention, the stroboscope. In the YouTube video explaining the method used, at 4:56, it is demonstrated on (a cutout of) the 1883 painting Portrait of an Unknown Woman. However, there should be no principled problem in combining these techniques to make a "deepfake" film of long-dead people (of whom we have good portraits) that looks like it was shot live with modern equipment using time-travelling cinematography. The amount of processing power required may still be a bottleneck in applying such techniques to existing footage so as to bring it up to current quality.  --Lambiam 11:03, 22 November 2020 (UTC)[reply]

TBX to Excel

[edit]

I have a tab separated file I am generating with a list of data. Some of the data is usernames and some of those start with an equals sign "=".

If I do nothing, when imported into Excel (2003), it generates an error as it treats it as a formula (leading "=") but doesn't know the name of the rest of the cell.

I have tried adding a leading single quote to try to get excel to interpret the field as plain text. But it just imports as "'=jim" or whatever.

How can I get "TAB" "=" "jim" "TAB" (alt: \t=jim\t ) to be imported to a cell as "=jim"? Thanks. -- SGBailey (talk) 22:07, 22 November 2020 (UTC)[reply]

I've found an answer. Put the username in double quotes and add a leading "=" sign. Thus ="=jim" works. The cell contains the extra clutter, but that can be removed with a column copy and paste special | value. RESOLVED. -- SGBailey (talk) 22:12, 22 November 2020 (UTC)[reply]

How to edit an SVG image?

[edit]

According to this, Domino's Pizza no longer has operations in South Africa. So the SVG image on the right should be edited to make South Africa grey. But I don't know how to do that. Is there an SVG editor on Linux or Windows that can do this? JIP | Talk 22:39, 22 November 2020 (UTC)[reply]

JIP, the GIMP should do handily. It's the "Open Source Photoshop". Elizium23 (talk) 22:50, 22 November 2020 (UTC)[reply]
No, it didn't work. Although GIMP happily loaded the SVG image in, it converted it to a bitmap which I still had to edit pixel by pixel, and wasn't able to save it back as an SVG image. JIP | Talk 23:06, 22 November 2020 (UTC)[reply]
JIP, have a look at this article and try Libreoffice Draw if you have it? Elizium23 (talk) 01:26, 23 November 2020 (UTC)[reply]
No I don't have it but it should be easy enough to install. But I think I'll do it tomorrow at the earliest, it's already early morning here in Finland and I need to get some sleep. JIP | Talk 01:29, 23 November 2020 (UTC)[reply]
I tested out editing in a text editor, but I have uploaded my test work, so please revert if it is not true. In a text editor (vim) you can see a section labelled additional style rules. .za was styled with " fill: #ff0000", so I deleted the .za, from the list. It then goes back to the default grey style. Graeme Bartlett (talk) 23:57, 22 November 2020 (UTC)[reply]
It might need to be reverted as that article says "16 franchised outlets will continue trading". Graeme Bartlett (talk) 00:01, 23 November 2020 (UTC)[reply]