Posts by Guilherme Alves • 24 points
6 posts
-
-1
votes1
answer50
viewsA: Concatenate numbers into a python csv file
df["FONE1"] = df["FONE1"].apply(lambda x: '{0:5>13}'.format(x))
pythonanswered Guilherme Alves 24 -
-1
votes1
answer486
viewsA: How to open a . sql file in pandas?
import sqlite3 conn = sqlite3.connect('teste.db') cursor = conn.cursor() # inserindo dados na tabela cursor.execute("select * from banco")
-
0
votes1
answer361
viewsA: Python error locale
I managed to solve using lambda: data["Valor"] = data.Valor.apply(lambda x: locale.currency(x, grouping=True, symbol=None))
-
0
votes1
answer361
viewsQ: Python error locale
locale.setlocale(locale.LC_ALL, "Portuguese_Brazil.1252") data = pd.read_excel('C:/Users/t714591/Videos/bancos/base.xlsx') data["Valor"] = locale.currency(data["Valor"], grouping=True, symbol=None)…
-
-2
votes1
answer53
viewsQ: import PYTHON / PANDAS
I need to import a txt and take only a few characters as below: Text: 000524WEQWE256243443507AFDAF1698100005891710232323062 Code: a = (0, 6) = 000524 b = (6, 5) = WEQWE…
-
-1
votes1
answer56
viewsQ: Python pandas import
I have this import and then set the columns I want. I can in the import itself set the columns I want? import pandas as pd…