Saving hours of work with AI: How ChatGPT became my virtual assistant for a data project – ZDNet

David Gewirtz/ZDNET

There's certainly been a lot of golly-wow, gee-whiz press about generative artificial intelligence (AI) over the past year or so. I'm certainly guilty of producing some of it myself. But tools like ChatGPT are also just that: tools. They can be used to help out with projects just like other productivity software.

Today, I'll walk you through a quick project where ChatGPT saved me a few hours of grunt work. While you're unlikely to need to do the same project, I'll share my thinking for the prompts, which may inspire you to use ChatGPT as a workhorse tool for some of your projects.

Also: 4 generative AI tools your enterprise can leverage to boost productivity

This is just the sort of project I would have assigned to a human assistant, back when I had human assistants. I'm telling you this fact because I structured the assignments for ChatGPT similarly to how I would have for someone working for me, back when I was sitting in a cubicle as a managerial cog of a giant corporation.

In a month or so, I'll post what I like to call a "stunt article." Stunt articles are projects I come up with that are fun and that I know readers will be interested in. The article I'm working on is a rundown of how much computer gear I can buy from Temu for under $100 total. I came in at $99.77.

Putting this article together involved looking on the Temu site for items to spotlight. For example, I found an iPad keyboard and mouse that cost about $6.

Also: Is Temu legit? What to know before you place an order

To stay under my $100 budget, I wanted to add all the Temu links to a spreadsheet, find each price, and then move things around until I got the exact total budget I wanted to spend.

The challenge was converting the Temu links into something useful. That's where ChatGPT came in.

The first thing I did was gather all my links. For each product, I copied the link from Temu and pasted it into a Notion page. When pasting a URL, Notion gives you the option to create bookmark blocks that not only contain links but also contain, crucially, product names. Here's a snapshot of that page:

As you can see, I've started selecting the blocks. Once you select all the blocks, you can copy them. I just pasted the entire set into a text editor, which looked like this:

The page looks ugly, but the result is useful.

Let's take a look at one of the data blocks. I switched my editor out of dark mode so it's easier for you to see the data elements in the block:

There are three key elements. The gold text shows the name of the product, surrounded by braces. The green text is the base URL of the product, surrounded by parenthesis. There's a question mark that separates the main page URL from all the random tracking data passed to the Temu page. I just wanted the main URL. The purple sections highlight the delimiters -- this is the data we're going to feed into ChatGPT.

I first fed ChatGPT this prompt:

Accept the following data and await further instructions.

Then I copied all the information from the text editor and pasted it into ChatGPT. At this point, ChatGPT knew to wait for more details.

The next step is where the meat of the project took place. I wanted ChatGPT to pull out the titles and the links, and leave the rest behind. Here's that prompt:

The data above consists of a series of blocks of data. At the beginning of each block is a section within [] brackets. For each block, designate this as TITLE.

Following the [] brackets is an open paren (followed by a web URL). For each block, extract that URL, but dispose of everything following the question mark, and also dispose of the question mark. Most URLs will then end in .html. We will designate this as URL.

For each block, display the TITLE followed by a carriage return, followed by the URL, followed by two newlines.

This process accomplished two things. It allowed me to name the data, so I could refer to it later. The process also allowed me to test whether ChatGPT understood the assignment.

Also: How to use ChatGPT

ChatGPT did the assignment correctly but stopped about two-thirds through when its buffer ran out. I told the bot to continue and got the rest of the data.

Doing this process by hand would have involved lots of annoying cutting and pasting. ChatGPT did the work in less than a minute.

For my project, Temu's titles are just too much. Instead of:

10 Inch LCD Writing Tablet, Electronis Memo With Leather Protective Case, Electronic Drawing Board For Digital Handwriting Pad Doodle Board, Gifts For

I wanted something more like:

LCD writing tablet with case

I gave this assignment to ChatGPT as well. I reminded the tool that it had previously parsed and identified the data. I find that reminding ChatGPT about a previous step helps it more reliably incorporate that step into subsequent steps. Then I told it to give me titles. Here's that prompt:

You just created a list with TITLE and URL. Do you remember? For the above items, please summarize the TITLE items in 4-6 words each. Only capitalize proper words and the first word. Give it back to me in a bullet list.

I got back a list like this, but for all 26 items:

My goal was to copy and paste this list of clickable links into Excel so I could use column math to play around with the items I planned to order, adding and removing items until I got to my $100 budget. I wanted the names clickable in the spreadsheet because it would be much easier to manage and jump back and forth between Temu and my project spreadsheet.

So, my final ChatGPT task was to turn the list above into a set of clickable links. Again, I started by reminding the tool of the work it had completed. Then I told it to create a list with links:

Do you see the bulleted list you just created? That is a list of summarized titles.

Okay, make the same list again, but turn each summarized title into a live web link with its corresponding URL.

And that was that. I got all the links I needed and ChatGPT did all the grunt work. I pasted the results into my spreadsheet, chose the products, and placed the order.

Also: 6 ways ChatGPT can make your everyday life easier

This is the final spreadsheet. There were more products when I started the process, but I added and removed them from the REMAINING column until I got the budget I was aiming for:

This was a project I could have done myself. But it would have required a ton of cutting and pasting, and a reasonable amount of extra thought to summarize all the product titles. It would have taken me two or three hours of grunt work and probably added to my wrist pain.

But by thinking this work through as an assignment that could be delegated, the entire ChatGPT experience took me less than 10 minutes. It probably took me less time to use ChatGPT to do all that grunt work and write this article than it would have taken me to do all that cutting, pasting, and summarizing.

Also:Thanks to my 5 favorite AI tools, I'm working smarter now

This sort of project isn't fancy and it isn't sexy. But it saved me a few hours of work I would have found tedious and unpleasant. Next time you have a data-parsing project, consider using ChatGPT.

Oh, and stay tuned. As soon as Temu sends me their haul, I'll post the detailed article about how much tech gear you can get for under $100. It'll be fun. See you there.

You can follow my day-to-day project updates on social media. Be sure to subscribe to my weekly update newsletter, and follow me on Twitter/X at @DavidGewirtz, on Facebook at Facebook.com/DavidGewirtz, on Instagram at Instagram.com/DavidGewirtz, and on YouTube at YouTube.com/DavidGewirtzTV.

Excerpt from:

Saving hours of work with AI: How ChatGPT became my virtual assistant for a data project - ZDNet

The Degenerate’s Gambit: 2023 Week 15 NFL Gambling Lines with Tony – Football Absurdity

Welcome back to The Degenerates Gambit! Once again, please remember that these articles are for fun, and while I love writing them and gambling on football, if you or someone you know is addicted and needs help, please get help or get help for them. The national helpline number is 1-800-522-4700.

Were here early this week, as Im trying to get all my writing, podcasting, and picks in before MY WEDDING on Saturday. The powers behind Big Wedding have conspired to have my nuptials in the first week of the fantasy playoffs, so while Ill be tying the knot with the love of my life, its also a great excuse to not have to sit through the Bengals and Vikings fumble their way around lost seasons. Truly a galaxy-brain decision on my fiancees part.

Selflessly, Ive decided that Im giving you a wedding gift for being a loyal degenerate: 4 banger picks for this weekends upcoming games.

The Colts rank incredibly high on Walker Kellys patented Chaosmeter. Im not sure of the statistical implications, but I do know that its incredibly easy to beat any team with Mitchell Trubisky under center. George Pickens is having a Stevie Johnson-level existential crisis every time he runs a route, the team is still determined to run Najee into dust, and they cant stop opposing offenses. A big Michael Pittman week awaits us, and the Colts walk away with a win.

Carolina is a bad football team, who couldve seen that one coming? At the same time, Arthur Smith is learning that maybe leading with a scheme that gets his best players the ball is worth running. Atlanta runs zone the most in the league, and Carolina gives up the second most yards to zone runs. Atlanta is a top 3 offense in red zone rush rate, and Carolina gives up the most rushes inside the 5 this season. Smash the Falcons -3, and take as many Bijan overs as you possibly can.

Baltimore should be the number-one seed in a fraudulent AFC this year when all is said and done. With that in mind, they tend to play down to the quality of their opponents. I think this can bite them in the ass and cost them that top seed, but I dont think that letdown happens in this game. Jacksonville is far from a complete team, and Trevor Lawrence at full health covers up a lot of shitty Press Taylor schematic issues. That said, TLaw isnt at full health and the Ravens defense is going to turn up the pressure. Baltimore should win this game handily.

Its my wedding weekend and I can bet on the Bears if I want to, so I will. The Joe Flacco story is truly one to behold, but at the same time this Browns defense is getting absolutely rocked with injuries and I believe in the Justin Fields/DJ Moore connection against the man coverage scheme that Cleveland utilizes extensively (the numbers agree with me). Injuries on the Bears defensive line are also not ideal, but the addition of Montez Sweat has completely turned this defense around. Joe Flacco should be under pressure all game, and the secondary has the ability to smother Amari Cooper. Im taking the Bears on the road, and hoping the win streak extends to 3.

Last Week: 1-2-1 Year to Date: 30-25-1 (3-11 Long Shot Plays)

Continue reading here:

The Degenerate's Gambit: 2023 Week 15 NFL Gambling Lines with Tony - Football Absurdity

In two of the great liberal democracies, freedom of speech stops at Israel – The Irish Times

If theres one thing you read this week, make it Masha Gessens piece in the New Yorker, In the Shadow of the Holocaust. Gessen, one of the finest journalists working today, is caught up in one of those through-the-looking-glass moments we are experiencing regarding the censorship and shunning of countless academics, public intellectuals, artists and journalists in relation to any kind of critique or even contextual framing of Israels policies and bombardment of Gaza.

In an interview in the Washington Post, Gessen said that the Heinrich Bll Foundation which sponsors the Hannah Arendt Prize for Political Thought pulled its support for the presentation of the prize to Gessen, who is Jewish. The Post quoted the foundation as saying that Gessens piece implies that Israel aims to liquidate Gaza like a Nazi ghetto This statement is not an offer for open discussion; it does not help to understand the conflict in the Middle East.

However, the Hannah Arendt organisation has not rescinded the prize. Its a slightly absurdist hypothetical to posit, but under the current conditions in Germany, could Arendt herself famous for her writing on totalitarianism even be awarded the Hannah Arendt Prize today without opposition? I doubt it.

[Seven arrested in Germany, Denmark, the Netherlands over suspected terrorism plots]

[Empathy key in Germanys link to Israel, says former ambassador to Ireland]

Germany and America present themselves as open and progressive societies where people can express themselves freely. In the context of any desire to call out Israels abhorrent slaughter of innocent people in Gaza, this is a fantasy. Unless real progressives, genuine democrats, those who authentically believe in free societies stop this rot, these two countries in particular Germany and the US are going to fold their hypocritical concepts of freedom in on themselves. All that will be left is the shadow of an aspiration operating in darkness.

In February 2012, I travelled to multiple Russian cities with the band And So I Watch You From Afar and, late at night, would chat to their young fans about their context. A sort of code emerged that almost felt like jazz, navigating and interpreting the gaps and silences to extract meanings, gently searching for their assessment of the political and social conditions they were living under. A week after I flew home from Moscow, Pussy Riot walked into the Cathedral of Christ the Saviour, a few hundred metres from the Kremlin, and began a performance that would lead to global fame and their arrest.

You dont protect democracy by rounding up protesters calling for peace, or censoring or silencing journalists, artists and public intellectuals

Ive also travelled to countries where being gay is punishable by imprisonment, and where the threat to safety is very obvious should the fact of ones sexuality become known, and so I have outright lied about my sexuality when asked, in order to preserve my personal safety.

None of this felt as unnerving as what I experienced in New York in October. The consequences of striking up a conversation about the Israeli attacks on Gaza wouldnt be particularly severe. They might cause anger or a profound social awkwardness. But it was the lie of Americas freedom of speech that felt so grotesque. I was disturbing myself by participating in the sort of social censorship that hung over the city; being careful about who I spoke to about what was going on, talking in low tones when in public, engaging in the game of not mentioning what was on everyones mind when it was so obviously being left out of conversation. Police rounded up protesters, many of them Jewish. If there is one good thing to take from America right now, it is the actions of Jewish Voice for Peace, who are putting their bodies on the line in the name of peace.

In this context which feels so specifically disturbing when one is in it America is not fighting anti-Semitism. It is performing that fight, but actually behaving in a manner that can only lead to the comparative naming of a single term: McCarthyism.

[US vetoes UN call for immediate humanitarian ceasefire in Gaza]

[Pro-Palestinian demonstration held outside US ambassadors residence in Dublin]

An Irishwoman, Julie Fogarty, who has lived in Berlin for 15 years, recently co-organised a Gig for Gaza, directly inspired by the Dublin event. Whatever about raising money, Fogarty told me, it came from a sense that we had to show the Palestinian community and there is a huge Palestinian population in Berlin that we are with them. I just wanted them to know: people do support you, people are here in solidarity, there are white Europeans who stand with you, people in the Berlin queer community do stand with you.

Fogarty characterises the current atmosphere of censorship in Germany as insane and a nightmare. She said she was shocked by the actions of the Berlin police at early protests where she saw young Arab men being pulled out of crowds and beaten. Over here, a demo could have a hundred people at it, she said, and there will be just as many heavily militarised police, guns, constantly filming the protest. This is for a peaceful demonstration. You cant help now but think of their history in relation to that.

You dont protect democracy by rounding up protesters calling for peace, or censoring or silencing journalists, artists and public intellectuals. When freedoms fall apart in democracies, its often not only due to attacks on democracy instigated by the fascistic. The collapse includes the assistance and facilitation of impositions on civil liberties and freedom of expression by the forces that characterise themselves as the centre. This is whats happening in America. Its also whats happening in Germany.

When the far right triumphs or obtains more power in these countries, it will be important for those who claim to resist such futures, yet replicate their trademarks of oppression, to examine what they did, what they didnt do, and why. It will also be too late.

Go here to read the rest:

In two of the great liberal democracies, freedom of speech stops at Israel - The Irish Times

Don’t knock the economic value of majoring in the liberal arts | Brookings – Brookings Institution

For years, economists and more than a few worried parents have argued over whether a liberal arts degree is worth the price. The debate now seems to be over, and the answer is 'no.'

Can we please lighten up on knocking the value of a liberal arts education? With a recent spate of bad press for liberal arts departments on university campuses, many commentators conclude that the writing is on the wall. When it comes to economics, I argue the liberal arts still belong on college campuses: The liberal arts pay.

There are many reasons to be legitimately concerned about the direction the humanities and other liberal arts have taken in recent decades. Course enrollments and declared majors have plummeted across many disciplines since the pandemic, ranging from history to foreign language. This is the continuation of a decades-old pattern: According to the American Academy of Arts and Sciences Humanities Project, the share of humanities degrees out of all bachelors degrees peaked in 1967 at 17.2% and by 2018 had fallen to 4.4%.

Research universities also continue to turn out humanities doctorates for whom job prospects are bleak. Liberal arts colleges have been at risk for decades.

Despite arguments that a liberal arts education may be exactly the right preparation for a world in which routine tasks are taken over by AI, students are apparently not yet persuaded. Thus, humanities departments in colleges face very real budget pressures, including sometimes the risk of being eliminated. Indeed, West Virginia University is eliminating all foreign language degrees, and the University of Nebraska at Kearney has also proposed cutting its theater and philosophy programs.

I suspect that part of the political push to eliminate the humanities, especially from off-campus sources, is connected to the myth that the price of college has skyrocketed. In fact, the real price of college attendance has been falling modestly in recent years. Consequently, the share of undergraduates taking out student loans and the loan values are also down slightly.

Since Im an economist, in what follows Im going to stick to earnings numbers. But I also recognize there is more to a career than earnings. The American Academy of Arts and Sciences reports that responses to the statement I am deeply interested in the work I do are about the same for majors in the arts, humanities, engineering, and social sciences, although responses were a little higher in education and the natural sciences. And for a good reminder that careers are not all there is to life, see this article by a former poet laureate of Mississippi who writes, Students who master written and spoken communication can change the world.

Angst notwithstanding, here are two facts that are both true:

Heres a picture that illustrates why both are true.

Using data from the American Community Survey (ACS) collected between 2017 and 2021, Ive looked at graduates falling into one of four categories: education ended with a high school diploma, education ended with an associate degree, education ended with a bachelors degree in a liberal arts field, and education ended with a bachelors degree in a field other than liberal arts. Using the categories provided in the ACS, Ive defined liberal arts majors as Area, Ethnic, and Civilization Studies, Linguistics and Foreign Languages, English Language, Literature, and Composition, Liberal Arts and Humanities, Fine Arts, and History. Everything else Im categorizing as not liberal arts. The figure above gives average annual wage and salary income for each kind of degree. (The latest data is for 2021, so all the figures are in 2021 dollars. The sample is for ages 23 through 65. For a similar analysis with slightly older data but a broader listing of majors, see The College Payoff.)

For fact number one, compare the dark blue liberal arts bachelors bar to the orange bar for other majors. The latter is considerably higher. On average, people with a liberal arts degree earned only $50,000 a year while those with other degrees earned $65,000. Thats a big difference. (Median earnings are lower than average earnings of course, but the gap isnt much different$37,000 versus $50,000.)

For fact number two, compare the dark blue liberal arts bar to the light blue bar for those earning only a high school diploma. The liberal arts bar is much highergetting a liberal arts degree is a good investment compared to not going to college at all. On average, the liberal arts degree led to a $50,000 annual income compared to $28,000 for those stopping at the end of high school. (Median earnings are $37,000 versus $21,000 for high school only.) A $12,000 annual difference in earnings will, over a lifetime, more than pay for a college education. Suppose one worked for 35 years after graduation. The lifetime difference would be $420,000 (ignoring inflation). That way, way more than makes up the cost of tuition plus and foregone earnings from a student not working while in college. Unsurprisingly, pay associated with an associate degree falls in between what liberal arts bachelors degrees earn and what one gets with a high school diploma. Its worth noting that employment rates in the data also follow a similar pattern: strongest for non-liberal-arts bachelors holders (81.9%), followed by liberal arts bachelors holders (78.5%), then associate degree holders (77%), then high school graduates only (64.4%).

An important part of the story is that right out of college, liberal arts majors do not earn much more than high school graduates, though this understates earnings potential over the long term. Earnings for all college graduates rise rapidly after graduation and continue to rise for decades. In contrast, the age-earnings profile of high school graduates is relatively flat. One hidden advantage of majoring in non-STEM fields is that students learn general skills that last a lifetime, where the specific skills in more technical subjects often have a shorter shelf life and differences between majors eventually narrow later down the career path.

The picture above shows average earnings for holders of each credential across different survey respondents ages; this provides a plausible pathway for earnings over the course of ones career (though its possible nobodys career path looks exactly like this). At age 22, the liberal arts line is not much higher than either the high school or associate degree lines. But the liberal arts bachelors line rises very rapidlymuch more so than is true for either high school graduates or those whove earned an associate degree. You can also see that graduates with bachelors degrees outside the liberal arts do begin their careers earning noticeably more than either liberal arts majors or high school graduates, and the gap grows over time. For example, at age 50, the average earnings with a liberal arts degree are $67,000 a year. Thats not as good as a non-liberal arts degree at $81,000, but its quite a bit better than an associate degree at $49,000 or a high school diploma at $33,000.

One hopes that students go to college for more than just the financial value of the degreenot just for their own sake but also because society needs a citizenry equipped to think broadly. But that hope aside, liberal arts degrees do pay. They dont pay as well as other college degrees, but they do pay and policymakers need to be clear-eyed about that before running roughshod across humanities departments. The humanities are indeed in trouble, but its silly to say that a liberal arts degree is not worth the price.

Read this article:

Don't knock the economic value of majoring in the liberal arts | Brookings - Brookings Institution