Differences
This shows you the differences between two versions of the page.
Next revision | Previous revision | ||
02_04_2019 [2019/02/04 22:48] – created cynthia.kahn | 02_04_2019 [2019/02/04 23:23] (current) – cynthia.kahn | ||
---|---|---|---|
Line 2: | Line 2: | ||
=== Database and Web === | === Database and Web === | ||
- | * Created Student Application Portal, Slate | + | * Created |
+ | - Frontend - REACT Framework\\ | ||
+ | - Backend - Python, Flask\\ | ||
+ | - Database - PostgreSQL\\ | ||
+ | //The Project can be found here [[ https:// | ||
+ | \\ | ||
+ | \\ | ||
+ | === Deep Learning === | ||
- | **//Some useful commands for handling tweets dataset//** | + | * Worked with shallow classifiers like KNN\\ |
+ | * Implemented Loss functions for SVM, Softmax and Full Loss\\ | ||
+ | //Codes coming soon// | ||
+ | \\ | ||
+ | \\ | ||
+ | === Operating System === | ||
- | sed ' | + | * Created Project Proposal on Biometric SmartCard OS |
- | sed -n ' | + | |
- | sed ' | + | |
- | \\ | + | |
- | **//SQL to create table users_info// | + | |
- | \\ | + | |
- | DROP TABLE IF EXISTS users_info; \\ | + | |
- | \\ | + | |
- | CREATE TABLE users_info( \\ | + | |
- | userID BIGINT, | + | |
- | userName TEXT, | + | |
- | screenName TEXT, | + | |
- | userLocation TEXT, | + | |
- | url TEXT, | + | |
- | description TEXT, | + | |
- | translatorType TEXT, | + | |
- | protected TEXT, | + | |
- | verified TEXT, | + | |
- | followersCount INTEGER, | + | |
- | friendsCount INTEGER, | + | |
- | listedCount INTEGER, | + | |
- | favouritesCount INTEGER, | + | |
- | statusesCount INTEGER, | + | |
- | userCreated VARCHAR(50), | + | |
- | utcOffset TEXT, | + | |
- | userTimeZone VARCHAR(50), | + | |
- | geoEnabled TEXT, | + | |
- | lang TEXT, | + | |
- | contributorsEnabled TEXT, | + | |
- | isTranslator TEXT, | + | |
- | profileBackgroundColor TEXT, | + | |
- | profileBackgroundImageURL TEXT, | + | |
- | profileBackgroundTile TEXT, | + | |
- | profileLinkColor TEXT, | + | |
- | profileSidebarBorderColor TEXT, | + | |
- | profileSidebarFillColor TEXT, | + | |
- | profileTextColor TEXT, | + | |
- | profileUseBackgroundImage TEXT, | + | |
- | profileImageURL TEXT, | + | |
- | defaultProfile TEXT, | + | |
- | defaultProfileImage TEXT, | + | |
- | userFollowing TEXT, | + | |
- | followRequestSent TEXT, | + | |
- | notifications TEXT | + | |
- | ); | + | |
- | \\ | + | === SmartAPI === |
- | psql cynthiak | + | |
- | \copy users_info FROM '/ | + | |
- | \\ | + | * Created ER diagrams of the FAERS and AEOLUS DBs |
- | **//SQL to create table entities_info// | + | |
- | \\ | + | * Currently working on completing a database connection and the service call implementations. |
- | DROP TABLE IF EXISTS entities_info; | + | |
- | \\ | + | |
- | CREATE TABLE entities_info( \\ | + | |
- | | + | |
- | entitiesURL TEXT, | + | |
- | userMentionsID1 BIGINT, | + | |
- | userMentionsID2 BIGINT, | + | |
- | symbols TEXT, | + | |
- | entitiesMediaID BIGINT, | + | |
- | entitiesMediaIndices TEXT, | + | |
- | entitiesMediaURL TEXT, | + | |
- | entitiesType TEXT, | + | |
- | entitiesSizeSmall TEXT, | + | |
- | entitiesSizeMedium TEXT, | + | |
- | entitiesSizeThumb TEXT, | + | |
- | entitiesSizeLarge TEXT, | + | |
- | extendedEntitiesMediaID BIGINT, | + | |
- | extendedEntitiesMediaIndices TEXT, | + | |
- | extendedEntitiesMediaURL TEXT, | + | |
- | extendedDisplayURL TEXT, | + | |
- | extendedExpandedURL TEXT, | + | |
- | extendedEntitiesType TEXT, | + | |
- | extendedSizeSmall TEXT, | + | |
- | extendedSizeMedium TEXT, | + | |
- | extendedSizeThumb TEXT, | + | |
- | extendedSizeLarge TEXT | + | |
- | ); | + | |
- | + | ||
- | \\ | + | |
- | psql cynthiak | + | |
- | \copy entities_info FROM '/ | + | |