Stack Overflow
Stack Overflow

Questions tagged [dataset]

A dataset is a collection of data, generally represented in tabular form, with columns signifying different variables and rows signify different members of the set. If you are looking for a freely available dataset for any purpose, please consider asking your question on https://opendata.stackexchange.com.

11414 questions
43
votes
3 answers

LINQ to DataSet, DataTable.AsEnumerable() not recognized

I am brand new to LINQ and am trying to query my DataSet with it. So I followed this example to the letter, and it does not work. I know that my DataTable needs the .AsEnumerable on the end, but it is not recognized by the IDE. What am I doing…
GSTD
  • 1,064
  • 1
  • 12
  • 18
42
votes
9 answers

Is there a Python module to open SPSS files?

Is there a module for Python to open IBM SPSS (i.e. .sav) files? It would be great if there's something up-to-date which doesn't require any additional dll files/libraries.
Lamps1829
  • 2,231
  • 3
  • 24
  • 32
42
votes
2 answers

Iterate through DataSet

I have a DataSet named DataSet1. It contains an unknown number of tables and an unknown number of columns and rows in those tables. I would like to loop through each table and look at all of the data in each row for each column. I'm not sure how…
user902949
  • 529
  • 1
  • 5
  • 10
41
votes
4 answers

DataSet.WriteXml to string

I'm tring to get a string from a DataSet without using GetXml. I'm using WriteXml, instead. How to use it to get a string? Thanks
pistacchio
  • 56,889
  • 107
  • 278
  • 420
41
votes
17 answers

How can you name the Dataset's Tables you return in a stored proc?

I've got the following stored procedure Create procedure psfoo () AS select * from tbA select * from tbB I'm then accessing the data this way : Sql Command mySqlCommand = new SqlCommand("psfoo" , DbConnection) DataSet ds = new DataSet(); …
Brann
  • 31,689
  • 32
  • 113
  • 162
40
votes
17 answers

Datasets for Running Statistical Analysis on

What datasets exist out on the internet that I can run statistical analysis on?
Tal Galili
  • 24,605
  • 44
  • 129
  • 187
39
votes
2 answers

When to use Category rather than Object?

I have a CSV dataset with 40 features that I am handling with Pandas. 7 features are continuous (int32) and the rest of them are categorical. My question is : Should I use the dtype('category') of Pandas for the categorical features, or can I let…
user4640449
  • 589
  • 1
  • 5
  • 9
39
votes
6 answers

List with many dictionaries VS dictionary with few lists?

I am doing some exercises with datasets like so: List with many dictionaries users = [ {"id": 0, "name": "Ashley"}, {"id": 1, "name": "Ben"}, {"id": 2, "name": "Conrad"}, {"id": 3, "name": "Doug"}, {"id": 4, "name": "Evin"}, …
megashigger
  • 8,695
  • 17
  • 47
  • 79
39
votes
2 answers

The source contains no DataRows

DataTable dt = ds.Tables[4].AsEnumerable() .Where(x => ((DateTime)x["EndDate"]).Date >= DateTime.Now.Date) .CopyToDataTable(); ds.Tables[4] has rows but it throws the exception "The source contains no DataRows." Any idea how to handle or…
Mike
  • 751
  • 2
  • 10
  • 25
38
votes
6 answers

ClassCastException with ListView when executing notifyDataSetChanged

I have added a view to the header of listVivew, View TopSearch = (View) View.inflate(this, R.layout.search, null); lv.addHeaderView(TopSearch, null, false); And everything is fine until I try to execute (when data changes)…
bobetko
  • 5,019
  • 14
  • 58
  • 85
37
votes
4 answers

Error: Deleted row information cannot be accessed through the row

To whom this may concern, I have searched a considerable amount of time, to work a way out of this error "Deleted row information cannot be accessed through the row" I understand that once a row has been deleted from a datatable that it cannot be…
jshbrmn
  • 1,737
  • 3
  • 22
  • 52
37
votes
8 answers

C# WPF Combobox select first item

Goodday, I want my combobox to select the first item in it. I am using C# and WPF. I read the data from a DataSet. To fill the combobox: DataTable sitesTable = clGast.SelectAll().Tables[0]; cbGastid.ItemsSource = sitesTable.DefaultView; Combo box…
Roboneter
  • 867
  • 2
  • 13
  • 24
36
votes
4 answers

How to customize hover-template on with what information to show

Here is my dataset: After locking my dataframe by year and grouping by month, I proceed with calculating percentage increase/decrease as a new column; it ends up looking like this: Now for my Plotly plot I use this to display traces and add some…
DGomonov
  • 715
  • 1
  • 7
  • 19
36
votes
4 answers

Javascript charting library for huge data

Does anyone know of a Javascript charting library that can handle huge datasets? By 'huge', I mean drawing a line graph with around 1,000 lines and 25,000 data points in total. (With an uneven distribution of points per line. A lot of lines have…
Adam Nellis
  • 1,500
  • 1
  • 16
  • 23
36
votes
5 answers

What triggers ConstraintException when loading DataSet?

How can I find out which column and value is violating the constraint? The exception message isn't helpful at all: Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints.
Dala
  • 1,869
  • 2
  • 20
  • 22
1 2
3
…
99 100