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
49. How to INSERT IF NOT EXISTS 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