Questions tagged [data-table]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0 votes
1 answer
28 views

How to Define KPIs for a product solution

I have to find certain KPIs for a given product solutions and describe data tables to track those KPIs. Context: Our practitioners conduct treatment X in 3 steps with patient, so it leads to 3 ...
user avatar
0 votes
0 answers
6 views

Split a column in rows in Orange

I have an input dataset like Frank Group1::Group2::Group3 Mark Group1 Joe Group2::Group3 and I have to transform it to ...
user avatar
0 votes
0 answers
8 views

Best Way to Display Multidimensional Data in Tables and Graphs for a Specific Example

I am currently struggling with displaying data that I gathered in a proper data scientific way. About the Data For a Uni project I have to create different implementations of the creation of a Voronoi ...
user avatar
0 votes
0 answers
27 views

How to create table for reporting ANOVA results

I would like to export tables for the following result for a repeated measure anova: Here the function which ANOVA test has been implemented ...
user avatar
0 votes
0 answers
27 views

tableau view with dimensions totals, static values and calculation

I try to create a table like the one following. I got 1 line product, 1 dimension "zones" and I want to add few columns : total for pieces on a line, a fixe value for a product(stock mini), ...
user avatar
0 votes
1 answer
23 views

Having issues with DataSet [closed]

I just started learning data science and am having a problem when generating a dataset. Dataset: ...
user avatar
0 votes
0 answers
88 views

Is it worth switching from dplyr code to data.table in r shiny that have various reactive data?

I am sort of new in R & recently came across data.table package that is probably ~ 10 times faster than dplyr in various operations. I have a shiny app based on Covid data that is getting heavier ...
user avatar
  • 101
0 votes
2 answers
99 views

Identifying patterns in tabular data

I have a set of tables containing some thousand entries and some tenths of columns from machine status values of production. The entries are of mixed types like string, float, or timestamp. Each table ...
user avatar
1 vote
1 answer
21 views

Pandas: Group by Single Column Entries [closed]

So have this table above. I'm trying to aggregate the occupations such that the table results in: I've tried using df.groupby(['Occupation']) but I get an error. ...
user avatar
  • 13
1 vote
0 answers
23 views

Are there decisive leaders in programming with tabular data?

What are the most effective bread-and-butter in-memory open source tabular data frameworks today? I have been working with tabular data for years with an in-house solution that integrates with Excel ...
user avatar
1 vote
0 answers
1k views

Calculating % by Dividing Filtered Matrix Columns in MS Power BI

Given: A monthly percentage (%) metric has to be calculated from dividing a column ('Numerator') from one table by a column ('Denominator') from another table, both filtered by month, as given in an ...
user avatar
  • 11
0 votes
1 answer
89 views

How do you see the element of a csv table with many columns (>30) which the names of its columns is more than 10 character in pandas?

How do you see in pandas the element of a csv table with many columns (>25) which the names of its columns is more than 10 character? I have 5000 rows and 32 columns and the label of some columns ...
user avatar
  • 1,576
11 votes
4 answers
57k views

How to Write Multiple Data Frames in an Excel Sheet

I have multiple data frames with same column names. I want to write them together to an excel sheet stacked vertically on top of each other. And between each, there will be a text occupying a row. ...
user avatar
  • 293
4 votes
2 answers
6k views

Mean across every several rows in pandas

I have a table of features and labels where each row has a time stamp. Labels are categorical. They go in a batch where one label repeats several times. Batches with the same label do not have a ...
user avatar
  • 147
0 votes
1 answer
53 views

Software for automated database processing

I faced a problem which I'd like to solve w/o any programming. And looking for a software to do this. I have a dataset, for example: (brand-id, brand-name, product-class-name;) ...
user avatar
1 vote
2 answers
1k views

Theoretical Question: Data.table vs Data.frame with Big Data

I know that I can read in a very large csv file much faster with fread using the data.table ...
user avatar
  • 145
3 votes
1 answer
442 views

Look for previous date in dataframe that has certain column category in R

I have the following data frame: ...
user avatar
  • 141
2 votes
1 answer
30 views

How to make smaller categories with factor character variables

I have this data set with consist of ISO3166 Alpha-2 codes for countries. Example: DE, AD, AE etc They are coded as factor variables in R and there are about 173 observations. Now because there are ...
user avatar
3 votes
4 answers
2k views

rows to columns in data.table R (or Python)

This is something I can't achieve with the reshape2 library for R. I have the following data: ...
user avatar
  • 787
0 votes
1 answer
1k views

R: Calculations based on frequencies / grouped / aggregate data

I am trying to do simple calculations in R when no raw data but grouped data with frequencies is available only. This is the case when I have a large amount of records in a database, say a large SQL ...
user avatar
  • 11
28 votes
4 answers
24k views

Is pandas now faster than data.table?

Here is the GitHub link to the most recent data.table benchmark. The data.table benchmarks has not been updated since 2014. I ...
user avatar
  • 590
1 vote
0 answers
36 views

Table function output and order of arguments

I have a silly question. Below is the output of a logistic regression analysis I did. I notice that when I switch the order of the arguments I put in the table function in R that it also switch the ...
user avatar