Tag: column

Feed: Recent Announcements. Amazon QuickSight launches custom subtotals at all levels on Pivot Table. QuickSight authors can now customize how subtotals are displayed in Pivot Table, with options to display subtotals for last level, all levels or selected level. This customization is available for both rows and columns. To learn more about custom subtotals, see here. Additionally, Amazon QuickSight introduces ability to show/hide columns for Pivot Table. QuickSight authors can now hide column, row and value fields in Pivot Table similar to that of Table to support advanced analysis use cases from the fields well context menu. Using the show/hide ... Read More

Feed: Planet MySQL; Author: Kedar Vaijanapurkar; As a best practice before dropping a large table in MySQL, pt-archiver can be used to delete all the records in batches. This helps to avoid a situation where your server may get stalled under certain circumstances. I recently read a comment from a user saying “The pt-archiver is not working as expected! It is skipping the last record, which seems like a bug.”. Let’s examine pt-archiver’s default behavior and understand why the author of this comment believes that pt-archiver is bugged (Spoiler: It’s not!). But wait, before continuing on busting the blame, let ... Read More

Feed: R-bloggers. Author: John MacKintosh. [This article was first published on HighlandR, and kindly contributed to R-bloggers]. (You can report issue about the content on this page here) Want to share your content on R-bloggers? click here if you have a blog, or here if you don't. I’m looking into creating some functions to make it easier to carry out quality checks on our database tables.I’m using SQL Server, where tables are referred to in a [database].[schema].[tablename] format, although you can forgo some of this by using the USE statement – USE my_data_base GO Let’s say you want to run ... Read More

Feed: R-bloggers. Author: HighlandR. [This article was first published on HighlandR, and kindly contributed to R-bloggers]. (You can report issue about the content on this page here) Want to share your content on R-bloggers? click here if you have a blog, or here if you don't. I’m looking into creating some functions to make it easier to carry out quality checks on our database tables.I’m using SQL Server, where tables are referred to in a [database].[schema].[tablename] format, although you can forgo some of this by using the USE statement – USE my_data_base GO Let’s say you want to run a ... Read More

Feed: R-bloggers. Author: finnstats. The post String pad to the column in R appeared first on finnstats. If you want to read the original article, click here String pad to the column in R. Are you looking for the latest Data Science Job Vacancies / Internship then click here finnstats. We encourage that you read this article from finnstats to stay up to date.. In R, padding the string to the left, right, or on either side of the column can be done in three ways. We’ll look at how to do it in this lesson. In R, add a ... Read More

Feed: R-bloggers. Author: finnstats. The post Convert column to categorical in R appeared first on finnstats. If you want to read the original article, click here Convert column to categorical in R. Are you looking for the latest Data Science Job Vacancies / Internship then click here finnstats. We encourage that you read this article from finnstats to stay up to date.. In R, as.factor is used to convert a column to a categorical variable (). Let’s look at an example of how to convert column type to categorical in R. Let’s start by making the data frame. Principal Component ... Read More

Feed: R-bloggers. Author: R on head spin - the Heads or Tails blog. This post continues my series on translations between R and Python code for common data science and machine learning tasks. A documented cheat sheet for those such as myself, who frequently switch between the two languages for different tasks. I had written the first post in this series back in late 2020, full of optimism that it would kick off a whole series of frequent posts on the topic. Alas, other projects took precedence, as they often do. Now, I’m back with renewed elan to do more ... Read More

Feed: R-bloggers. Author: kjytay. In this previous post, I showed how you can include a dummy variable for the baseline level in the output of the model.matrix function. In this post, I show how you can make changes to the column names of model.matrix‘s output to make downstream parsing a little easier. Let’s use the iris dataset again: data(iris) str(iris) # 'data.frame': 150 obs. of 5 variables: # $ Sepal.Length: num 5.1 4.9 4.7 4.6 5 5.4 4.6 5 4.4 4.9 ... # $ Sepal.Width : num 3.5 3 3.2 3.1 3.6 3.9 3.4 3.4 2.9 3.1 ... # $ ... Read More

Feed: Recent Announcements. AWS Glue DataBrew customers are now able to custom sort one or multiple columns on their datasets in DataBrew. It enables customers to search and group column values more easily. This transformation is intended for users who want to arrange their data in one or more dimensions using various sorting orders without writing any code. Customers can sort columns in ascending/descending order. Custom sorting allows you to create a specific order to arrange the column values according to your particular needs. You can also view an ordered column immediately without specifying a transformation. Customers can use sorting to ... Read More

Feed: Planet PostgreSQL. Anything I do, especially when it can change execution plans, should have its counterpart to revert back. In PostgreSQL we have an ANALYZE that gathers the statistics used by the query planner, but nothing to remove them. The idea is probably that, anyway, the automatic statistic gathering will put them back. But I still want to be able to control, at least for testing. In YugabyteDB we use the PostgreSQL query planner but with additions to be cluster-aware, because it is a distributed SQL database. This is still in development. In the current version (2.11) ANALYZE is ... Read More