Your browser does not seem to support JavaScript. As a result, your viewing experience will be diminished, and you may not be able to execute some actions.

Please download a browser that supports JavaScript, or enable it if it's disabled (i.e. NoScript).

Is there any way in Python 3.5 to read dbf files?

M
magpie QA Engineer last edited by
DBF database available. More specifically, it's a database 1c 7.7 (i.e., it's actually FoxPro). It has tables that simply select lines on some very simple criterion and return them as a list. Started to study the documentation, and it turns out that the readings of dbf-fails at Python 3.5 are virtually non-existent. Experiments with the library dbf failed:
```
table = dbf.Table('SC8454.dbf') # работает, однако уже следующая строка
for item in table: # выдаст исключение 'E:\1\sklad_2006\SC8454.dbf is closed; record 0 is unavailable'
    print(item)
```
Tell me if I'm wrong, and Python 3.5 still has any reliable means to read dbf files?
Reply Quote 0
1 Reply Last reply
E
elysha last edited by
Before you need a line: table.open()
```
table = dbf.Table('SC8454.dbf')
table.open()
for item in table:
    print(item)
```
Reply Quote 0
1 Reply Last reply

2
Posts

0
Views

Suggested Topics

White reading WAV file on Python
Software Programming • python python 3.x wav • • emmalee

2

0
Votes

2
Posts

0
Views

E

It's most likely to be easier to use scipy, there's a ready function. https://docs.scipy.org/doc/scipy-0.14.0/reference/generated/scipy.io.wavfile.read.html To read the wav-files.
S

Read the file quickly and retriev e-mails
Software Programming • python python 3.x regular expressions python 3.5 • • simrah

2

0
Votes

2
Posts

0
Views

K

Bad idea to do findall 'cause he's downloading all the results into one set.results = re.findall(look_for, my_text) It's better for these data. https://docs.python.org/3/library/re.html#re.finditer In your case, it's just a substitute for:results = re.finditer(look_for, my_text) And read the file fast, you can just read the built-in terator:for line in my_file: ...
K

Open and read files from a server by SSH from python and paramiko
Software Programming • python ssh • • Kadyn

2

0
Votes

2
Posts

0
Views

Here is a simple example of how to use Paramiko to establish a connection with the SSH server and use that connection to read a series of files (in this case I have chosen to read those that have extensions .c). In this example I simply read the contents to show how many bytes they have, but you can do what you need with the content, once read.import paramiko Abrir el transporte host = "ip.de.tu.servidor" port = 22 transport = paramiko.Transport((host, port)) Autenticarse en el servidor SOLO COMO DEMO, NUNCA SE DEBEN PONER CLAVES EN EL CÓDIGO username = "usuario" password = "contraseña" transport.connect(username = username, password = password) Creación del canal sftp sftp = paramiko.SFTPClient.from_transport(transport) Recorrer los ficheros existentes en el home del usuario for name in sftp.listdir("."): if name.endswith(".c"): # Si termina en .c, lo leemos with sftp.file(name) as f: data = f.read() # Mostramos cuántos bytes hemos leido print(f"El fichero {name} tiene {len(data)} bytes") Cerrar el canal y después el transporte sftp.close() transport.close()
T

I want to read and use a list of float written in a file in Python
Software Programming • python • • Trenton

2

0
Votes

2
Posts

0
Views

Do you want to create files in text/binaries?Here is an example of simple file input and output.For more information about each API, see Python reference. https://docs.python.org/ja/3/tutorial/inputoutput.html The text can be read and written directly by the end user, but it is difficult to implement validation when loading. In addition, in the case of floating point number, there is a case where error occurs when output by 10decimal number. It is better to make as large as possible, but the file size tends to be larger. In terms of scalability and self-descriptability, we may use format corresponding to hierarchy such as XML format.バイナリs can reduce file size and have a relatively easy implementation of read validation, but they are not suitable for end users to read and write. In terms of interoperability between systems, it is necessary to consider the internal representation of、al values,structThe module uses a floating-point binary representation that conforms to IEE 754, regardless of the implementation of the platform, which ensures portability and portability. https://docs.python.org/ja/3/library/struct.html import os import struct def printFilePathAndSize(path): print('Path = "%s", Size = %d [bytes]' % (path, os.path.getsize(path))) path1 = 'test.txt' path2 = 'test.bin' srcList = [-10.5, -0.01, 0, 0.1, 0.2, 0.3, 0.4] (1) Text format. with open(path1, encoding='utf-8', mode='w') as f: for x in srcList: f.write(format(x, '.15e') + '\n') printFilePathAndSize(path1) dstList = [] with open(path1, encoding='utf-8', mode='r') as f: while True: line = f.readline() if not line: break; dstList.append(float(line)) # For test. print(line.replace('\r', '').replace('\n', '')) print(dstList) (2) Binary format. structOfDoubleFloat = struct.Struct('d') with open(path2, mode='wb') as f: for x in srcList: f.write(structOfDoubleFloat.pack(x)) printFilePathAndSize(path2) dstList = [] with open(path2, mode='rb') as f: while True: binData = f.read(8) if not binData: break; # Get the first element of tuple. dstList.append((structOfDoubleFloat.unpack(binData))[0]) print(dstList)
P

Concatenar byte with string in Python 3.5.2
Software Programming • python python 3.x arduino • • Pearlaqua

2

0
Votes

2
Posts

0
Views

Z

It's as simple as converting from bytes a str (by default, encoded in utf-8(c):print(temperatura.decode() + ',' + time_hhmmss + ',' + date_mmddyyyy) Although you can improve a little more:from datetime import datetime temperatura = ser.readline() print("{} ºC, {:%H:%M:%S, %d/%m/%Y}".format(temperatura.decode(), datetime.now())
K

The code doesn't work.
Software Programming • python python 2.7 python 3.6 python 3.5 • • kalyn

2

0
Votes

2
Posts

0
Views

M

If it's right Discharge and add continue At the error of entry, everything works as necessary:import random while True: print('Вы играете в камень ножницы бумага. к - камень, н - ножницы, б - бумага. Чтобы выйти напишите: выход.') player = input('Вы выбрали:') if player not in ['к', 'н', 'б', 'выход']: print('Не правильный ввод!') continue # добавлено if player == 'выход': break; gen = {1:'к', 2:'н', 3:'б'} comp_choice = gen[random.randint(1, 3)] print(f'Бот выбрал: {comp_choice}') win_combination = [('к','н'),('н','б'),('б','к')] if player == comp_choice: print('Ничья') elif (player,comp_choice) in win_combination: print('Игрок победил') else: print('Победа бота') Example of conclusion:Вы играете в камень ножницы бумага. к - камень, н - ножницы, б - бумага. Чтобы выйти напишите: выход. Вы выбрали:ь Не правильный ввод! Вы играете в камень ножницы бумага. к - камень, н - ножницы, б - бумага. Чтобы выйти напишите: выход. Вы выбрали:б Бот выбрал: к Игрок победил Вы играете в камень ножницы бумага. к - камень, н - ножницы, б - бумага. Чтобы выйти напишите: выход. Вы выбрали:к Бот выбрал: к Ничья Вы играете в камень ножницы бумага. к - камень, н - ножницы, б - бумага. Чтобы выйти напишите: выход. Вы выбрали:н Бот выбрал: б Игрок победил Вы играете в камень ножницы бумага. к - камень, н - ножницы, б - бумага. Чтобы выйти напишите: выход. Вы выбрали:выход
C

Python3 for Linux.
Software Programming • linux python 3.5 cross compiling compiling • • charlenef

2

0
Votes

2
Posts

0
Views

T

The erroneous report says:cpython-35m-arm-linux-gnueabihf.so: undefined symbol: PySlice_AdjustIndicesThat's from the library. cpython-35m-arm-linux-gnueabihf.so Function PySlice_AdjustIndicesthat a lynker can't find anywhere. The reason is most likely to be to differ the versions of the libraries expected in the collection and real libraries of the Toolbox.When you're drowned ♪ /configure Before the assembly was launched, didn't notice - there were no reports on the subject?
G

How to open a .TXT file with python and manage file names?
Software Programming • python 3.x • • guilherme

2

0
Votes

2
Posts

0
Views

B

Solution: As all I needed was the names of the files. Previous to this I had created a TXT from the terminal. But researching on the web I hit with a possible solution, and it's the following:from os import listdir from os.path import isfile, join jpgs = [arch for arch in listdir('P:/test/') if isfile(join('P:/test/', arch))] in jpgs the name of the files they were looking to control is saved.
R

How do you read a line from the Python text file?
Software Programming • python • • rosemadder

2

0
Votes

2
Posts

0
Views

M

Read the lines on the list:with open('file.txt') as fp: lines = fp.readlines() Then use it.print(lines[i])
Launch of the terminal
Software Programming • python macos python 3.5 • • Demir

2

0
Votes

2
Posts

0
Views

Y

(1) Start the terminal.(2) Go over to the file with the file, performing the following team:cd <путь/к/запускаемому/файлу/> (3) Now we start the file with the next team:python3 <имя_файла>.py (4) Wait till the file is finished.(5) Close the terminal:P.S. "Put statue" doesn't have to be written.P.S.S.S. If you need to use pseudonyms without python3.Pseudonyms in Unix have the following syntax: alias <псевдоним> = '<команда>'In your case, the team will look like this: alias <имя файла> = 'python3 <имя файла>'The pseudonym thus created will work until the end of the session.To establish permanent aliases, UNIX recommends the use of file ~/.bash_aliases, but Mac OS X does not process the file. They can therefore be added to the file ~/.bash_profile. Details on pseudonyms here:osxh.ru/terminal/command/alias
R

How can I read a .csv file in visual studio code using python?
Software Programming • python python 3.8 • • rielyn

2

0
Votes

2
Posts

0
Views

A

To open a .csv, it is more comfortable to use the PANDAS library, commonly as import pandas as pd. I don't know if Visual Studio already comes with this library installed, but if not I leave the link to you: https://pandas.pydata.org/ To open the .csv with that library just type: [variable] = pd.read_csv('[nombre de tu archivo].csv') If you still need to use the with open [nombre de tu archivo].csvmake sure you have the .csv extension inside string in which you specify it.I hope it worked out for you.
We need to remove the list element.
Software Programming • python 3.5 • • Alberto

2

0
Votes

2
Posts

0
Views

A

The point is, after the removal of the elements from the start of the list, the indices of the remaining elements are altered and its length is reduced, so in the end you're trying to contact elements outside the list. The correct solution will be to remove from the beginning and from the end:def modify_list(n): s = "" for i in range(len(n)): if n[i] % 2 == 0: n[i] = n[i] // 2 elif n[i] % 2 > 0: s += str(i) for j in reversed(s): b = int(j) del n[b] return n les = [1,2,3,4,5,6,7,8,9] print(modify_list(les)) If you look deeper, it's wrong to keep the indices in the line, and it's better to use the list:def modify_list(n): s = [] for i in range(len(n)): if n[i] % 2 == 0: n[i] = n[i] // 2 elif n[i] % 2 > 0: s.append(i) for j in reversed(s): del n[j] return n les = [1,2,3,4,5,6,7,8,9] print(modify_list(les)) We'll optimize it more. Condition n[i] % 2 > 0 will always be implemented, so it can be deleted. Then we'll use the roster generator:def modify_list(n): return [x // 2 for x in n if x % 2 == 0] les = [1,2,3,4,5,6,7,8,9] print(modify_list(les)) It should be borne in mind that the last code does not modify the reference list but creates a new one.
R

How do you connect the files to PyQt5?
Software Programming • python python 3.x pyqt5 pyqt python 3.5 • • rosemadder

2

0
Votes

2
Posts

0
Views

Try this:foody.pyimport sys #import subprocess from PyQt5 import QtCore, QtGui, QtWidgets from food import Ui_MainWindow # <-- | # | # V class MyWindow(QtWidgets.QMainWindow, Ui_MainWindow): def init(self, rows): super(MyWindow, self).init() self.rows = rows self.setupUi(self) self.pushButton.clicked.connect(self.set_row_count) self.tableWidget.cellChanged.connect(self.cell_changed) def set_row_count(self): self.rows += 1 print(self.rows) self.tableWidget.setRowCount(self.rows) def cell_changed(self, row, column): _sum = 0 if 1 < column < 7: for column in range(2, 7): if self.tableWidget.item(row, column) != None: try: _sum += int(self.tableWidget.item(row, column).text()) except: pass _bud = 0 if self.tableWidget.item(row, 1) != None: _bud = int(self.tableWidget.item(row, 1).text()) ost = _bud - _sum self.tableWidget.setItem(row, 7, QtWidgets.QTableWidgetItem(str(ost))) number_rows = 1 if name == 'main': app = QtWidgets.QApplication(sys.argv) w = MyWindow(number_rows) w.show() sys.exit(app.exec_())
Django Python downloading files on the page
Software Programming • python django python 3.5 • • Bogopo

2

0
Votes

2
Posts

0
Views

G

If the challenge is to show the top of the downloaded picture, it is done on the page with javascript, it can be done as https://stackoverflow.com/questions/4459379/preview-an-image-before-it-is-uploaded If you need to show the user the picture that he downloaded on the server through the form, then this picture needs to be stored on the server first and made available on the reference, and then return the link. <img src="{}"> it shall be automatically downloaded and disfigured to the user.
C

DetailVeiw does not display data
Software Programming • django python 3.5 • • courtlanda

2

0
Votes

2
Posts

0
Views

Determined content in the "base.html" cap?Try and replace{% block content%} {{object.text}} {{object.date}} {% endblock%} ♪{% block content%} test {{object.text}} {{object.date}} {% endblock%} Did the "test" paragraph appear in the template?

Is there any way in Python 3.5 to read dbf files?

Suggested Topics

White reading WAV file on Python Software Programming • python python 3.x wav • • emmalee

Read the file quickly and retriev e-mails Software Programming • python python 3.x regular expressions python 3.5 • • simrah

Open and read files from a server by SSH from python and paramiko Software Programming • python ssh • • Kadyn

I want to read and use a list of float written in a file in Python Software Programming • python • • Trenton

Concatenar byte with string in Python 3.5.2 Software Programming • python python 3.x arduino • • Pearlaqua

The code doesn't work. Software Programming • python python 2.7 python 3.6 python 3.5 • • kalyn

Python3 for Linux. Software Programming • linux python 3.5 cross compiling compiling • • charlenef

How to open a .TXT file with python and manage file names? Software Programming • python 3.x • • guilherme

How do you read a line from the Python text file? Software Programming • python • • rosemadder

Launch of the terminal Software Programming • python macos python 3.5 • • Demir

How can I read a .csv file in visual studio code using python? Software Programming • python python 3.8 • • rielyn

We need to remove the list element. Software Programming • python 3.5 • • Alberto

How do you connect the files to PyQt5? Software Programming • python python 3.x pyqt5 pyqt python 3.5 • • rosemadder

Django Python downloading files on the page Software Programming • python django python 3.5 • • Bogopo

DetailVeiw does not display data Software Programming • django python 3.5 • • courtlanda

White reading WAV file on Python
Software Programming • python python 3.x wav • • emmalee

Read the file quickly and retriev e-mails
Software Programming • python python 3.x regular expressions python 3.5 • • simrah

Open and read files from a server by SSH from python and paramiko
Software Programming • python ssh • • Kadyn

I want to read and use a list of float written in a file in Python
Software Programming • python • • Trenton

Concatenar byte with string in Python 3.5.2
Software Programming • python python 3.x arduino • • Pearlaqua

The code doesn't work.
Software Programming • python python 2.7 python 3.6 python 3.5 • • kalyn

Python3 for Linux.
Software Programming • linux python 3.5 cross compiling compiling • • charlenef

How to open a .TXT file with python and manage file names?
Software Programming • python 3.x • • guilherme

How do you read a line from the Python text file?
Software Programming • python • • rosemadder

Launch of the terminal
Software Programming • python macos python 3.5 • • Demir

How can I read a .csv file in visual studio code using python?
Software Programming • python python 3.8 • • rielyn

We need to remove the list element.
Software Programming • python 3.5 • • Alberto

How do you connect the files to PyQt5?
Software Programming • python python 3.x pyqt5 pyqt python 3.5 • • rosemadder

Django Python downloading files on the page
Software Programming • python django python 3.5 • • Bogopo

DetailVeiw does not display data
Software Programming • django python 3.5 • • courtlanda