pandas
pandas is an open source, BSD-licensed library providing high-performance, easy-to-use data structures and data analysis tools for the Python programming language.
https://pandas.pydata.org/
Tutorials
NCAR Pandas tutorial
Metpy Mondays
`#57 - Pandas CSV and Mapping : Unidata Developer's Blog
https://www.unidata.ucar.edu/blogs/developer/en/entry/metpy-mondays-57-pandas-csv
CSV & text files
read_csv
Cartopy
Metpy.plots USCONTIES
https://unidata.github.io/MetPy/latest/examples/plots/US_Counties.html
NOAA/NWS Storm Prediction Center
https://www.spc.noaa.gov/
`#91 - Temperature Calculations and Pandas
#metpy , unit conversion, apparent temperature, wind chill
https://www.unidata.ucar.edu/blogs/developer/entry/metpy-mondays-91-temperature-calculations
`#93 - Pandas and Datetime Indexes
https://www.unidata.ucar.edu/blogs/developer/entry/metpy-monday-s-93-pandas
`#94 - Pandas Column Cleanup
https://www.unidata.ucar.edu/blogs/developer/entry/metpy-mondays-94-pandas-column
`#96 - Pandas Multi-Index Dataframes
https://www.unidata.ucar.edu/blogs/developer/entry/metpy-mondays-96-pandas-multi
`#97 - Pandas Concatenation
https://www.unidata.ucar.edu/blogs/developer/entry/metpy-mondays-97-pandas-concatenation
`#98 - Pandas Merge/Join
https://www.unidata.ucar.edu/blogs/developer/entry/metpy-mondays-98-pandas-merge
`#99 - Pandas Replace and Groupby
https://www.unidata.ucar.edu/blogs/developer/entry/metpy-mondays-99-pandas-replace
`#169 - Saving Space with Pandas - The One Keyword Argument you are Missing : Unidata Developer's Blog
https://www.unidata.ucar.edu/blogs/developer/entry/metpy-mondays-169-saving-space
`#181 - Using Apply to Speed Up Pandas DataFrame Operations
https://www.unidata.ucar.edu/blogs/developer/entry/metpy-mondays-181-using-apply
hail
code:python
def function(row):
var=row"column"
... = var ....
df"new"=df.apply(function,axis=1)
Tips
Get temperature array from csv of lon, lat, temp
code:python
table=pd.pivot_table(output, values='temp', index='lat', columns='lon')
temp_array=table.values
Everything You Need to Know About “loc” and “iloc” of Pandas | by Soner Yıldırım | Towards Data Science
https://towardsdatascience.com/everything-you-need-to-know-about-loc-and-iloc-of-pandas-79b386cac776
Pandas (Python): Use of .loc and .iloc | by Maurizio Sluijmers | Jun, 2020 | Level Up Coding
https://levelup.gitconnected.com/pandas-python-use-of-loc-and-iloc-ce4390930a0f
Don’t use Apply in Python, there are better alternatives! | by Anmol Tomar | Jul, 2022 | Towards Data Science
swifter
Benchmarking pandas against Polars from a pandas point of view | by Patrick Hoefler | Jun, 2023 | Level Up Coding
Polars
missing data
MetPy Mondays
MetPy Mondays #308 - How to Deal with Missing Data Part 1 - QC : Unidata Developer's Blog
Missing data can throw off everything from your calculations crashing to feeding you incorrect results to interpret. The week we start a short series on ways to deal with missing data in Python.
#Seaborn #QC
MetPy Mondays #309 - How to Deal with Missing Data Part 2 - Using NaN and NA : Unidata Developer's Blog
What's the difference between np.nan and pd.NA? When do we use them? Find out in this week's MetPy Monday!
MetPy Mondays #310 - How to Deal with Missing Data Part 3 - Filling and Interpolating : Unidata Developer's Blog
How can you use filling and interpolation to deal with missing data? Find out in this week's MetPy Monday!
#collections.Counter
#interpolation
Subpages
pandas timeseries
pandas IO tools
Related Libraries
GeoPandas
xarray
bamboolib a GUI for pandas
swifter