pandas_series
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revision | |||
pandas_series [2024/02/06 05:11] – raju | pandas_series [2024/02/06 05:18] (current) – [return a random element] raju | ||
---|---|---|---|
Line 107: | Line 107: | ||
Ref:- | Ref:- | ||
* https:// | * https:// | ||
+ | |||
+ | ==== expand a series ==== | ||
+ | tags | using reindex, change index | ||
+ | |||
+ | Given two series S, I of length n, and an integer N which is >= n, the idea here is to expand S into an N-element vector, E so that E[I[:]] = S[:]. | ||
+ | |||
+ | For example if S is [3.4, 1.8], I is [3, 5] and N is 10, we want E to be [0, 0, 0, 3.4, 0, 1.8, 0, 0, 0, 0] | ||
+ | |||
+ | < | ||
+ | import pandas as pd | ||
+ | import numpy as np | ||
+ | |||
+ | def expand_series(S, | ||
+ | E = pd.Series(S.values, | ||
+ | return E | ||
+ | </ | ||
+ | |||
+ | < | ||
+ | df = pd.DataFrame({' | ||
+ | print(df) | ||
+ | </ | ||
+ | |||
+ | < | ||
+ | | ||
+ | 0 | ||
+ | 1 | ||
+ | </ | ||
+ | |||
+ | < | ||
+ | unravelled_series = expand_series(df[' | ||
+ | print(unravelled_series) | ||
+ | </ | ||
+ | |||
+ | < | ||
+ | id | ||
+ | 0 0.0 | ||
+ | 1 0.0 | ||
+ | 2 0.0 | ||
+ | 3 3.4 | ||
+ | 4 0.0 | ||
+ | 5 1.8 | ||
+ | 6 0.0 | ||
+ | 7 0.0 | ||
+ | 8 0.0 | ||
+ | 9 0.0 | ||
+ | Name: val, dtype: float64 | ||
+ | </ | ||
+ | |||
+ | Sample code: https:// | ||
+ | |||
+ | Ref: | ||
+ | |||
+ | * https:// | ||
+ | * https:// | ||
+ | * https:// | ||
+ | |||
+ | ==== Convert series to a dataframe ==== | ||
+ | |||
+ | Use to_frame(). By default, it will use the series name to set the column name in the dataframe. But you can also assign one while calling the to_frame function. | ||
+ | |||
+ | < | ||
+ | >>> | ||
+ | >>> | ||
+ | >>> | ||
+ | s sun | ||
+ | m mon | ||
+ | t tue | ||
+ | dtype: object | ||
+ | >>> | ||
+ | 0 | ||
+ | s sun | ||
+ | m mon | ||
+ | t tue | ||
+ | >>> | ||
+ | >>> | ||
+ | s sun | ||
+ | m mon | ||
+ | t tue | ||
+ | Name: day, dtype: object | ||
+ | >>> | ||
+ | day | ||
+ | s sun | ||
+ | m mon | ||
+ | t tue | ||
+ | >>> | ||
+ | days | ||
+ | s sun | ||
+ | m mon | ||
+ | t tue | ||
+ | </ | ||
===== check if ===== | ===== check if ===== | ||
==== check if a series is empty ==== | ==== check if a series is empty ==== |
pandas_series.txt · Last modified: 2024/02/06 05:18 by raju