<commit_before># smart-meter
To demonstrate a Smart Meter Big Data Application.

![SmartMeter.png](SmartMeter.png "SmartMeter Architecture")

## Excel

### Install the ODBC Driver

* Get the Driver from http://www.simba.com/drivers/cassandra-odbc-jdbc/
* Follow the Installation Instructions (on MacOS, don't forget first to instal [iODBC](http://www.iodbc.org/))
* Save the Licence file you recieved by Mail (`SimbaApacheCassandraODBCDriver.lic`) into the right location

### Create a SDN File

* Define a SDN file, as `excel/cassandra.sdn`<commit_msg>[ci skip] Connect to the External Data from Excel<commit_after># smart-meter
To demonstrate a Smart Meter Big Data Application.

![SmartMeter.png](SmartMeter.png "SmartMeter Architecture")

## Excel

### Install the ODBC Driver

* Get the Driver from http://www.simba.com/drivers/cassandra-odbc-jdbc/
* Follow the Installation Instructions (on MacOS, don't forget first to instal [iODBC](http://www.iodbc.org/))
* Save the Licence file you recieved by Mail (`SimbaApacheCassandraODBCDriver.lic`) into the right location

### Create a SDN File

* Define a SDN file, as `excel/cassandra.sdn`
* You could load & test it directly through the iODBC Administrator App:
![excel/iODBC_test_sdn_file.png](iODBC_test_sdn_file.png)

### Connect to the External Data from Excel using the `iODBC Data Source Chooser` (File DSN)

* You might use the SQL syntax, such as `select * from raw_voltage_data limit 10;`
{'fraction_non_alphanumeric': 0.1019986216402481, 'fraction_numerical': 0.0013783597518952446, 'mean_word_length': 5.024896265560166, 'pattern_counts': {'":': 0, '<': 3, '<?xml version=': 0, '>': 3, 'https://': 0, 'lorem ipsum': 0, 'www.': 4, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '36414', 'n_tokens_mistral': 494, 'n_tokens_neox': 464, 'n_words': 163}