ivansaul

import pandas as pd
import requests

url= 'https://gitlab.com/username/repo/-/raw/master/data.xlsx'
myfile = requests.get(url)

df=pd.read_excel(myfile.content)
print(df)

ivansaul

Rank,Title,Genre,Description,Director,Actors,Year,Runtime (Minutes),Rating,Votes,Revenue (Millions),Metascore
1,Guardians of the Galaxy,"Action,Adventure,Sci-Fi",A group of intergalactic criminals are forced to work together to stop a fanatical warrior from taking control of the universe.,James Gunn,"Chris Pratt, Vin Diesel, Bradley Cooper, Zoe Saldana",2014,121,8.1,757074,333.13,76
2,Prometheus,"Adventure,Mystery,Sci-Fi","Following clues to the origin of mankind, a team finds a structure on a distant moon, but they soon realize they are not alone.",Ridley Scott,"Noomi Rapace, Logan Marshall-Green, Michael Fassbender, Charlize Theron",2012,124,7,485820,126.46,65
3,Split,"Horror,Thriller",Three girls are kidnapped by a man with a diagnosed 23 distinct personalities. They must try to escape before the apparent emergence of a frightful new 24th.,M. Night Shyamalan,"James McAvoy, Anya Taylor-Joy, Haley Lu Richardson, Jessica Sula",2016,117,7.3,157606,138.12,62
4,Sing,"Animation,Comedy,Family","In a city of humano

ivansaul

MoviePy

Source: MoviePy

Installation:

pip install moviepy

Python script:

from moviepy.editor import VideoFileClip, concatenate_videoclips

ivansaul

ivansaul

'''
After making more than 10,000 queries, I realized that 
each successful query takes a maximum of 15 iterations, 
taking an average 1 second.
'''

import googletrans
from googletrans import Translator
def en_es(palabra):
    translator = Translator()

ivansaul

import discord
from discord.ext import commands

#add this line
intents=intents=discord.Intents.all()

#if the above don't work, try with this
#intents = discord.Intents()
#intents.members = True

ivansaul

#!/usr/bin/python
from PyPDF2 import PdfFileReader, PdfFileWriter
#split range
pgi=30 #start
pgf=37 #end

pdf_document = "test.pdf"
pdf = PdfFileReader(pdf_document)
pdf_writer = PdfFileWriter()
for page in range(pgi-1,pgf):