Code Snippets

Python

pandas DataFrames
  • Getting relevent libraries for data analysis
  • Importing and exporting CSV to a pandas DataFrame
  • Column manipulation (listing, adding, deleting, renaming, reordering)
  • Selecting rows in a DataFrame based on values
  • Selecting rows in a DataFrame based on values in a column
  • Adding a new column in a pandas DataFrame
  • Adding a row to the end of a pandas Dataframe
  • Creating a new DataFrame based on another DataFrame
  • Dropping NaN rows or changing NaN to a different value (e.g. 0)
  • Counting the number of rows in a DataFrame
  • Creating a pivot table with a pandas DataFrame
  • Aggregating column values within a pandas DataFrame
  • Grouping value in a pandas DataFrame
  • Writing a pandas DataFrame to a CSV file
  • Deleting a row within a DataFrame based on a column
  • Merging (or joining) 2 DataFrames
  • Resetting DataFrame index
Other Python
  • Running a script from local in iPython notebook

Javascript

  • coming soon...

HTML/CSS

  • coming soon...

SQL

  • coming soon...


Writing

  • coming soon...


Projects

  • coming soon...