Click here to Skip to main content
15,891,943 members
Everything / Data

Data

data

Great Reads

by Marc Clifton
An interactive demo of how audit and consistency proofs work
by Ashley Davis
A demo of Highstock using Data-Forge with financial data loaded from Yahoo
by Alexander Semjonov
Developing fastest FFT implementation based on precompile tool using data driven approach
by Garbel Nervadof
Convert HTML table data from a website into PHP array

Latest Articles

by Federico Di Marco
Fededim.Extensions.Configuration.Protected is an improved ConfigurationBuilder which allows partial or full encryption of configuration values stored inside any possible ConfigurationSource and fully integrated in the ASP.NET Core architecture using Data Protection API.
by Bert O Neill
This article provides an overview for developers, on how to quickly generate a dependency Entity Relationship Diagram for a table and its immediately related tables, within SQL Server.
by raddevus
An informal study of the Sqlite database and how many concurrent inserts it can handle. Will help you decide if you want to use Sqlite in your projects.
by Pete O'Hanlon
Rather than littering a razor component with @if (a == b) logic to show items, use render fragments to make a declarative component

All Articles

Sort by Updated

Data 

U 4 May 2024 by Federico Di Marco
Fededim.Extensions.Configuration.Protected is an improved ConfigurationBuilder which allows partial or full encryption of configuration values stored inside any possible ConfigurationSource and fully integrated in the ASP.NET Core architecture using Data Protection API.
N 29 Apr 2024 by Bert O Neill
This article provides an overview for developers, on how to quickly generate a dependency Entity Relationship Diagram for a table and its immediately related tables, within SQL Server.
22 Mar 2024 by raddevus
An informal study of the Sqlite database and how many concurrent inserts it can handle. Will help you decide if you want to use Sqlite in your projects.
15 Feb 2024 by Member 16203518
I have basic knowledges in javascript. I would like to store data linked to object inside collection containing objects of the same type which : - stay in memory (not saved into a suport as harddrive, SSD, etc) - is not called as an array...
18 Aug 2023 by Member 11400059
I find solution: First I use return RedirectToAction("Update", "Product", new { name = productModel.titleENG }); instead of return View("UpdateProduct", new { name = productModel.titleENG }); then in...
18 Aug 2023 by Member 11400059
I created an update page for ASP.NET Core MVC (.NET 7). I want that after user completes the form for update and clicks on Submit, the current page refreshes with new data. The page is refreshed, but the data is not. However, when I click on...
26 Jun 2023 by Pete O'Hanlon
Rather than littering a razor component with @if (a == b) logic to show items, use render fragments to make a declarative component
19 Jun 2023 by Glenn Viroux
How to use multi indexing in pandas, with practical use cases such as monitoring changes in the earth surface temperature.
15 Jun 2023 by Green0011
I'm working on a project to reverse engineer high-frequency trading (HFT) strategies / arbitrage strategies. The goal is to uncover the exact trading strategies employed by the trading algorithms. I'm seeking guidance on how I can detect hidden...
6 Jan 2023 by Lones
Hello everyone, Im trying to create my own data compressor and decompressor I saw some posts here and I tried to change them but there is a problem. Let's say I created a file trial.txt program compressing it but adding a lot of 00 00 00 00...
6 Nov 2022 by Member 15822000
You can use Mostly Harmless Sql Translator: Json Kusto Pandas[^] to translate your sql into kusto/KQL, there is a cookbook for simple sql statements. Good luck! ^_^
6 Nov 2022 by Mangesh9692
Convert KQL query to SQL Problem statement- Check event time stamp is exist in another table. eg In sql we can user "between" and "and" SELECT Evnt_GUID,Transactiontimestamp,* from TestTrasncstion (NOLOCK), ( SELECT star.GlobalID...
16 Oct 2022 by MR-XAN777
I have a ready python project which makes preferences for restaurant menus. And now, I am about to sell it but before selling, I have to make sure it runs only one device. Can I achieve results by using the python license library or getting...
16 Oct 2022 by Richard MacCutchan
Since Python scripts are in source form it is easy for anyone to modify them. However, there are some services that may help: python licensing software - Google Search[^]
4 Oct 2022 by JackF007
Hello, I'm having an issue with my Front-end/ back-end "communication". Basically I am developing a software that take some data from local folders (through express readDir method), then from this data I filtered, created arrays and return a...
30 Sep 2022 by Siddhant Arya
For the problem statement, please refer to the following link of stack overflow: javascript - Balanced System Files Partition Coding Challenge - Stack Overflow[^] I am completely unaware on how to solve the problem, however, just found a code...
30 Sep 2022 by Member 15783945
The first value in array is the total of all file sizes. Which includes the file size of the directory that is being subtracted to find the smallest difference, therefore it needs to be deducted twice, once so the total value is without the...
25 Aug 2022 by Sweety Sauntiyal
void fun1(struct node* head) { if(head == NULL) return; fun1(head->next); printf("%d ", head->data); } What I have tried: WHAT IS WORKING OF THIS CODE???ACCORDING TO ME LAST ELEMENT OF THE LINKED list should print again and again...
25 Aug 2022 by OriginalGriff
It's called recursion, and its a fundamental algorithm. Think about factorials for a moment: N! = N * (N - 1)! for all values of N greater than zero - for all others N! is 1. So if N is 5, then N! can be expressed as 5! = 5 * (5 - 1)! == 5 *...
25 Aug 2022 by merano99
Quote: WHAT IS WORKING OF THIS CODE??? this code showing data of nodes printed in reverse order?? The comment suggests that the output of the elements is unexpected. Since it is a recursive function, one should consider whether the output is...
25 Aug 2022 by Patrice T
Quote: How do i...can solve this problem. This is a problem of data structure topic singly linked list I have to find output of this code There is a simple way to know: Run the code and see the result. There is another way: use the debugger to...
22 Jul 2022 by n.ll
I am using power portal to create a form. I am using a basic form and adding JQuery to it. I have an 'deactivate item number' field that needs to show suggested options as the user types. The table has two columns: item number (a number) and...
22 Jun 2022 by JackF007
Hello guys, I'm trying consistently to use a map() method in order to populate the rows of a table in Javascript. I setup the table for the HTML part in the index file and now I want to get the table populated with the data coming from an array...
22 Jun 2022 by Richard Deeming
Quote: .map(callbackFn(dati)) You are not passing the callbackFn function as the callback to the map function. Instead, you are calling the callbackFn once, passing in the (undefined) variable dati as the parameter. You are then passing the...
15 Jun 2022 by lil_mint
I am trying to store/insert data to my db in mysql using tkinter, I can insert but when I try again, it would say already inserted. Also, the update and delete won't work. Kindly need some help/guide PLEASE. Thank you. :am trying to create a...
15 Jun 2022 by OriginalGriff
Never concatenate strings to build a SQL command. It leaves you wide open to accidental or deliberate SQL Injection attack which can destroy your entire database. Always use Parameterized queries instead. When you concatenate strings, you cause...
12 Jun 2022 by Ayesha Tassaduq
Hi i am trying to store a text file in mangoDb. the text file has data of some generated hashes. but i am receiving this error when i try to store file. Error "failing because no such method exists." % self.__name.split(".")[-1] TypeError:...
12 Jun 2022 by Richard MacCutchan
I just tested this with the MongoDB server running and it works correctly. You need to make sure you have a server instance running on your system.
10 Jun 2022 by ludosoep
Easily convert a request for a page between pagination designs (page sizes)
7 Jun 2022 by Chris_List
I have two tables that must be joined. I am trying to return ONLY a list of invoice numbers since they will be used in an outside script. The trouble is duplicate records are being produced and I do not want errors in my accounting records that...
7 Jun 2022 by OriginalGriff
The problem is that they are distinct entries - they all have different invoice numbers as you would expect. So SQL can't "tell" that you mean to exclude them - or what criteria you might want to use to exclude them. If you only one row, then...
31 May 2022 by Jochen Haar
Class to manage the content of Comma Separated Value Files or to deal with Structured Tables in memory
8 May 2022 by A v Nov2021
Given a csv file of different instances, how do I convert each instance to a xml file? Given : Instantiation, var_a,var_b 1,state0,state1 2,state0,state0 3,state1,state1 4,state1,state0 Output : 4 xml files with different names, each should...
8 May 2022 by Maciej Los
Steps to do: 1. create dataframe from csv data: pandas.read_csv — pandas 1.4.2 documentation[^] 2. convert dataframe into xml: pandas.DataFrame.to_xml — pandas 1.4.2 documentation[^] In case you want to export each row (of csv data) into...
8 May 2022 by Member 11109279
I have a csv file which contains several columns of data, one of which is datetime and the rest are various values. There are multiple rows for which the datetime is the same and only one of the rest of the columns is different. I need to be...
8 May 2022 by Maciej Los
Your requirement is not quite clear. I'd suggest to use pandas.DataFrame[^] with methods: - read_csv[^] - drop_duplicates[^]. For example: #dataframe creation df = pd.DataFrame({ 'brand': ['Yum Yum', 'Yum Yum', 'Indomie', 'Indomie',...
29 Apr 2022 by Richard MacCutchan
You can manipulate Excel data with pandas or A Guide to Excel Spreadsheets in Python With openpyxl – Real Python[^].
13 Apr 2022 by Member 13373308
I have the following data : ID. col1 col2 col3 ----------------------- 1. data1. data2. data7 2. data1. data2. data8 3. data1. data2. data9 I need it to combine these in a single row. ID. col1. col2. col3. col4. col5. col6...
13 Apr 2022 by Graeme_Grant
This google search gives multiple solutions depending on the sql system you are using: sql row to column[^]
19 Mar 2022 by clearwaylaw
What is the best scraping code out there? I have a team in Pakistan that has been scraping data for our lawyer directory. I'm looking for some kind of software? What I have tried: We have a third party that does some work for us, but it's not...
19 Mar 2022 by RickZeeland
Maybe one of these web-scraping-services[^]
18 Mar 2022 by Dave Kreskowiak
There's no such thing as "best scraping code". Sites change their formats all the time and the code you use for one site won't work for the next one.
16 Mar 2022 by honey the codewitch
Get your data on, even on platforms without a reliable STL implementation using these simple but critical classes.
2 Mar 2022 by Oliver Smith 2022
Save time comparing JSON docs and build collaboration features into your applications
15 Jan 2022 by Member 15489508
i Have masterdatafile its about 4GiG And more than 45 million records. How can i load this data in MongoDB? What I have tried: I have tried nothing so far.i just downloaded MongoDb
15 Jan 2022 by OriginalGriff
Perhaps this will help: Import Data into MongoDB[^]
22 Dec 2021 by k5054
Look at this: int count; /* assign a value to count */ char Message[count]; /* creates a buffer of size count */ /* ... a bit later */ unsigned CompressedSize = sizeof(Message)*7/8; Creating an array on the stack with a size determined at...
15 Dec 2021 by KarstenK
OriginalGriff is right. In other languages such code wouldnt compile. A bit nasty but good for code quality. Explanation Better is to write while(--i > 0 ) because when i starts with zero the prefix computes to -1 and than the loop runs a for...
15 Dec 2021 by OriginalGriff
In C (and thus C++) any non-zero value is true - so the loop you found will continue to loop until i has been reduced to zero. Challenges aren't about "finding a code" and submitting it: they are supposed to be "learning experiences" where you...
28 Nov 2021 by Eliza Romanski
I have a problem which i'm finding tricky to solve . I have a data frame that looks like this : ...
9 Nov 2021 by KarNullKa
Is there any reasonable reason to have the numeric ID stored as a string? I have come across a number of occurrences where a number is written as a string in the database or in code. It seems like a waste of space, memory and computer power,...
9 Nov 2021 by OriginalGriff
None whatsoever: always store data in the most appropriate datatype. That means numbers in numeric field (INT, DECIMAL, FLOAT, ...), dates in DATETIME, DATE, or DATETIME2, and only string based data in strings. Storing data in strings when it...
26 Oct 2021 by OriginalGriff
Repost: Deleted. Please do not repost your question; use the Improve question widget to add information or reformat it, but posting it repeatedly just duplicates work, wastes time, and annoys people. The answer isn't going to change because you...
26 Oct 2021 by OriginalGriff
This is a repost of your question from some days ago: Sending messages to phone numbers[^] The answer hasn't changed in the meantime.
5 Oct 2021 by Dave Kreskowiak
From your other post of the same question: Quote: Develop your own work and DO NOT CHEAT. Violator will be found, reported, and penalized with F grade for this course.
23 Sep 2021 by KarstenK
Start with rading my How to start the homework article. It has condensed my 20+ years experience how to solve coding problems like learning from some tutorial.
23 Sep 2021 by CPallini
See, for instance Stack | Set 2 (Infix to Postfix) - GeeksforGeeks[^].
23 Sep 2021 by OriginalGriff
While we are more than willing to help those that are stuck, that doesn't mean that we are here to do it all for you! We can't do all the work, you are either getting paid for this, or it's part of your grades and it wouldn't be at all fair for...
23 Sep 2021 by Richard MacCutchan
Quote: solving but can't seem to figure it. Then you need to go back to your course notes. I am afraid this site does not provide code to order.
31 Aug 2021 by Greg Utas
Here's the class interface. You have to implement the functions. For C++ information, here[^] is my go-to site. #include #include class IntArray { public: IntArray(size_t size); IntArray(const IntArray& that); ...
31 Aug 2021 by Greg Utas
First, this isn't a code-to-order service that does people's homework. But even if someone was willing to do this, the specification is poor. What are the operators >, =, +, -, *, and / supposed to do? For example, does
31 Aug 2021 by Member 13140140
In my work this question has been raised and there are tendencies towards both sides. Perhaps connecting and disconnecting overloads the server, against keeping the connection active and consuming licenses. What do you think about this question?...
31 Aug 2021 by Dave Kreskowiak
Everyone who says it's OK to hold open a connection to the SQL server for the lifetime of an app needs to learn the phrase "do you want fries with that?" ALWAYS open your connection as late as possible, do your work as quickly as possible, and...
31 Aug 2021 by Richard Deeming
Further to the correct advice in solution 1, note that ADO.NET maintains a pool of the low-level connections so that you don't have to: Connection Pooling - ADO.NET | Microsoft Docs[^] If you keep a single connection in use for a long time, you...
31 Aug 2021 by OriginalGriff
Create the connection, open it, use it, close it. In C#, create the connection object in a using statement, and the system will close and dispose it when the object goes out of scope: using (SqlConnection con = new SqlConnection(strConnect)) ...
10 Aug 2021 by CLAUDIO TASSO
Hi guys, I'm new here and I'm trying to read blob data from a SQLite database and I'm not getting it. These data are from a software database that stores measurements performed by a signal acquisition board. Can anyone help me? I'm using Visual...
10 Aug 2021 by OriginalGriff
We can't help you - SQLite and all other databases don't know or care what is in BLOB data, it's just a stream of bytes as far as they are concerned. And what you do to retrieve it is exactly what you are doing: fetch it as an array of bytes....
1 Aug 2021 by OriginalGriff
While we are more than willing to help those that are stuck, that doesn't mean that we are here to do it all for you! We can't do all the work, you are either getting paid for this, or it's part of your grades and it wouldn't be at all fair for...
1 Aug 2021 by Richard MacCutchan
Quote: how to work the remove function. You first need to write it. What you have above does not look anywhere near complete. NB, if I have a toothache then I go to the dentist. Doctors here know nothing about teeth.
30 Jul 2021 by Member 15307080
so for the first data set(2015,2016,2017) you have to just divide the recycle_rate/Enery_saved for the particular waste type. for the second data set(2018,2019) you have to calculate the recycle_rate by doing...
28 Jul 2021 by Richard MacCutchan
The LIKE function is a pattern search so you need to try some of the other operators; see SQL Wildcard Characters[^]
13 Jul 2021 by Richard MacCutchan
See ASP.NET | Open-source web framework for .NET[^], or maybe W3Schools Online Web Tutorials[^]. But if you do not have the technical background you are probably better off going to a company that can create it for you.
30 Jun 2021 by Vaishnavi Desai 2021
#include #include using namespace std; class linprb { private: int no;int *arr;int b;int*p; public: void f(int no,int *arr,int b) { int i,j; j=no%10;//4028%10=8 int intialpos; intialpos=j;//8 for(i=1;arr[j]!=no...
30 Jun 2021 by CPallini
Try #include using namespace std; void insert( int no, int arr[], int b) { int start_position = no % b; int j = start_position; while ( arr[j] != no && arr[j] != 0) { ++j; j %= b; if ( j == start_position) { ...
30 Jun 2021 by Richard MacCutchan
int i; p.f(a[i],x,10);// ???,0,10 You have not initialised i to any value, so that parameter will likely be garbage. In future please: - use proper indentation for your code - do not put multiple statements on the same line - use meaningful...
29 Jun 2021 by OriginalGriff
Compiling does not mean your code is right! :laugh: Think of the development process as writing an email: compiling successfully means that you wrote the email in the right language - English, rather than German for example - not that the email...
24 Jun 2021 by Shivprasad koirala
In this article we will talk about the next 5 interesting SQL Server 2012 features.
7 Jun 2021 by Prasad Nikumbh
I am using Azure data factory(ADF) Pipeline-Copy Activity to copy data from cosmos db to datalake.I have created linkedservice for source (Cosmos db ) and destination (Data lake gen 2- Delimited format (.tsv))as I want my output in tsv format or...
10 May 2021 by Amr Mahmoud 2021
-1 i need to know how can i calculate how much energy in kiloWatt hour (kWh) has Singapore saved per year by recycling, by using this data? waste_type: The type of waste recycled. waste_disposed_of_tonne: The amount of waste that could not be...
10 May 2021 by Member 15192276
Use just the recycled_waste feature and the energy_saved in the energy dataset to get the energy saved for each waste type and the total sum.
29 Apr 2021 by Matthew Dennis
A Redis Client written from the ground up using System.IO.Pipelines, Span, etc
30 Mar 2021 by Maciej Los
First of all, please read this: Visual Representation of SQL Joins[^] I'd try this sql query: SELECT tt.Evnt_GUID, tt.Transactiontimestamp, je.* FROM TestTrasncstion tt(NOLOCK) LEFT JOIN ( SELECT Evnt_GUID , StartTime = MIN(CASE WHEN...
28 Mar 2021 by Member 14122005
Write a recursive function sumRecursive() to find the sum of first n natural numbers. Let us say S(n) is sum of first n natural numbers. It can be defined as a mathematical recursive formula as follows: S(n) = 1 if (n == 1) (Because 1 is the first natural number) S(n) = n + S(n - 1) (Sum of...
27 Mar 2021 by jaideepsinh
I am trying to create an azure ci/cd pipeline for my azure data factory in which I have used databricks notebook. Pipeline got created successfully with the ARM template for ADF but I am not able to see any override parameter for databricks...
17 Mar 2021 by Mohit Tomar
Hi.. I'm pretty new to programming and trying to wrap my head around DS. I was trying to implement Queue on my own before I check the original solution and wrote the following code (so the code might not be the best way to implement a queue). ...
17 Mar 2021 by Mohit Tomar
Thanks for the explanation. After implementing the Queue myself I will surely check how the instructor has implemented it and where I have deviated. Thanks mate.
17 Mar 2021 by OriginalGriff
size_t is an unsigned datatype - it has no concept of negative numbers, so when you cast the integer value -1 to size_t what you get is a very large value because negative integers are stored with the top bit set: an eight bit value for -1 would...
8 Mar 2021 by Member 15093506
I was trying to create a new table. I need to add a column name Status (^ Active/Inactive). I am confused which data type should I select! What I have tried: I did varchar. Am I correct? if not what would be the correct datatype.
8 Mar 2021 by CHill60
For SQL Server and for a simple On/Off, Yes/No, Active/Inactive I might use bit - bit (Transact-SQL) - SQL Server | Microsoft Docs[^] I always question myself when I limit something like this so I would possibly use a char(1) in case some one...
8 Mar 2021 by RedDk
Sure ... "status" being either active or inactive (two values of potential status value ... 0 = inactive, 1 = active (to be typical)). This is what I call a "flag" (from QBASIC days) which is the same thing as True or False. Look up Boolean...
22 Feb 2021 by grilialex
In scientific projects, it is often needed to sample sounds from remote locations, for classification or other purposes. As data link rates may be low or unreliable, transmitting raw samples to inland processing centers may not be an option. An alternative is to do off-line processing in batches.
15 Feb 2021 by Gerry Schmitz
Data Analysis in Excel - Easy Excel Tutorial[^]
10 Feb 2021 by aharris1012
I have a js file with some data with x and y-axis, for a chart. I need to display this data using react Plotly as hooks to my function. How can I accomplish this? What I have tried: Here is my code so far: data.js: export const ScatterData =...