Questions tagged [sql]
Structured Query Language (SQL) is a language for querying databases. Questions should include code examples, table structure, sample data, and a tag for the DBMS implementation (e.g. MySQL, PostgreSQL, Oracle, MS SQL Server, IBM DB2, etc.) being used.
103
questions
1
vote
0
answers
17
views
Moving a Neural Network to the SQL in R
tl;dr
How do I use something like the tidypredict tool to move a neural network either textbook mlp, or deep, to SQL code?
Background:
This is an example that shows how to convert a linear model to ...
- 163
1
vote
0
answers
10
views
Join 2 columns from the same table into a new column but in seperate rows [closed]
I need to find customers that have multiple applications registered.
I have done a self join and used "WITH" to make it run faster but i also had to use OUTER APPLY STRING_SPLIT function as ...
- 11
1
vote
2
answers
53
views
How can I create a table from an existing table in SQL but using cells from the old table as columns in the new table? [closed]
I have a table,
and I want to create a new table such as the one below (from the table above)
In SQL, I tried using the following commands. I am able to generate a table with only one column like ...
1
vote
0
answers
84
views
Create an amortization table with SQL [closed]
I have a list of credits, let's assume they are only two for ease:
Credit #1 and credit #2: One has 3 months of payments missing and the other has 6 months left of payments.
It would like to obtain a ...
- 2,222
1
vote
0
answers
5
views
Hive Bring Table to Local Driver for Fast Debugging on CLI
I have a large Hive table on HDFS. Every time I query it, it runs a map reduce job which is slow.
For debugging my code on CLI, I want a fast query. Is it possible to sample rows of the table and ...
- 11
1
vote
1
answer
5k
views
Passing tuples (key, value) into parameterized SQL query in Python
NOTE: I am new to this community, so please let me know if I can help you help me!
I built a scraper in python that creates a tuple of (key, value).
I would like to pass both key and value as ...
- 11
1
vote
0
answers
26
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 ...
- 111
1
vote
0
answers
24
views
Getting transportation turnover as null when i filtered by Product nature [closed]
I am pretty new to SQL. When i tried the following query i am getting sum as 0.
Can somebody explain me the problem of the query.
...
1
vote
0
answers
85
views
SQL Oracle - Excel's BETAINV function (Inverse cumulative function of a beta distribution) in SQL Oracle [closed]
Is there a function equal to Excel's BETAINV(probability,alpha,beta,[A],[B]) in Oracle SQL Developer? Or a similar one which I could use to return the inverse cumulative distribution function of a ...
- 2,222
1
vote
0
answers
220
views
Self Union All in Tableau Public for Sankey Diagram
I'm following this 2017 YouTube tutorial from which I hope to learn Sankey diagrams.
At 2:28, he instructs us to select Convert to Custom SQL, after having opened ...
1
vote
0
answers
18
views
Qualitative prediction based off data containing mixed qualitative and quantitative values? [closed]
I'm trying to find a way to predict an integer value based off of an item's prior sale history and am inquiring for a starting point on how to approach this.
The factors are as follows (Data Type in ...
- 11
1
vote
0
answers
781
views
Calculating correlation and covariance in MySQL
I am new to data science taking my first course in Data analysis. I am trying to figure out where to start with a problem solving the correlation and covariance with my sql.
...
- 135
1
vote
0
answers
588
views
How to pass database name as parameter to sql statement in python? [closed]
I have several SQL statements (update, delete, insert,...) in my Python code and all of them ...
1
vote
0
answers
163
views
Python-SQL database [closed]
There are two SQL databases in which one database contains user data and other database contains service data. Firstly, I am connecting the databases and fetching it on python.Based on the user data, ...
- 53
1
vote
1
answer
969
views
Is there an analog to SQL's STRING_AGG (or FOR XML PATH) function in Python?
Asked this in SE but maybe this is too data-oriented so trying to post it here. I am trying to find the analog to the SQL function STRING_AGG so that I can concatenate across columns and rows of a ...
- 13
1
vote
1
answer
930
views
Most Efficient Post Processing with Python and Pandas
This question is about best practices for working in Pandas dataframes. Speed, ease of use, and memory consumed could all impact any answers you might have. I start by pulling a data set into a ...
1
vote
0
answers
18
views
Run queries against results of previously cached queries [closed]
I'm trying to find a tool or workflow that would allow a team to analysis data in multiple steps, where intermediate results are cached. (I'll assume that the raw data is in a relational database and ...
- 111
1
vote
1
answer
182
views
mysql could not recieve table from Citespace [closed]
I created was database through commands (see lower)
...
- 11
0
votes
2
answers
15
views
SQL, count total users' first order for each region, each day
I have a table called orders.
Link for the table here:
table
I want to get the total users' first order in each region, each day.
First, I tried to get the first order for each unique user by doing ...
- 23
0
votes
1
answer
34
views
CASE sentence for SQL query
I have a question abut MySQL
I would like to handle a column with characters without changing the original DB. Below is the levels of the column named 'Maker'.
기아, 현대, BMW, VolksWagen, Porsche
So ...
- 23
0
votes
1
answer
25
views
Why two different series of SQL queries which do the same thing just in a different order have a different number of rows in their outputs?
I am working on a group project for the US Forest Service to create a dashboard on the US's arial firefighting operations and resources. This part is focused on creating a single data table for the ...
- 157
0
votes
1
answer
19
views
How do I get a big-picture feel for my database?
Background: I was just granted access to my company's SQL Server (MS SQL 2019 via Azure Data Studio). As I have not yet been assigned any specific projects I want start digging.
I've asked my DBA to ...
0
votes
1
answer
22
views
query category wise dara
I have stored the some products and there respective category in sql.
Like this. Now I want fetch all product from table with respective category.
output should be=>
- 11
0
votes
1
answer
12
views
Getting the earliest date (duplicates due to several call ids and agents)
I am trying to get the earliest call interaction, with only the agent that interacted at that call and the customer id. Using the following code, I still get duplicates:
...
- 53
0
votes
1
answer
52
views
How to execute a git project with different input data?
I would like to run this project and receive result from this project
However I have problem to execute the step
mailcorpus.json created by executing the sql script
data/get_mail_corpus.sql on ...
- 147
0
votes
1
answer
353
views
How to use features when predicting aggregation?
Let's say I have to predict the total monthly sales of a store. I have the data in the following format:
I don't think I can use this data directly for predicting the sales for a month, as in it's ...
- 101
0
votes
1
answer
133
views
How do I write a SQL (or dwSQL) query across these two different datasets?
I'm having a little fun and I'd love to know how to write a SQL or dwSQL query across these two datasets of Trumps tweets and Facebook posts. Here are the datasets:
Trump Facebook Posts
https://data....
- 109
0
votes
3
answers
137
views
Data manipulation in SQL
I need to write a SQL query where I need the data for the year 2014 from May-Dec and complete data (Jan-Dec) of the year 2015. Can anyone help me with this query?
- 151
0
votes
0
answers
31
views
When using sqldf for join in python, is there a format to be followed for column names inside sql query?
I'm trying to use sqldf to do a left join on python. Here's my code:
...
- 1
0
votes
1
answer
18
views
Why does PowerBI take longer to load data than PowerQuery takes to load preview?
I have a stored procedure in SQL Server and when I open PowerQuery, I can get a preview of the whole table in a minute or two. But once I click 'Apply and Close', it will take AGES to load and finally ...
0
votes
1
answer
18
views
0
votes
0
answers
19
views
Get the average wait time for successful sessions & unsuccessful sessions using SQL
RISE On Demand is a call center application on Microsoft Teams. Customers can initiate online meetings through the company’s website where they can connect with agents to resolve their queries/issues....
0
votes
0
answers
14
views
Power BI: Selecting a column based on a value in another table
In a database, there are two tables... examples as follows:
table_1:
CAGDP9_1
CAGDP9_2
#####
#####
linecode_description_table:
linecode
description
CAGDP9_1
desc here
Suppose I am searching for ...
- 1
0
votes
0
answers
32
views
Equivalent of Presto's 'histogram' function in Azure SQL
I want to get an equivalent function to Presto's 'histogram' which just aggregates counts into a histogram like json, e.g if I have a table called table that looks ...
0
votes
1
answer
80
views
Python-SQL-Excel : When to use them?
I am currently learning data science and learned already a lot of Python not just for data science, also for script writing, web scraping etc. Meanwhile i started to look for how people actually earn ...
- 1
0
votes
0
answers
12
views
How do you publish the direct returned dataset from a SQL server stored procedure inside Power BI instead of using that dataset to populate a report?
I have a sql server stored procedure that return a dataset with very specific ORDER BY parameters. I can import that dataset into Power BI properly, but when I go to create a report using that dataset,...
0
votes
0
answers
15
views
SQL Code for Azure ML Studio
I have a csv file named 'bikebuyers' in which there is only one sheet named 'bibus'.
In this sheet, there are 19 columns and 1001 rows.
The last column is my dependent variable named 'Purchased Bike' ...
- 1
0
votes
0
answers
772
views
How to read a table from MySQL work bench in colab
I have referred to various articles on Stack Overflow and external sources but somehow am unable to get answer for this. I would like to read a table from MySQL workbench database into a dataframe in ...
- 26
0
votes
0
answers
200
views
Computing number of business days between start/end columns
I have two Dataframes
facts:
columns: data, start_date and end_date
holidays:
column: <...
- 101
0
votes
0
answers
47
views
Has anyone joined FHIR resources?
I have FHIR-formatted data (Fast Healthcare Interoperability Resources), that I've converted to CSV using the npm package ndjson-to-csv, and on first glance, this seems useable for ML experimentation, ...
- 101
0
votes
1
answer
24
views
Applied and view jobs ratio
I have the following data set where the column "kind" can be V(view) or A(apply), how can I do the following things given a particular job id how many applicant Apply (A) to that particular ...
- 115
0
votes
1
answer
26
views
How to strategize model training with new data coming in every day?
I have a mysql database in which new records are added every day to raw data. This raw data is cleaned and a ML model is trained with it once a week. What should be the best strategy to capture new ...
0
votes
0
answers
69
views
Using MySQL Common Table Expressions to solve the travelling salesman problem
The problem I'm trying to solve is very similar to the travelling salesman problem, where there are many paths between nodes in the database. I've tried to edit my example to fit into this well-known ...
- 101
0
votes
0
answers
206
views
Best way to store large amounts of time series data? Relational database (SQL) or NoSQL route. Also additional python/pandas question inside
so I'm working on a project and I'm sort of stuck as to how to store my data. I have a concept I want to propose but am unsure whether it is possible, if it is not I would appreciate any help ...
0
votes
1
answer
56
views
Creating a complex featureset for regression modeling
I am currently working a on project that requires me to convert all of the categorical variables to continuous (or binary) variables to build a regression model. The problem is that I have more than ...
- 21
0
votes
0
answers
78
views
Load data from SQL for Machine Learning
I have an SQL DB which has millions of records(10 years of data) and wanted to implement some ML Models. Most of the courses/tutorials explains using a local file or downloaded CSV. But in my case I ...
- 101
0
votes
1
answer
347
views
Running a query in R after establishing dbconnect
I do not seem to figure out what is wrong it the following statement. The connection to the DWH is established but the query statement in R seems not to work, with the following error :
...
- 53
0
votes
1
answer
4k
views
Python & Pandas : (pymysql.err.OperationalError) (2003, "Can't connect to MySQL server on 'localhost' (timed out)")
I'm writing a Python Script to store JSON data into MySQL Database. I used pandas to store into MySQL Database.
I used two different modules (...
- 155
0
votes
1
answer
236
views
What algorithms can be used to derive matching rules between known matches in datasets?
Lets say I have two datasets with different column names except for a unique ID key
Table 1 CSV
...
-1
votes
1
answer
91
views
Sql satament sql server [closed]
I want to know how to display those statement ( what the correct statement for them
Display the name of the school that contain the maximum number of students
For each school, display the number of ...
