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 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 No Space Left on Device in Java
  31. Fix Could Not Open jvm.cfg in Java
  32. Fix the 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
  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 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
Mehvish Ashiq avatar Mehvish Ashiq avatar

Mehvish Ashiq is a former Java Programmer and a Data Science enthusiast who leverages her expertise to help others to learn and grow by creating interesting, useful, and reader-friendly content in Computer Programming, Data Science, and Technology.

LinkedIn GitHub Facebook