The weekly date format used by Google Trends looks like this:
2004-01-04 - 2004-01-10
This might pose a problem for instance if we want to plot the data. We will need to convert the date interval provided by Google Trends into a single date. We can do so using the following code:#First, import the data
data=read.csv(filePath, header=F, blank.lines.skip=F)
#Then select the ending date of the date interval
data[,1]=sapply(data[,1], substr, start=14, stop=30)
#And convert it into a date
data[,1]=as.Date(data[,1], "%Y-%m-%d")
And then you have a date format that you can use for plots or data analysis.
1 comment:
HELLO VIEWERS
TESTIMONY ON HOW I GOT MY LOAN €300,000.00EURO FROM A FINANCE COMPANY LAST WEEK Email for immediate response: drbenjaminfinance@gmail.com
Do you need a loan to start a business or pay your debts {Dr.Benjamin Scarlett Owen} can also help you with a legit loan offer. He Has also helped some other colleagues of mine with a loan finance. Get your Blank ATM card or CREDIT CARD deliver to your doorstep that works in all ATM machines all over the world with the help of BENJAMIN LOAN FINANCE the ATM cards can be used to withdraw at the ATM Machines or swipe, at stores and POS. they give out this cards to all interested clients worldwide, If you need a loan without cost/stress he his the right loan lender to wipe away your financial problems and crisis today. BENJAMIN LOAN FINANCE holds all of the information about how to obtain money quickly and painlessly via Email drbenjaminfinance@gmail.com
Post a Comment