Stack Overflow
Stack Overflow

Questions tagged [series]

A Series object represents a data series. This may be represented as the SeriesCollection class (Java, C#) or Series class in Python Pandas.

  • A series is not necessarily plotted on a chart; it can store data point values that are used to perform a calculation from which another series is created and then plotted. More info available on MSDN.

  • This tag is also used in the context of questions on [pandas] Series. See the pandas tag wiki for more details.

Also see:

3544 questions
1
vote
1 answer

Google calendar script title update

Can anyone help me to get the following script to work for calendarseries. It works perfectly for all single calendar events. But it there is a recurring event it only changes the colour and does not update the title. I want the following to…
adam roberts
  • 11
  • 1
1
vote
1 answer

How to use pandas.Series.dt.strftime can do hourly mapping?

Here's my data: device_create_at 136 2014-08-27 17:29:23 245 2015-09-06 15:46:00 257 2014-09-29 22:26:34 258 2014-11-05 13:02:18 Here's my expected output device_create_at …
Nabih Ibrahim Bawazir
  • 631
  • 2
  • 15
  • 27
1
vote
1 answer

Plotting a multiple column in Pandas (converting strings to floats)

I'd like to plot "MJD" vs "MULTIPLE_MJD" for the data given here:: https://www.dropbox.com/s/cicgc1eiwrz93tg/DR14Q_pruned_several3cols.csv?dl=0 import numpy as np import pandas as pd import matplotlib.pyplot as plt import ast filename =…
npross
  • 1,756
  • 6
  • 19
  • 38
1
vote
1 answer

Converting Strings to Floats in Pandas Series

I would like to plot "MJD" vs. "MJD_DUPLICATE" with the (13MB) dataset DR14Q_pruned_repeats.csv" found here:: https://www.dropbox.com/s/1dyong27bre3p9j/DR14Q_pruned_repeats.csv?dl=0 Here is my code: import numpy as np import pandas as pd import…
npross
  • 1,756
  • 6
  • 19
  • 38
1
vote
2 answers

Converting Pandas Series Strings to Float

I have a dataFrame, df, with one of the columns:: print(df['MJD_DUPLICATE']) 0 (0, 56238, -1, -1, -1, -1, -1, -1, -1, -1, -1,... 1 (-1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1... 2 (0, 56269, -1, -1, -1, -1, -1, -1, -1,…
npross
  • 1,756
  • 6
  • 19
  • 38
1
vote
2 answers

Selecting Column from pandas Series

I have a Series named 'graph' in pandas that looks like this: Wavelength 450 37 455 31 460 0 465 0 470 0 475 0 480 418 485 1103 490 1236 495 894 500 530 505 85 510 0 515 168 520 …
Sarah Allen
  • 73
  • 3
  • 7
1
vote
1 answer

Comparing string entries in two Pandas series

I have two panda series, and would simply like to compare their string values, and returning the strings (and maybe indices too) of the values they have in common e.g. Hannah, Frank and Ernie in the example below:: print(x) print(y) 0 Anne 1…
npross
  • 1,756
  • 6
  • 19
  • 38
1
vote
1 answer

livecharts multiple series casting error

I've got some problems using LiveCharts. I'm going to add realtime data to a serie collection. This is my Xaml:
nesar77
  • 11
  • 1
1
vote
2 answers

Turning column values into Integer columns - Pandas

Given a series of unknown size inner list: import pandas as pd sr = pd.Series([['a', 'b', 'c', 'b'], ['a', 'a', 'd'], ['b']]) [out]: 0 [a, b, c, b] 1 [a, a, d] 2 [b] The goal is to use values in the inner list to create the…
alvas
  • 115,346
  • 109
  • 446
  • 738
1
vote
3 answers

Split a list of unknown size lists into a dataframe with n no. of columns

Given a list of list with unknown size of the inner list, e.g.: >>> import pandas as pd >>> lol = [[1,2,3], [3,1,1], [3,2], [1], [2,3,4]] >>> sr = pd.Series(lol) >>> sr 0 [1, 2, 3] 1 [3, 1, 1] 2 [3, 2] 3 [1] 4 [2, 3,…
alvas
  • 115,346
  • 109
  • 446
  • 738
1
vote
1 answer

Why this use of apply of dataframe is wrong?

I don't know why this operation is wrong: songs_genres = np.array(data['genre_ids'].apply(lambda x: int(v) for v in str(x).split('|'))) Here's is the log: Traceback (most recent call last): File "FeatureEngineering.py", line 66, in …
Zoe Green
  • 23
  • 2
1
vote
3 answers

Inverse of `split` function: `join` a string using a delimeter

IN Red and Rebol(3), you can use the split function to split a string into a list of items: >> items: split {1, 2, 3, 4} {,} == ["1" " 2" " 3" " 4"] What is the corresponding inverse function to join a list of items into a string? It should work…
Geeky I
  • 751
  • 6
  • 22
1
vote
1 answer

check if values are greater than zero in series pandas

I have a series values and I want to print 'Bigger' for each value bigger than zero if(ser > 0) print 'Bigger' python gives me the error: ValueError: The truth value of a Series is ambiguous. Use a.empty, a.bool(), a.item(), a.any() or…
Tarik Ziyad
  • 115
  • 1
  • 10
1
vote
1 answer

Is there a closed form available for the following table?

Below is a table which has a recursive relation as current cell value is the sum of the upper and left cell. I want to find the odd positions for any given row denoted by v(x) as represented in the first column. Currently, I am maintaining two one…
user3243499
  • 2,953
  • 6
  • 33
  • 75
1
vote
1 answer

pandas gets the most dominant value in the column

I am trying to get the most dominant/the most frequent value of a column, so I tried the following code, df['currency'].value_counts(normalize=True) which gives me, e.g. USD 0.800000 CAD 0.100000 EUR 0.050000 GBP 0.050000 now the edge…
daiyue
  • 7,196
  • 25
  • 82
  • 149
1 2 3
…
99
100