Last updated: 2023-09-18

Checks: 2 0

Knit directory: Pandas-30-R/

This reproducible R Markdown analysis was created with workflowr (version 1.7.0). The Checks tab describes the reproducibility checks that were applied when the results were created. The Past versions tab lists the development history.

R Markdown file: up-to-date

Great! Since the R Markdown file has been committed to the Git repository, you know the exact version of the code that produced these results.

Repository version: 616c479

Great! You are using Git for version control. Tracking code development and connecting the code version to the results is critical for reproducibility.

The results in this page were generated with repository version 616c479. See the Past versions tab to see a history of the changes made to the R Markdown and HTML files.

Note that you need to be careful to ensure that all relevant files for the analysis have been committed to Git prior to generating the results (you can use wflow_publish or wflow_git_commit). workflowr only checks the R Markdown file, but you know if there are other scripts or data files that it depends on. Below is the status of the Git repository when the results were generated: 


Ignored files:
    Ignored:    .Rhistory
    Ignored:    .Rproj.user/
    Ignored:    dev/
    Ignored:    renv/

Unstaged changes:
    Modified:   renv.lock

Note that any generated files, e.g. HTML, png, CSS, etc., are not included in this status report because it is ok for generated content to have uncommitted changes.

These are the previous versions of the repository in which changes were made to the R Markdown (analysis/index.Rmd) and HTML (docs/index.html) files. If you’ve configured a remote Git repository (see ?wflow_git_remote), click on the hyperlinks in the table below to view the files as they were in that past version.

File Version Author Date Message
Rmd 616c479 Mena WANG 2023-09-18 more on groupby, fun with lists
html 406fa10 Mena WANG 2023-09-10 Build site.
html e025247 Mena WANG 2023-09-03 Build site.
Rmd 0b23e3c Mena WANG 2023-09-03 map for creating new columns
html 7f8aaeb Mena WANG 2023-08-15 Build site.
html be1850c Mena WANG 2023-08-15 Build site.
html f5a895a Mena WANG 2023-08-13 Build site.
Rmd 7acb5aa Mena WANG 2023-08-13 working with dates
html db3e0fe Mena WANG 2023-07-22 Build site.
Rmd 588cdcb Mena WANG 2023-07-22 add replace method
html 7aa3195 Mena WANG 2023-07-22 Build site.
Rmd 13f4ba0 Mena WANG 2023-07-22 add pd.to_numeric in method8
html 0db3ba4 Mena WANG 2023-02-26 Build site.
Rmd 3dd7238 Mena WANG 2023-02-26 more example for loc and refresh index page
html e3221e5 Mena WANG 2022-12-13 Build site.
html 2522fc8 Mena WANG 2022-12-10 Build site.
Rmd e9f5625 Mena WANG 2022-12-10 add method30
html b06fbb1 Mena WANG 2022-12-02 Build site.
Rmd 5e3738a Mena WANG 2022-12-02 add method28-29
html a20b54f Mena WANG 2022-11-29 Build site.
html 5d4a24a Mena WANG 2022-11-29 Build site.
Rmd a65e3ef Mena WANG 2022-11-29 add method27
html 114c4b5 Mena WANG 2022-11-25 Build site.
Rmd c90624b Mena WANG 2022-11-25 add method25-26
html 043f5fa Mena WANG 2022-11-18 Build site.
Rmd e187d0f Mena WANG 2022-11-18 add method24
html d77b114 Mena WANG 2022-11-17 Build site.
Rmd 956d4b2 Mena WANG 2022-11-17 add method22-23
Rmd 7cd8977 Mena WANG 2022-11-17 add method21
html 7cd8977 Mena WANG 2022-11-17 add method21
html 55def40 Mena WANG 2022-11-17 Build site.
Rmd 1589837 Mena WANG 2022-11-17 add method21
html ca76451 Mena WANG 2022-11-13 Build site.
Rmd 0504fcc Mena WANG 2022-11-13 add method20
html efd27b1 Mena WANG 2022-11-12 Build site.
Rmd 521e4ee Mena WANG 2022-11-12 add method19
html 76150fe Mena WANG 2022-11-11 Build site.
Rmd 06382ee Mena WANG 2022-11-11 add method18
html 0b7b914 Mena WANG 2022-11-10 Build site.
Rmd d9c0296 Mena WANG 2022-11-10 add method 16-17
html e12fbbe Mena WANG 2022-11-09 Build site.
Rmd e194e29 Mena WANG 2022-11-09 add method15
html 2d18567 Mena WANG 2022-11-09 Build site.
html a354ca2 Mena WANG 2022-11-09 Build site.
Rmd 3956999 Mena WANG 2022-11-09 add method14
html dad691d Mena WANG 2022-11-08 Build site.
Rmd 4ce9d68 Mena WANG 2022-11-08 add method13
html bce6766 Mena WANG 2022-11-08 Build site.
Rmd e274867 Mena WANG 2022-11-08 add bonus1
html 9fd2b31 Mena WANG 2022-11-08 Build site.
Rmd 685a5b3 Mena WANG 2022-11-08 add method12
html 0632ced Mena WANG 2022-11-05 Build site.
Rmd 6a0ac9f Mena WANG 2022-11-05 add method11
html 7ce73a5 Mena WANG 2022-11-03 Build site.
Rmd 0cd6f77 Mena WANG 2022-11-03 add method10
html 97a4ecd Mena WANG 2022-11-01 Build site.
Rmd 8b96a30 Mena WANG 2022-11-01 add method9
html 99c04b8 Mena WANG 2022-11-01 Build site.
Rmd 8fabed3 Mena WANG 2022-11-01 add method8
html e8c4cec Mena WANG 2022-11-01 Build site.
Rmd 023948f Mena WANG 2022-11-01 add method7
html 3e4868b Mena WANG 2022-11-01 Build site.
Rmd 641dd5b Mena WANG 2022-11-01 add method6
html db83905 Mena WANG 2022-10-30 Build site.
Rmd 6a5b83b Mena WANG 2022-10-30 add method5
html 2be83cf Mena WANG 2022-10-25 Build site.
Rmd c0aa815 Mena WANG 2022-10-25 add method4
html 9cbf22c Mena WANG 2022-10-25 Build site.
Rmd 2c72e1a Mena WANG 2022-10-25 add method3
Rmd 546254b Mena WANG 2022-10-25 add method3
html 546254b Mena WANG 2022-10-25 add method3
html 2cb19ff Mena WANG 2022-10-23 Build site.
html a3d64fd Mena WANG 2022-10-23 Build site.
Rmd 40ac710 Mena WANG 2022-10-23 add method 2
html 229f405 Mena WANG 2022-10-23 Build site.
html c6a7835 Mena WANG 2022-10-23 Build site.
Rmd 0ac8e00 Mena WANG 2022-10-23 Add content to license and about page
html 05866b4 Mena WANG 2022-10-23 Build site.
Rmd eeb5169 Mena WANG 2022-10-23 start the project with method 1
Rmd c876a91 Mena WANG 2022-10-23 Start workflowr project.

In this repo, I provided a Python to R translation of 30 essential Pandas methods introduced by Avi Chawla in The Only 30 Methods You Should Master To Become A Pandas Pro published on TowardsDataScience.

The discussions of some of the methods went beyond the original, with more related methods illustrated/compared for more advanced or customized tasks (pls see specific methods highlighted in the list below). I will continue to add examples or relevant methods to enrich this site, as it now serves as a reference source for myself.

Hope you find it helpful too. Comments and suggestions are always appreciated. :)

Please click each method below for details

1. read_csv(): Reading a CSV

2. to_csv(): Storing a Dataframe into a CSV

3. DataFrame(): Creating a Dataframe from a Llist

4. DataFrame(): Creating a Dataframe from a Dictionary

5. shape: The Shape of the Dataframe

6. head(): Viewing Top N Rows

7. dtypes: Print the Datatype of Columns

8. astype() & pd.to_numeric(): Modifying the Datatype of a Column

9. info(): Printing Descriptive Info about the Dataframe (Method1)

10. describe(): Printing Descritive Info about the Dataframe (Method2)

11. fillna() & replace(): Filling Missing Values

12. merge & join: Joining DataFrames

13. sort_values(): Sorting a Dataframe

14. groupby(): Grouping a Dataframe

15. rename(): Renaming Columns

16-17. assign, lambda, iloc, map: Adding New Columns

18. query, filter, isin: Filtering a Dataframe1: Boolean filtering

19. filter & select_dtypes: Filtering a Dataframe2: Select columns

20. loc, map, set: Filtering a Dataframe3: Select by label

21. iloc: Filtering a Dataframe4: Select by position

22-23. unique & nunique: Finding Unique Values in a Dataframe

24. apply: Apply a Function to a Dataframe

25-26. duplicated & drop_duplicates: Handling Duplicates

27. value_counts, sidetable & tabyl: Standard and customized frequency tables

28. reset_index(drop, inplace): Resetting the index of a dataframe

29. crosstab(): Finding Cross-Tabulation

30. pivot_table & melt: Pivoting DataFrames

Bonus content 💃

The below content is not limited to pandas or tidyverse. Mainly useful stuff I learned along the way. :)

1. complete(): Expand a dataframe

2. datetime & dateutil: Working with dates in Python

3. all, any: Fun with lists