Oleksandr Zaitsev olekscode
🇺🇦
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| app = accounts["social"] | |
| auth = twitter.oauth.OAuth( | |
| app["token"], | |
| app["token_secret"], | |
| app["api_key"], | |
| app["api_secret"]) | |
| twitter_api = twitter.Twitter(auth=auth) |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| # Replaces EN with UK in the names of all *.srt files in the current working directory. | |
| # Assumes that there is only one EN in each name. | |
| # | |
| # IDEA | |
| # ------------- | |
| # For all *.srt files that have EN somewhere in their name ($x) | |
| # Store everything before EN as $prefix | |
| # Store everything after EN as $suffix | |
| # Rename each file $x with $prefix + UK + $suffix | |
| # |
olekscode
/ projects.st
Last active
May 13, 2019 14:18
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| projects := { | |
| DLProject | |
| githubUser: #moosetechnology | |
| projectName: #Moose | |
| commit: '57cb811' . | |
| DLProject | |
| githubUser: #feenkcom | |
| projectName: #gtoolkit | |
| commit: 'b465367' | |
| baseline: #GToolkit . |
olekscode
/ customers.st
Last active
August 2, 2019 14:12
Example of using joins (inner, outer, left, right) with Pharo DataFrame. Customers and orders tables come from http://www.sql-join.com/sql-join-types
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| | customers | | |
| customers := DataFrame | |
| withRows: | |
| #( ( 1 'George' 'Washington' 'gwashington@usa.gov' | |
| '3200 Mt Vernon Hwy' 'Mount Vernon' | |
| 'VA' 22121 ) | |
| ( 2 'John' 'Adams' 'jadams@usa.gov' | |
| '1250 Hancock St' 'Quincy' 'MA' 02169 ) | |
| ( 3 'Thomas' 'Jefferson' 'tjefferson@usa.gov' |
olekscode
/ load-dataframe.st
Created
August 2, 2019 14:06
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| Metacello new | |
| baseline: 'DataFrame'; | |
| repository: 'github://PolyMathOrg/DataFrame/src'; | |
| load. |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| orders := DataFrame | |
| withRows: | |
| #( ( 1 '07/04/1776' '$234.56' 1 ) | |
| ( 2 '03/14/1760' '$78.50' 3 ) | |
| ( 3 '05/23/1784' '$124.00' 2 ) | |
| ( 4 '09/03/1790' '$65.50' 3 ) | |
| ( 5 '07/21/1795' '$25.50' 10 ) | |
| ( 6 '11/27/1787' '$14.40' 9 ) ) | |
| columnNames: #( order_id order_date amount customer_id ). |
olekscode
/ inner-join.st
Last active
August 2, 2019 23:49
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| | customers orders | | |
| customers innerJoin: orders on: 'customer_id'. |
olekscode
/ customers.csv
Last active
August 2, 2019 23:42
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| customer_id | first_name | last_name | ||
|---|---|---|---|---|
| 1 | George | Washington | gwashington@usa.gov | |
| 2 | John | Adams | jadams@usa.gov | |
| 3 | Thomas | Jefferson | tjefferson@usa.gov | |
| 4 | James | Madison | jmadison@usa.gov | |
| 5 | James | Monroe | jmonroe@usa.gov |
olekscode
/ orders.csv
Last active
August 2, 2019 23:41
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| order_date | amount | customer_id | |
|---|---|---|---|
| 07/04/1776 | $234.56 | 1 | |
| 03/14/1760 | $78.50 | 3 | |
| 05/23/1784 | $124.00 | 2 | |
| 09/03/1790 | $65.50 | 3 | |
| 07/21/1795 | $25.50 | 10 | |
| 11/27/1787 | $14.40 | 9 |
olekscode
/ read-customers-orders.st
Created
August 2, 2019 15:43
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| | dataFolder customersFile ordersFile customers orders | | |
| dataFolder := '/Users/oleks/Desktop/' asFileReference. | |
| customersFile := dataFolder / 'customers.csv'. | |
| ordersFile := dataFolder / 'orders.csv'. | |
| customers := DataFrame readFromCsv: customersFile. | |
| orders := DataFrame readFromCsv: ordersFile. |
OlderNewer