Top "Data-analysis" questions

Data Analysis involves extracting meaning and insights from raw data.

How to sort a dataFrame in python pandas by two or more columns?

Suppose I have a dataframe with columns a, b and c, I want to sort the dataframe by column b …

python pandas python-2.7 sorting data-analysis
Peak signal detection in realtime timeseries data

Update: The best performing algorithm so far is this one. This question explores robust algorithms for detecting sudden peaks in …

algorithm language-agnostic time-series signal-processing data-analysis
Fitting polynomial model to data in R

I've read the answers to this question and they are quite helpful, but I need help particularly in R. I …

r curve-fitting data-analysis polynomial-math
Python: pandas merge multiple dataframes

I have diferent dataframes and need to merge them together based on the date column. If I only had two …

python pandas dataframe merge data-analysis
How do I sum values in a column that match a given condition using pandas?

Suppose I have a column like so: a b 1 5 1 7 2 3 1 3 2 5 I want to sum up the values for b where a = 1, …

python pandas dataframe data-analysis
How do I change a single index value in pandas dataframe?

energy.loc['Republic of Korea'] I want to change the value of index from 'Republic of Korea' to 'South Korea'. …

python pandas data-analysis
R and SPSS difference

I will be analysing vast amount of network traffic related data shortly, and will pre-process the data in order to …

r statistics spss data-analysis
Using QUARTILE in an Excel pivot table to summarise data by sub-populations

I've got a large table of data in an Excel spreadsheet that, essentially, can be considered to be a collection …

excel statistics excel-2007 pivot-table data-analysis
How to fix AttributeError: 'Series' object has no attribute 'find'?

I am trying to play with some online data, and having some trouble plotting it due to an 'Attribute' error …

pandas matplotlib time-series data-analysis
Python Pandas join dataframes on index

I am trying to join to dataframe on the same column "Date", the code is as follow: import pandas as …

python pandas indexing data-analysis