Preet Sanghavi avatar Preet Sanghavi avatar

About Preet Sanghavi

LinkedIn GitHub

Preet writes his thoughts about programming in a simplified manner to help others learn better. With thorough research, his articles offer descriptive and easy to understand solutions.

Articles by Preet Sanghavi

Python How-To's

  1. F-Test in Python
  2. How to Import Multiple CSV Files Into Pandas and Concatenate Into One DataFrame
  3. The Short Circuit Evaluation in Python
  4. How to Print Degree Symbol in Python
  5. How to Send Function in Python Generators
  6. How to Sort Counter Based on Values in Python
  7. How to Fix TypeError: List Indices Must Be Integers, Not STR in Python
  8. How to Solve ModuleNotFoundError: No Module Named '_Ctypes' in Python
  9. Urllib2 in Python 3
  10. How to Fix Name xrange Is Not Defined Error in Python
  11. How to Install SQLite in Visual Studio 2022
  12. How to Fix Sqlite3.OperationalError: Unable to Open Database File
  13. How to Show Tables in SQLite
  14. How to Unlock the SQLite Database
  15. How to Perform Image Segmentation in Python
  16. How to Perform Logistic Regression in Python
  17. How to Create Turtle Shapes in Python
  18. How to Perform Chi-Square Test in Python
  19. How to Check if String Matches Regex in Python
  20. How to Convert Set to String in Python
  21. How to Create Word Cloud in Python
  22. How to Import OpenSSL in Python
  23. How to Replace Newline With Space in Python
  24. How to Solve Quadratic Equations in Python
  25. How to Split Strings by Tab in Python
  26. How to Write List to CSV Columns in Python

MySQL Howtos

  1. How to Convert Rows to Columns in MySQL
  2. How to Format Numbers in MySQL
  3. How to Find Tables in MySQL With Specific Column Names in Them
  4. How to Use PHP MySQLi Function to Fetch Last Inserted ID
  5. MySQL Stored Procedure With Parameters
  6. How to Calculate Average of a Table Column in MySQL
  7. How to Check MySQL Version in macOS
  8. How to Find Value in a Set in MySQL Database
  9. How to Show Foreign Keys in MySQL
  10. How to Sort MySQL Data in Alphabetical Order
  11. Port Number in MySQL
  12. Transaction Log in MySQL
  13. How to Export Database in MySQL From the Command Line
  14. Multiple Primary Keys in MySQL
  15. Safe Mode in MySQL
  16. Tiny Integer in MySQL
  17. Greater Than Date in MySQL
  18. How to Adding a Column in MySQL
  19. Isnumeric in MySQL
  20. How to Create Table From CSV in MySQL
  21. How to Use Not Exists in MySQL
  22. The Rank Function in MySQL
  23. How to Select All Tables in MySQL
  24. Unsigned in MySQL
  25. Common Table Expressions in MySQL
  26. How to Drop Multiple Tables in MySQL
  27. How to Sort by Date in MySQL
  28. How to Fetch Random Values in MySQL
  29. How to Get Version in MySQL
  30. How to ORDER BY RAND in MySQL
  31. How to Reset Auto Increment in MySQL
  32. How to Update Table From Another Table in MySQL
  33. How to Decimal Values in MySQL
  34. How to Full Join in MySQL
  35. How to Insert Date in MySQL
  36. How to Join 3 Tables in MySQL
  37. How to Select Most Recent Record in MySQL
  38. How to Set Null in MySQL
  39. If ELSE in MySQL
  40. Substring in MySQL
  41. The For Loop in MySQL
  42. WHERE IN Statement in MySQL
  43. How to Cast as Integer in MySQL
  44. How to Escape Single Quote in MySQL
  45. Truncated Incorrect Double Value in MySQL
  46. CASE WHEN in MySQL
  47. Difference Between VARCHAR and CHAR in MySQL
  48. How to Group by Month in MySQL
  50. How to Locate the Error Log in MySQL
  51. How to Select Unique Values in MySQL
  52. How to Get Column Names in MySQL
  53. How to Kill a Process in MySQL
  54. How to Load Data INFILE in MySQL
  55. How to Replace a String in MySQL
  56. How to Round Down to the Nearest Integer in MySQL
  57. MySQL COUNT IF Method
  58. How to Get the Size of MySQL Database
  59. How to Rename a Table in MySQL
  60. How to Split String in MySQL
  61. Usage of UPDATE JOIN in MySQL
  62. Difference Between VARCHAR and TEXT in MySQL
  63. How to Copy a Table in MySQL
  64. The CASE Statement in MySQL
  65. The IF Statement in MySQL
  66. How to Group by Multiple Columns in MySQL
  67. How to Insert Bulk Values in MySQL
  68. How to Store Image in MySQL Database
  69. How to Use Boolean Data Type in MySQL
  70. How to Count Distinct Values in MySQL
  71. How to Create a Temporary Table in MySQL
  72. How to Export Data From MySQL to a CSV File
  73. How to Start MySQL Server
  74. How to Rename a Column in MySQL Database
  75. How to Run MySQL Queries From the Command Line
  76. Usage of IF EXISTS in MySQL Database
  77. How to Check if String Contains Certain Data in MySQL

Python Pandas Howtos

  1. How to Check Pandas and Various Dependencies Version
  2. How to Factorize Data Values in Pandas
  3. How to Find Quantiles in Pandas
  4. How to Fix Error - Module Pandas Has No Attribute Dataframe Error
  5. How to Get the Substring of a Column in Pandas
  6. How to GroupBy Month in Pandas
  7. How to Perform Stratified Sampling in Pandas
  8. How to Calculate Cross Join Between Two DataFrames in Pandas
  9. How to Calculate Exponential Moving Average Values in Pandas
  10. How to Calculate Rolling Correlation in Pandas
  11. How to Lookup From One of Multiple Columns Based on Value in Pandas
  12. How to Perform T-Test in Pandas
  13. How to Drop Last Row and Column in Pandas
  14. How to Append to Empty Dataframe in Pandas
  15. How to Check if Column Exists in Pandas
  16. How to Revert From MultiIndex to Single Index in Pandas
  17. Scatter Matrix in Pandas
  18. Series Plot in Pandas
  19. How to Convert Categorical Variable to Numeric in Pandas
  20. How to Drop Duplicated Column in Pandas
  21. How to Fix Key Error in Pandas
  22. How to Fix Memory Error in Pandas
  23. How to Group by and Sort in Pandas
  24. How to Append a Column in Pandas DataFrame
  25. How to Convert Timestamp to Datetime in Pandas
  26. How to Reshape a Data Frame Using stack() and unstack() Functions in Pandas
  27. GroupBy Apply in Pandas
  28. How to Mask in Pandas