Search for a command to run...
Articles tagged with #google-colab
Pandas DataFrame is a two-dimensional, size-mutable, tabular data which may contain labeled rows and columns. DataFrame is useful for tabular data manipulation. The class syntax includes four parameters that are the data, index, columns, data type an...
Create sample dataframe import pandas as pd from io import StringIO SAMPLEDATA = StringIO(''' tweet_id,sentiment,author,content 1956967341,"empty","xoshayzers","@tiffanylue i know i was listenin to bad habit earlier and i started freakin at his part...
Get JSON from remote link and load into pandas data frame # load the remote data into a Pandas DataFrame import pandas as pd df = pd.read_json('https://archive.org/download/crowdflower/text_emotion.json', encoding='latin-1') df see colab example Get ...
Load remote CSV data into a Pandas DataFrame # load the remote data into a Pandas DataFrame import pandas as pd df = pd.read_csv('https://archive.org/download/crowdflower/text_emotion.csv', on_bad_lines='skip', encoding='latin-1') df colab example Up...
Execute SQL statement directly in Colab Cell Load Sqlite Extension %load_ext sql Connect to Sqlite Database %%sql sqlite:///test.db Execute SQL statement create table demo(id int, title varchar); insert into demo values (1,'pqr'),(2,'stu'); select * ...
