Problem Formulation While working on large datasets, we might have to find the unique values from various columns. For example, let’s say, we have a dataframe object as shown below: And we want to find the unique elements from Col1 and Col2. That is, we want to return the following values: Solution Overview To solve … Read more
Annual Income The average annual income of a Cassandra Developer is between $110,000 and $145,500 according to Glassdoor (source): Hourly Rate If you decide to go the route as a freelance Cassandra Developer, you can expect to make between $30 and $70 per hour on Upwork (source). Assuming an annual workload of 2000 hours, you … Read more
Annual Income The average annual income of a MySQL Developer is between $87,828 and $149,975 according to Glassdoor (source): A more conservative range would be to reach an annual income between $70,000 and $139,000 within 2-4 years of education as a MySQL professional. Hourly Rate If you decide to go the route as a freelance … Read more
This article focuses on the serialization and conversion methods of a Python DataFrame: to_markdown(), to_stata(), to_hdf(), to_latex(), to_xml(). Let’s get started! Preparation Before any data manipulation can occur, four (4) new libraries will require installation. The Pandas library enables access to/from a DataFrame. The Tabulate library enables formatted output. The Tables library allows formatted output … Read more
Annual Income The average annual income of a Microsoft SQL Server Developer is between $74,000 and $137,500 according to Ziprecruiter (source): Hourly Rate If you decide to go the route as a freelance Microsoft SQL Server Developer, you can expect to make between $20 and $60 per hour on Upwork (source). Assuming an annual workload … Read more
Learn to Change Column Type in Pandas in this tutorial.
This article focuses on the serialization and conversion methods of a Python DataFrame: to_clipboard(), to_html(), to_sql(), to_csv(), and to_excel() Let’s get started! Preparation Before any data manipulation can occur, two (2) new libraries will require installation. The Pandas library enables access to/from a DataFrame. The Openpyxl library enables conversion to/from Excel. To install these libraries, … Read more
Annual Income The average annual income of a SQLite Developer is between $49,000 and $107,000 with an average of $64,977 per year according to PayScale (source). Hourly Rate If you decide to go the route as a freelance SQLite Developer, you can expect to make $25 per hour on Upwork (source). Assuming an annual workload … Read more
Learn how to delete column values in Pandas.
Annual Income The average annual income of a MariaDB Developer is $85,000 according to Payscale (source). Hourly Rate If you decide to go the route as a freelance MariaDB Developer, you can expect to make between $20 and $99 per hour on Upwork (source). Assuming an annual workload of 2000 hours, you can expect to … Read more
Annual Income As a DynamoDB Developer, you can expect to earn between $70,000 and $160,000 per year according to Google (source). Hourly Rate If you decide to go the route as a freelance DynamoDB Developer, you can expect to make between $22 and $49 per hour on Upwork (source). Assuming these hourly rates and an … Read more
This article focuses on the serialization and conversion methods of a Python DataFrame: from_dict(), to_dict(), from_records(), to_records(), to_json(), and to_pickles(). Let’s get started! Preparation Before any data manipulation can occur, two (2) new libraries will require installation. The Pandas library enables access to/from a DataFrame. The NumPy library supports multi-dimensional arrays and matrices in addition … Read more