A compendium of useful, interesting, inspirational usage of pandas functions, each example will be an ipynb file
[]
A compendium of useful, interesting, inspirational usage of pandas functions, each example will be an ipynb file
 Pandas_by_examples
A compendium of useful/interesting/inspirational usage of pandas functions, each example will be an ipynb file
## What is this repository?
When you browse through Stackoverflow or reading blogs on Toward Data Science, have you ever encountered some super elegant solutions (maybe just one line) that can replace your dozens of lines codes (for loop, functions)?
This repository aims to store these impressive solutions in pandas and the associated examples. Each real-world task will be presented as a jupyter files to make it easy to follow step by step.
If we want to know more about the motivation, Read the blog I published on Toward Data Science: https://towardsdatascience.com/learning-pandas-by-examples-8105771c723c
## Contribution
Please feel free to create pull request for these kinds of pandas usages that occur in your daily coding. 
## Index
1. [Index and MultiIndex](https://github.com/frankligy/pandas_by_examples/blob/main/examples/1_index_multiindex.ipynb)
2. [Series, Categorical and dtype](https://github.com/frankligy/pandas_by_examples/blob/main/examples/2_series_category_dtype.ipynb)
3. [Various Reshaping Operations](https://github.com/frankligy/pandas_by_examples/blob/main/examples/3_reshaping.ipynb)
4. [Squeeze function](https://github.com/frankligy/pandas_by_examples/blob/main/examples/4_squeeze.ipynb)
5. [combine two columns to a dictionary](https://github.com/frankligy/pandas_by_examples/blob/main/examples/5_columns2dict.ipynb)
6. [Read R format data](https://github.com/frankligy/pandas_by_examples/blob/main/examples/6_read_R_data.ipynb)
7. [Using bracket when subset with multiple condition](https://github.com/frankligy/pandas_by_examples/blob/main/examples/7_multiple_condition.ipynb)
8. [Chain Indexing](https://github.com/frankligy/pandas_by_examples/blob/main/examples/8_chain_index.ipynb)
9. [How to extract (index,column) pairs based on value?](https://github.com/frankligy/pandas_by_examples/blob/main/examples/9_index_column_pair.ipynb)
10. [Extremely large dataframe](https://github.com/frankligy/pandas_by_examples/blob/main/examples/10_larger_file.ipynb)
11. [AnnData: Annotated DataFrame](https://github.com/frankligy/pandas_by_examples/blob/main/examples/11_anndata.ipynb)
12. [How to order dataframe based on custom order](https://github.com/frankligy/pandas_by_examples/blob/main/examples/12_custom_order.ipynb)
13. stay tuned