Pandas Series: Difference between revisions

From NovaOrdis Knowledge Base
Jump to navigation Jump to search
Line 27: Line 27:
A series can also be created from data stored externally.  
A series can also be created from data stored externally.  


==Create a Series from CSV==
<font color='darkkhaki'>
<font color='darkkhaki'>
https://pandas.pydata.org/docs/reference/api/pandas.read_csv.html#pandas.read_csv
To create a series from a CSV file:
To create a series from a CSV file:
<syntaxhighlight lang='py'>
<syntaxhighlight lang='py'>
Line 35: Line 38:
</syntaxhighlight>
</syntaxhighlight>
</font>
</font>
==Create a Series from JSON==
<font color='darkkhaki'>Parse: https://pandas.pydata.org/docs/reference/api/pandas.read_json.html#pandas.read_json</font>


=Accessing Elements of a Series=
=Accessing Elements of a Series=

Revision as of 17:39, 8 October 2023

External

Internal

Overview

A series is a one-dimensional array of values, where each value has a label. The labels are referred to as "axis labels" and they are managed by the series's index. By default, in absence of any explicit specification, a series gets a monotonic integer range index, starting with 0 and with the step 1, allowing retrieving data with 0-based integer indexes (see Accessing Elements of a Series below).

Data stored in series can be

Index

https://pandas.pydata.org/docs/reference/api/pandas.Series.index.html
https://pandas.pydata.org/docs/reference/indexing.html

RangeIndex

RangeIndex(start=0, stop=3, step=1)

Create a Series

A series can be created from an in-memory list:

import pandas as pd

a = ['a', 'b', 'c']
s = pd.Series(a)

A series can also be created from data stored externally.

Create a Series from CSV

https://pandas.pydata.org/docs/reference/api/pandas.read_csv.html#pandas.read_csv

To create a series from a CSV file:

import pandas as pd

# TODO

Create a Series from JSON

Parse: https://pandas.pydata.org/docs/reference/api/pandas.read_json.html#pandas.read_json

Accessing Elements of a Series

This is known as indexing or subset selection.

Operations on Series

Filtering

Transformation

This class of operations are referred to as transformations or conversions.

Binary Operations