SQL Common Table Expressions (CTEs) are a powerful tool for writing and organizing complex SQL queries. They are used to simplify the logic and structure of complex SQL queries, making them easier to understand and maintain. In this blog post, we will take a closer look at what SQL CTEs are, how they can be …
What is PySpark? PySpark allows Python users to interface with Apache Spark and wrangle data present in clusters over multiple nodes. PySpark provides users with Dataframes which is an abstraction of its underlying RDD (Resilient Distributed Datasets). PySpark supports most Spark features such as Spark SQL, dataframe, streaming, ML Lib and Spark Core. Install PySpark …
In many ways PySpark dataframes are similar to Pandas dataframe. However, there are some key differences as well. This is not an exhaustive list of all the actions / transformation between the two dataframes. 1. Loading & Viewing Data 2. Transformations / Filtering
OS X supports the option to read NTFS-formatted drives, but has no support for writing to these drives. Previously I used OS X Fuse to enable write functionality but it requires installing multiple 3rd party drivers. Instead we can use Apple’s NTFS write functionality which is not enabled by default. Please note the following steps will have to …
The latest driver from FTDI bricks devices which are using fake FTDI chips. It does this by simply changing the device PID to 0000. This renders the device unusable on any computer. Drivers newer than 2.10.0 have the bricking functionality in them. If you see your device showing up as “FT232R USB UART” in the …
The Arduino Pro Mini is a great microcontroller board based on the ATmega328. The board comes without built-in USB circuitry, so an off-board USB-to-TTL serial convertor must be used to upload sketches. This can be a FTDI TTL-232R USB – TTL Level Serial Converter Cable for the 5V Arduino Mini Pro), or a FTDI TTL-232R-3V3 USB …
Read more “Programming the Arduino Pro Mini using an Arduino Uno”