Assuming that i have the following list
fruits=['mango','apple','orange','peach'] and from this list I want to create a new list randomly selecting specific number of values
then this is how it is being done for two random values of the fruits list
import random
random_fruits = random.choices(fruits, k=2)which results to
fruits=['mango','peach'] You can export Python environment installed packages, so that you can installed it afterwards in a new environment, for example when using virtual environments.
pip freeze > requirements.txt
And then in order to install the packages in the new environment use the following:
pip install -r requirements.txt
The below snippet allows you to create an sqlite3 database and then import data to it.
import sqlite3
#this connects and creates the database.db file, in the same location where the script exists
conn = sqlite3.connect(database.db)
c = conn.cursor()
#execute the create table
c.execute('''CREATE TABLE IF NOT EXISTS mytable
(filename text,
language text,
year text,
summary text,
rating real)''')
#this is the dataset i will save to database as a python list:
data=['firstfile.mov','en','2018','This is a short summary of the video','3.8']
#get the data in the database
c.execute('INSERT INTO mytable VALUES (?,?,?,?,?)', data)
#close the connection
conn.commit()
conn.close()