Questions tagged [analytics]

For questions related to analytics methods and tools. Use it together with the programming language used

Analytics is typically the application of descriptive statistical methods to large data sets. This is usually in contrast to predictive methods, which relate to unseen data or to tasks that are dependent on the outcome of a model. Analytics is often related to reporting on databases and frequently arises in the context of "web analytics" - a field that encompasses analysis of site traffic, online revenue, site usage, and other interests.

Typical languages used for analytics are R , Python (especially Pandas), SPSS and SAS

4895 questions
1
vote
3 answers

Best way to provide analytics to website users but only for their own pages

I'm building a blog of sorts. The client wants to provide analytics to users for their own posts, including views over time, location of viewers etc. Only the owners of a given post should be presented with information on that post. My initial…
1
vote
2 answers

pandas non equi join in range

I need to do 'pandas non equi join', when first table joined with second table in range. first_table EMPLOYEE_ID SALARY 100 3000.00 101 17000.00 102 17000.00 103 9000.00 104 6000.00 105 4800.00 106 4800.00 ………….. …
Galat
  • 399
  • 6
  • 25
1
vote
0 answers

PageView are not updating while traversing on the website - GTM & GA

Created a new GA Id and attached it in GTA. Added the two JS code in the HTML page of my website. Created a tag in GTM for GA with pageview for all pages of my website. (as shown below) Now, Whenever, I opened any web URL of my website, it is coming…
1
vote
0 answers

How to Calculate FRR & FAR scores using R

I am currently trying to calculate the FAR & FRR of my model. However, I can't seem to find a way to do this. I have managed to calculate the Precision, Recall & Accuracy using the MLmetrics library but no luck for the FAR & FRR. Below is a snippet…
1
vote
1 answer

Can i convert xlsb file to xlsx using python?

I was trying to convert xlsb file to xlsx using Python but I am not able to figure out my problem in my all unsuccessful attempts. Code: import pandas as pd import os import glob source='C:\\Users\\JS Developer\\sample.xlsb' dest= 'C:\\Users\\JS…
Aditya
  • 11
  • 5
1
vote
0 answers

Is it possible to use S3 bucket logs as a hack for privacy oriented/basic analytics?

I am looking for a simple, dirt cheap way to do some basic analytics for my site. I really mean basic and something that respects users privacy + does not use cookies. I was wondering, would it make sense to: - just have an s3 bucket with logging…
mireille raad
  • 281
  • 2
  • 5
  • 26
1
vote
2 answers

Assign Results from query to variable for use in case statement

I am trying to take the avg of a total sample column and compare to the column value off each specific record. I have done this in SQL Server by declaring a variable and then setting it to the results of a query. I am trying to do the same thing in…
hansolo
  • 903
  • 4
  • 12
  • 28
1
vote
1 answer

DataLayer.push is not working on External JavaScript

If we use dataLayer.push and GTM code in external JavaScript the dataLayer.push value is not firing In case If we use dataLayer.push and GTM code in HTML the dataLayer.push value is firing as expected Below is the code which we are used in external…
srini_k
  • 11
  • 1
1
vote
2 answers

How to get grouped sums listed on the same row?

I have below mock up data, itemNum itemName type count ------------------------------------------------- 1111 A001 1 2 1111 A001 1 4 1111 A001 3 …
Benson
  • 189
  • 2
  • 9
1
vote
1 answer

Segments in cube js

I want to implement OR filter functionality in cube.js. This link says we can do this by using segments option in cubejs params. How to use segments and what is its purpose? I tried understanding from the website with their 5 lines of documentation…
Pragya Dalal
  • 68
  • 2
  • 9
1
vote
1 answer

Using Google Analytics with Worldpay

I'm trying to get Google Analytics eCommerce tracking to play nicely with our site's payment gateway, Worldpay. A solution, which I'd prefer NOT to use has been posted (link below), but involves extra clicks for the shopper, which I was hoping to…
1
vote
1 answer

Oracle 12C SQL Aggregate Query Logic

I need help in writing SQL query for below mixed aggregation scenario: Consider below Emp Table. Need to aggregate employee records by manager. Aggregaton Logic: Need top Rating under manager. Eg. for Mgr 10, Rating should be Super , For 30,…
Kapil
  • 137
  • 4
  • 11
1
vote
1 answer

jquery Populate _link() for Google Analytics Asynchronous syntax (cross domain)

To piggy back off what was discussed here, I'm looking to have an existing plug-in updated to help switch me to Google Analytic's "Asynchronous syntax" so onclick events could be applied to our outbound links for cross-domain tracking as shown…
Evan
  • 3,411
  • 7
  • 36
  • 53
1
vote
0 answers

Facebook Pixel displays 'custom_data' with '_removed_' value

I'm using ember-metrics to send custom event to Facebook Pixel. This is my code: this.get('metrics').trackEvent('FacebookPixel', {event:'FreeTrial', custom_data: { location:location, url:'free-trial', campaign:campaign}}); When I go to Facebook…
1
vote
1 answer

Azure Stream Analytics query with multiple inputs

Issue I have a Azure IoT-Hub sending messages to a Azure Stream Analytics Job. Each message contains a 'NodeName'. I have a table 'plcnext_nodes' which has a unique 'NodeId' for each node with their corresponding 'NodeName'. How can I use both the…
Lex
  • 13
  • 3