Tag: DATE

Feed: Planet PostgreSQL. One of the handy things Oracle does with dates is allow manipulation with standard arithmetic. Want tomorrow's date? Add one. Want a week ago? Subtract seven. Postgres does something close with its INTERVAL syntax, under the explanation that we don't necessarily want to make assumptions about what is being added to a date or timestamp. But Postgres has a big secret in the fact we can arbitrarily create operators to get the behavior we desire. No Place for Beginners or Sensitive Hearts So what happens if we happen to know that the developers and applications targeting the ... Read More

Feed: R-bloggers. Author: business-science.io - Articles. We have several announcements regarding Business Science R packages. First, as of this week the R package formerly known as timekit has changed to timetk for time series tool kit. There are a few “breaking” changes because of the name change, and this is discussed further below. Second, the sweep and tidyquant packages have several improvements, which are discussed in detail below. Finally, don’t miss a beat on future news, events and information by following us on social media. The timetk package (formerly timekit) is a relatively new package that is aimed at assisting ... Read More

Feed: IDERA Community Blog; Author: Binh Chau; We are pleased to announce the general availability of SQL Inventory Manager 2.4. Existing users may access through the Idera Customer Portal. New users may download the trial version from the Idera Website. What's new is version 2.4? SQL Inventory Manager 2.4 delivers a number of user improvements to help database administrators assess, manage and report on complex SQL server environments. New reporting functionality - We are providing a set of reports that will allow DBA managers to assess their organization’s current data usage and data needs.  Database administrators and managers can provide ... Read More

Feed: R-bloggers. Author: Nick Horton. I’ve been reading David Robinson’s excellent blog entry “Teach the tidyverse to beginners” (http://varianceexplained.org/r/teach-tidyverse), which argues that a tidyverse approach is the best way to teach beginners.  He summarizes two competing curricula: 1) “Base R first”: teach syntax such as $ and [[]], built in functions like ave() and tapply(), and use base graphics 2) “Tidyverse first”: start from scratch with pipes (%>%) and leverage dplyr and use ggplot2 for graphics If I had to choose one of these approaches, I’d also go with 2) (“Tidyverse first”), since it helps to move us closer to helping ... Read More

Feed: R-bloggers. Author: Econometrics and Free Software. I was recently confronted to a situation that required going from a long dataset to a wide dataset, but with a small twist: there were two datasets, which I had to merge into one. You might wonder what kinda crappy twist that is, right? Well, let’s take a look at the data:data1; data2 ## # A tibble: 20 x 4 ## country date variable_1 value ## ## 1 lu 01/01/2005 maybe 22 ## 2 lu 01/07/2005 maybe 13 ## 3 lu 01/01/2006 maybe 40 ## 4 lu 01/07/2006 maybe 25 ## 5 lu ... Read More

Feed: Hortonworks Blog – Hortonworks. Author: Melissa Park. Join us in Sydney on September 20-21 for DataWorks Summit/Hadoop Summit, the industry’s premier big data community event. Attend this year and learn from your peers and industry experts how open source technologies enable you to leverage all your data, on premise and in the cloud, to drive predictive analytics, distributed deep-learning, and artificial intelligence initiatives. Planning is well underway and we can’t wait to deliver our biggest and best APAC Summit to-date! Here are just a few of the reasons you will want to attend: Over 60 sessions of cutting edge ... Read More

Feed: Featured Blog Posts - Data Science Central. Author: William Vorhies. Summary:  There are a variety of new Automated Machine Learning (AML) platforms emerging that led us recently to ask if we’d be automated and unemployed any time soon.  In this article we’ll cover the “Professional AML tools”.  They require that you be fluent in R or Python which means that Citizen Data Scientists won’t be using them.  They also significantly enhance productivity and reduce the redundant and tedious work that’s part of model building. Last week we wrote about Automated Machine Learning (AML) and particularly about a breed of ... Read More

Feed: Featured Blog Posts - Data Science Central. Author: balram prasad. In 2015, I was working at Diebold where we build ATM machine hardware and software and complete ecosystem around the ATM. When we talk about ATM machine, it is a collection of very complex small hardware which collectively performs tasks. And typically, when we think ATM is only used for cash withdraw and that is not true. When we talk about ATM it is a Bank branch itself. You can deposit cash, withdraw cash, deposit cheques. And Whatever we can do in the branch we can do with ATM ... Read More

Feed: R-bloggers. Author: That’s so Random. I am working on v.0.4.0 of the padr package this summer. Two new features that will be added are wrappers around seq.Date and seq.POSIXt. Since it is going to take a while before the new release is on CRAN, I go ahead and do an early presentation of these functions. Date and datetime parsing in base R are powerful and comprehensive, but also tedious. They can slow you down in your programming or analysis. Luckily, good wrappers and alternatives exist, at least the ymd{_h}{m}{s} suite from lubridate and Dirk Eddelbuettel’s anytime. These functions remove ... Read More

Feed: Hortonworks Blog – Hortonworks. Author: Kevin Jordan. Have you ever thought about the amount of energy you consume just by leaving your laptop plugged in overnight? We might not know how many kilowatt hours we transmit, but we do know there is a bill at the end of each month associated with those kinds of statistics. Through smart meters, utility and energy companies must have an accurate account of energy consumption in order to prevent outages, increase grid reliability, and detect fraud. The challenge becomes making sure the dollars they charge matches up to the data they collect. Big ... Read More