Mehvish Ashiq

2. Author
3. Mehvish Ashiq

Python Pandas Howtos

1. Introduction to Pandas Family Tree
2. Pandas Anti-Join
3. Use of rolling().apply() on Pandas Dataframe and Series
4. Reshape Pandas DataFrame From Wide to Long
5. Scrape HTML Tables Into a Data Frame Using BeautifulSoup
6. Apply Square Root Function on a Column of Pandas Data Frame
7. Convert DataFrame Column to Datetime in Pandas
8. Introduction to Useful Rolling Functions for GroupBy Object in Pandas
9. Split a Pandas DataFrame Column by a Delimiter
10. Use Multiprocessing on a Pandas DataFrame

Python How-To's

1. Python Global Logger
2. Python Logging Propagate
3. Structural Pattern Matching in Python
4. Fama-Macbeth Regression in Python
5. Insert Data Into an SQLite Database Using Python
6. Python Audio Synthesis
7. Append Data to a JSON File Using Python
8. Mock Patch One Function Invoked by Another Function in Python

Java Howtos

1. Capture and Analyze Java Heap Dump
2. Introduction to Integration Testing in Java
3. Limit Java SSL Debug Logging
4. Define a Static Method in Java Interface
5. Get Current Timestamp in ISO 8601 Format
6. Convert InputStream to the File Object in Java
7. Use OpenJDK to Install Java in Ubuntu
8. Introduction to Interceptors in Java EE
9. Fix Java.IO.NotSerializableException in Java
10. Fix the Error Occurred During Initialization of VM in Minecraft
11. Resolve the Public Keys in Reply and Keystore Don't Match Error in Java
12. There Is Insufficient Memory for the Java Runtime Environment to Continue in Eclipse
13. Resolve the Package Does Not Exist Error in Java
14. Fix Android Java.Lang.IllegalStateException: Could Not Execute Method of the Activity
15. Fix JAVA_HOME Cannot Be Determined From the Registry Error in R
16. Fix Java.Net.SocketException: Broken Pipe Error in Java
17. Fix the Java.Lang.ClassNotFoundException: Org.Springframework.Web.Context.ContextLoaderListener Error in Java
18. Fix No JVM Could Be Found on Your System Define EXE4J_JAVA_HOME Error in Java
19. Fix the Unable to Install Java There Are Errors in the Following Switches
20. Fix Class X Is Public Should Be Declared in a File Named X.java Error
21. Resolve Generic Array Creation Error in Java
22. Resolve Java.Lang.RuntimeException: Unable to Instantiate Activity ComponentInfo
23. Resolve Unreported Exception IOException Must Be Caught or Declared to Be Thrown in Java
24. Fix Class Names Are Only Accepted if Annotation Processing Is Explicitly Requested in Java
25. Fix Comparison Method Violates Its General Contract Error in Java
26. Fix Java.Lang.NoClassDefFoundError: Could Not Initialize Class Error
27. Java.Security.InvalidKeyException: Illegal Key Size
28. Resolve Missing Method Body or Declare Abstract in Java
29. Fix the Error: Else Without if in Java
30. Fix java.io.IOException: No Space Left on Device in Java
31. Fix Could Not Open jvm.cfg in Java
32. Fix the java.io.IOException: Stream Closed Error
33. Solution for Java Lang Index Out of Bounds Exception
34. Fix the Warning: Uses or Overrides a Deprecated API in Java
35. Java Remote Debugging
36. Java.Net.SocketException: Network Is Unreachable
37. Java Tail Call Optimization
38. Difference Between Repository Pattern and DAO in Java
39. Solution to the JavaFX FXML Load Exception
40. Create JavaFX Message Box
41. JavaFX Media Player
42. Create Canvas Using Java Swing
43. Use Java FFMPEG to Convert Files From One Format to Another
44. Dynamic Method Dispatch in Java
45. Execution of Java Constructors in Inheritance
46. Java Jagged Array
47. Pascal's Triangle in Java
48. Compare Arrays in Java
49. Move File From Current Directory to a New Directory in Java
50. Exception Types and Their Handling in Java
51. Java Bitwise Operators
52. Java Singleton Class
53. The abs() Method in Java
54. The sqrt() Method in Java
55. Method Overloading in Java
56. Introduction to HashMap in Java
57. Create Java Progress Bar Using JProgressBar Class
58. Find Java Virtual Machine DLL
59. Java Multiline Strings
60. Format Specifiers for Floating-Point Numbers in Java
61. Introduction to Java NIO Package
62. Difference Between void and Void in Java
63. Write Native Methods in Java
64. Draw a Hexagon in Java
65. The setBounds() Method and Its Uses in Java
66. Create PPTP Connection in Java
67. Format Specifiers for Integral Numbers in Java

MongoDB Howtos

1. Use Hibernate OGM to Integrate Hibernate With MongoDB
2. Convert Timestamp Into Date in MongoDB
3. MongoDB Distinct Aggregation
4. MongoDB Project Nested Fields
5. MongoDB Remove Element From an Array
6. Bulk Update of Documents in MongoDB Using Java
7. Use forEach() to Update an Array Field in MongoDB Shell
8. MongoDB Aggregate Match in an Array
9. Show Indexes in MongoDB
10. MongoDB Maximum Document Size
11. MongoDB Print JSON Without Whitespaces
12. Use of $Match (Aggregation) Stage in MongoDB
13. Use Pipeline in Lookup Operator in MongoDB
14. Get the Last N Records in MongoDB
15. Install and Use Elasticsearch With MongoDB on Windows and Ubuntu
16. MongoDB Aggregate Sort
17. Repair MongoDB Database
18. The NOT IN Comparison Operator in MongoDB
19. Fuzzy Search in MongoDB
20. Combine Two Collections Into One Collection Using MongoDB
21. Copy a Collection Within the Same Database in MongoDB
22. Get the Size of a Database in MongoDB
23. Join Multiple Conditions Using the Lookup Operator in MongoDB
24. Print Document Values Using MongoDB Shell

MySQL Howtos

1. Connect a Remote MySQL Database Using the Command Line
2. Generate Random and Unique Strings in MySQL
3. Use Mysqldump Gzip to Create a Compressed File for a MySQL Database
4. Enable Slow Query Log in MySQL
5. Optimize Tables and Databases in MySQL
6. Append Strings to an Existing Field in MySQL
7. Use, Benefits, and Alternative of the Zerofill in MySQL
8. Convert From Datetime Type to Date Only in MySQL
9. Insert Into Multiple Tables in MySQL
10. Insert Timestamp Into a MySQL Table
11. Reset the MySQL Root Password in Ubuntu
12. Select the First Row From the MySQL Table
13. Add the Primary Key to a MySQL Table
14. Group the Datetime Column by Date Only in MySQL
15. Show Table and Database Structure in MySQL
16. Turn Off Foreign Key Constraint in MySQL
17. Calculate Percentage in MySQL
18. Create a Function in MySQL
19. Get the ID of the Latest Inserted Record in MySQL
20. MySQL ForEach Loop
21. MySQL Money Data Type
22. Update Multiple Columns in Multiple Rows With Different Values in MySQL
23. Change the Connection Timeout in MySQL
24. Change the max_allowed_packet Size in the MySQL Server
25. Compare MySQL Timestamp Dates With the Date Parameter Only
26. Get the Current Date and Time in MySQL
27. Cast to Decimal in MySQL
28. List All Stored Procedures in MySQL
29. Loop Through All Rows of a MySQL Table
30. Show the Current Database in MySQL
31. The Equivalent of Oracle's decode Function in MySQL
32. Fix Data Is Truncated for a Column Error in MySQL
33. Get Command History in MySQL
34. Show Indexes for Table or Database in MySQL
35. Use the Date_ADD() Function to Add Days and Time in MySQL
36. Copy Table Structures Without Copying Data in MySQL
37. Update Primary Key in MySQL Tables
38. Different Ways to Connect a Remote MySQL Server Using Ubuntu
39. Use Mysqldump to Backup Data in MySQL
40. Skip Grant Tables in MySQL
41. Copy Rows in the MySQL Database
42. Waiting for Table Metadata Lock
43. Different Ways to Check if a Row Exists in the MySQL Table
44. Introduction to the MySQL Composite Key
45. Use the ORDER BY Clause With Multiple Columns in MySQL
46. Where vs Having in MySQL
47. Convert String to Date Format in MySQL
48. Escape Sequences in MySQL
49. Intersect Operator in MySQL
50. Delete All Rows in MySQL Database Using phpMyAdmin
51. Export MySQL Database Using Mysqldump
52. Import Excel File Into a MySQL Database
53. Select Top N Rows in MySQL
54. Search Rows to Find Substrings in MySQL
55. Unblock With Mysqladmin Flush Hosts in MySQL
56. Event Scheduler or Set a Timer in MySQL
57. Difference Between Schema and Database in MySQL
58. Display Errors Using MySQLi Error Functions
59. MUL vs PRI vs UNI in MySQL
60. Search Occurrences of String in MySQL Database
61. Copy Data From One Database to Another in MySQL
62. DATETIME vs TIMESTAMP in MySQL
63. Different Ways to Stop Mysqld
64. Loop PHP MySQLi Fetch Array Function
65. Minus Operation in MySQL
66. Create New Database in MySQL Workbench
67. MySQL Comments
68. MySQL With Clause
69. Use of Row_Number() Function in MySQL

C Howtos

1. Compile a C File on Mac
2. Release the Allocated Memory for Nodes in the Linked List in C
3. Stack Smashing Detected Error in C
4. The Volatile Qualifier in C
5. Use the mmap Function to Write to the Memory in C
6. Difference Between Struct and Typedef Struct in C
7. Use Boolean Values in C
8. Use of extern C in C++

JavaScript Howtos

1. Convert Array to Set in JavaScript
2. Create Keyboard Shortcuts Using JavaScript
3. Get Height and Width of the Element in JavaScript
4. Load an External HTML File Using JavaScript
5. Convert Blob to File Using JavaScript
6. Detect Browser or Tab Closing Event in JavaScript
7. Prepend Elements in JavaScript
8. Get an Apostrophe in a String Using JavaScript
9. Select a Random Element From an Array in JavaScript
10. Change Label Text Using JavaScript
11. Repeat a String Using JavaScript
12. Cancel Events in JavaScript
13. Create Table Dynamically in JavaScript
14. Dynamic Array in JavaScript
15. Filter Array Multiple Values in JavaScript
16. Get Child Element by Class in JavaScript
17. Noop Function in JavaScript
18. Push Key-Value Pair Into an Array Using JavaScript
19. Call API in JavaScript
20. Global and Private Functions in JavaScript
21. Introduction to JavaScript Profiler
22. JavaScript Memory Leak Detection
23. JavaScript Valid Variable Names
24. JavaScript Z Index
25. Detecting a Finger Swipe Events in JavaScript
26. Remove Non Alphanumeric Characters Using JavaScript
27. Replicate Python Stripe Method in JavaScript
28. SHA-256 Implementation in JavaScript
29. Multiple Variable Assignment in JavaScript
30. Replace a String in JavaScript
31. Call C# Function From JavaScript
32. Generate Random Boolean in JavaScript
33. JavaScript Dynamic Variable Name
34. JavaScript Event Listener List
35. JavaScript Lexical Scope
36. JavaScript Set Session Variable
37. JavaScript Split String Into Array by Comma
38. Polymorphism in JavaScript
39. Print the Content of a Div Element in JavaScript
40. Run JavaScript in Visual Studio Code
41. JavaScript Map vs Object
42. JavaScript Remove Special Characters
43. Move Element Position in JavaScript
44. Reset Form in JavaScript
45. Enter Key Event in JavaScript
46. Get Attributes of HTML Element Using JavaScript
47. JavaScript Array Intersection
48. JavaScript Replace With Regex
49. JavaScript Serialize Form
50. JavaScript String startsWith
51. Remove All Child Elements Using JavaScript
52. Use of HTML Script Type Attribute
53. JavaScript Array of Images
54. Add ID to Element Using JavaScript
55. JavaScript Function Overloading
56. JavaScript Print Array Elements
57. Pass Array to a Function in JavaScript
58. JavaScript Get Textbox Value
59. JavaScript Call Function From Another JS File
60. JavaScript for...in VS for...of Loop
61. JavaScript Associative Array and Hash Table
62. JavaScript Change Button Text
63. JavaScript Default Function Parameters
64. Open Local Text File Using JavaScript
65. Display Text When Checkbox Is Checked in JavaScript
66. JavaScript Count Up Timer
67. Scroll Automatically to the Bottom of the Page in JavaScript