Differences

This shows you the differences between two versions of the page.

--- 11_26_2018 [2018/11/26 21:18] – cynthia.kahn
+++ 11_26_2018 [2018/11/26 21:26] – cynthia.kahn
@@ Line 4: / Line 4: @@
   *  Two new tables  created : users_info and entities_info
   *  All python files and parsed files are in /home/cynthiak on deepml.cs.gsu.edu
+**//Some useful commands for handling tweets dataset//**
+sed 's.@..g' old_filename > new_filename \\
+sed -n 'line_numberp;line_number+1q' filename \\
+sed '997s/@vidavictoriosa/vidavictoriosa/' old_filename > new_filename \\
+\\
+**//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  \\
+);